This work is licensed under a Creative Commons Attribution-NonCommercial 2.5 License.


Self Service HR rollout Script 2 to create users

CREATE OR REPLACE PACKAGE xx_sshr_allocate_resp_pkg IS
  PROCEDURE run(errbuf                        OUT VARCHAR2
               ,retcode                       OUT VARCHAR2
               ,p_responsibility_name         IN VARCHAR2
               ,p_person_type                 IN VARCHAR2
               ,p_cost_centre_group_1                   IN VARCHAR2
               ,p_cost_centre_group_2                   IN VARCHAR2
               ,p_parent_org_1                      IN VARCHAR2
               ,p_parent_org_2                      IN VARCHAR2
               ,p_cid                         IN VARCHAR2
               ,p_read_only_flag              IN VARCHAR2
               ,p_test_ceration_email_address IN VARCHAR2);

  PROCEDURE send_html_email(p_to            IN VARCHAR2
                           ,p_from          IN VARCHAR2
                           ,p_subject       IN VARCHAR2
                           ,p_text          IN VARCHAR2 DEFAULT NULL
                           ,p_html          IN VARCHAR2 DEFAULT NULL
                           ,p_smtp_hostname IN VARCHAR2
                           ,p_smtp_portnum  IN VARCHAR2);

  PROCEDURE create_fnd_user_for_cid(p_user_name          IN VARCHAR2
                                   ,p_person_id          IN INTEGER
                                   ,p_email_address      IN VARCHAR2
                                   ,p_person_description IN VARCHAR2
                                   ,p_password           OUT VARCHAR2);

  FUNCTION get_fu_name(p_nt_login IN VARCHAR2) RETURN VARCHAR2;

  PROCEDURE send_email_to_new_user(p_icdp       IN ic_coll_dir_pull%ROWTYPE
                                  ,p_user_name  IN VARCHAR2
                                  ,p_password   IN VARCHAR2
                                  ,p_test_email IN VARCHAR2);
END xx_sshr_allocate_resp_pkg;

Comments on "Self Service HR rollout Script 2 to create users"

 

post a comment