PACKAGE: APPS.JTF_RS_RES_SSWA_PUB_W

Source

1 package jtf_rs_res_sswa_pub_w as
2   /* $Header: jtfrsrws.pls 120.0 2005/05/11 08:21:53 appldev ship $ */
3   procedure create_emp_resource(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , p_commit  VARCHAR2
6     , p_source_first_name  VARCHAR2
7     , p_source_last_name  VARCHAR2
8     , p_source_middle_name  VARCHAR2
9     , p_employee_number  VARCHAR2
10     , p_source_sex  VARCHAR2
11     , p_source_title  VARCHAR2
12     , p_source_job_id  NUMBER
13     , p_source_email  VARCHAR2
14     , p_source_start_date  date
15     , p_source_end_date  date
16     , p_user_name  VARCHAR2
17     , p_source_address_id  NUMBER
18     , p_source_office  VARCHAR2
19     , p_source_mailstop  VARCHAR2
20     , p_source_location  VARCHAR2
21     , p_source_phone  VARCHAR2
22     , p_salesrep_number  VARCHAR2
23     , p_sales_credit_type_id  NUMBER
24     , p_source_mgr_id  NUMBER
25     , x_resource_id out NOCOPY  NUMBER
26     , x_return_status out NOCOPY  VARCHAR2
27     , x_msg_count out NOCOPY  NUMBER
28     , x_msg_data out NOCOPY  VARCHAR2
29     , p_called_from  VARCHAR2
30     , p_user_password in out NOCOPY  VARCHAR2
31   );
32   procedure update_resource(p_api_version  NUMBER
33     , p_init_msg_list  VARCHAR2
34     , p_commit  VARCHAR2
35     , p_resource_id  NUMBER
36     , p_resource_number  VARCHAR2
37     , p_resource_name  VARCHAR2
38     , p_source_name  VARCHAR2
39     , p_address_id  VARCHAR2
40     , p_source_office  VARCHAR2
41     , p_source_mailstop  VARCHAR2
42     , p_source_location  VARCHAR2
43     , p_source_phone  VARCHAR2
44     , p_source_email  VARCHAR2
45     , p_object_version_number  NUMBER
46     , p_approved  VARCHAR2
47     , p_source_job_id  NUMBER
48     , p_source_job_title  VARCHAR2
49     , p_salesrep_number  VARCHAR2
50     , p_sales_credit_type_id  NUMBER
51     , p_end_date_active  date
52     , p_user_id  NUMBER
53     , p_user_name  VARCHAR2
54     , p_mgr_resource_id  NUMBER
55     , p_org_id  NUMBER
56     , x_return_status out NOCOPY  VARCHAR2
57     , x_msg_count out NOCOPY  NUMBER
58     , x_msg_data out NOCOPY  VARCHAR2
59     , p_time_zone  NUMBER
60     , p_cost_per_hr  NUMBER
61     , p_primary_language  VARCHAR2
62     , p_secondary_language  VARCHAR2
63     , p_support_site_id  NUMBER
64     , p_source_mobile_phone  VARCHAR2
65     , p_source_pager  VARCHAR2
66   );
67 end jtf_rs_res_sswa_pub_w;