1 PACKAGE per_ri_config_datapump_entity AUTHID CURRENT_USER AS
2 /* $Header: perridpe.pkh 120.2.12010000.3 2008/12/16 10:26:51 psengupt ship $ */
3
4 TYPE location_rec IS RECORD (location_string varchar2(3200));
5
6 TYPE location_tab IS TABLE OF
7 location_rec
8 INDEX BY BINARY_INTEGER;
9
10 TYPE country_rec IS RECORD (territory_code varchar2(60));
11
12 TYPE country_tab IS TABLE OF
13 country_rec
14 INDEX BY BINARY_INTEGER;
15
16 l_country_tab country_tab;
17
18 PROCEDURE create_locations_batch_lines
19 (p_configuration_code in varchar2
20 ,p_batch_header_id in number
21 ,p_multiple_config_upload in boolean default FALSE
22 ,p_technical_summary_mode in boolean default FALSE
23 ,p_location_tab in out nocopy per_ri_config_tech_summary.location_tab
24 );
25
26 PROCEDURE create_enterprise_batch_lines
27 (p_configuration_code in varchar2
28 ,p_batch_header_id in number
29 ,p_multiple_config_upload in boolean default FALSE
30 ,p_technical_summary_mode in boolean default FALSE
31 ,p_org_ent_tab in out nocopy per_ri_config_tech_summary.org_ent_tab
32 ,p_org_ent_class_tab in out nocopy per_ri_config_tech_summary.org_ent_class_tab
33 ,p_org_hierarchy_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_tab
34 ,p_profile_dpe_ent_tab in out nocopy per_ri_config_tech_summary.profile_dpe_ent_tab
35 );
36
37 PROCEDURE create_oper_comp_batch_lines
38 (p_configuration_code in varchar2
39 ,p_batch_header_id in number
40 ,p_multiple_config_upload in boolean default FALSE
41 ,p_technical_summary_mode in boolean default FALSE
42 ,p_org_oc_tab in out nocopy per_ri_config_tech_summary.org_oc_tab
43 ,p_org_oc_class_tab in out nocopy per_ri_config_tech_summary.org_oc_class_tab
44 ,p_org_hierarchy_ele_oc_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_oc_tab
45 );
46
47 PROCEDURE create_le_batch_lines
48 (p_configuration_code in varchar2
49 ,p_batch_header_id in number
50 ,p_multiple_config_upload in boolean default FALSE
51 ,p_technical_summary_mode in boolean default FALSE
52 ,p_org_le_tab in out nocopy per_ri_config_tech_summary.org_le_tab
53 ,p_org_le_class_tab in out nocopy per_ri_config_tech_summary.org_le_class_tab
54 ,p_org_hierarchy_ele_le_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_le_tab
55 );
56 PROCEDURE create_bg_batch_lines
57 (p_batch_header_id in number
58 ,p_configuration_code in varchar2
59 ,p_country_tab_out in out nocopy country_tab
60 ,p_multiple_config_upload in boolean default FALSE
61 ,p_technical_summary_mode in boolean default FALSE
62 ,p_bg_tab in out nocopy per_ri_config_tech_summary.bg_tab
63 ,p_sg_tab in out nocopy per_ri_config_tech_summary.sg_tab
64 ,p_post_install_tab in out nocopy per_ri_config_tech_summary.post_install_tab
65 ,p_int_bg_resp_tab in out nocopy per_ri_config_fnd_hr_entity.int_bg_resp_tab
66 );
67
68
69 END per_ri_config_datapump_entity;