1 PACKAGE pqp_gb_tp_ext_process AS
2 -- /* $Header: pqpgbtpext.pkh 120.0 2005/05/29 02:20:59 appldev noship $ */
3 --
4 --
5
6 --
7 -- Type Definitions
8 --
9 TYPE t_request_ids_type IS TABLE OF fnd_concurrent_requests.request_id%TYPE
10 INDEX BY BINARY_INTEGER;
11
12 --
13 -- Globals
14 --
15 g_extract_type fnd_lookups.lookup_code%type;
16 g_extract_udt_name pay_user_tables.user_table_name%type;
17 g_report_type VARCHAR2(10);
18 g_lea_business_groups pqp_gb_t1_pension_extracts.t_all_bgs_type;
19 g_request_ids t_request_ids_type;
20 g_execution_mode VARCHAR2(10) := 'PARALLEL'; -- Or SERIAL
21 g_wait_interval NUMBER := 60; -- seconds
22 g_max_wait NUMBER := 0; -- Meaning no time out
23
24 g_proc_name VARCHAR2(61) := 'pqp_gb_tp_ext_process.';
25 g_debug BOOLEAN := hr_utility.debug_enabled;
26 g_master_request_id fnd_concurrent_requests.request_id%TYPE;
27
28 -- Bugfix 3671727:ENH1: Added this new global
29 g_lea_number VARCHAR2(3):=RPAD(' ',3,' ');
30
31 -- Debug
32 PROCEDURE DEBUG (
33 p_trace_message IN VARCHAR2
34 ,p_trace_location IN NUMBER DEFAULT NULL
35 );
36
37 -- Debug_Enter
38 PROCEDURE debug_enter (
39 p_proc_name IN VARCHAR2
40 ,p_trace_on IN VARCHAR2 DEFAULT NULL
41 );
42
43 -- Debug_Exit
44 PROCEDURE debug_exit (
45 p_proc_name IN VARCHAR2
46 ,p_trace_off IN VARCHAR2 DEFAULT NULL
47 );
48
49 -- Debug Others
50 PROCEDURE debug_others (
51 p_proc_name IN VARCHAR2
52 ,p_proc_step IN NUMBER DEFAULT NULL
53 );
54
55 --
56 -- get_ext_rslt_frm_req
57 --
58 FUNCTION get_ext_rslt_frm_req (p_request_id IN NUMBER
59 ,p_ext_dfn_id IN NUMBER
60 )
61 RETURN NUMBER;
62
63 --
64 -- get_ext_rslt_count
65 --
66 PROCEDURE get_ext_rslt_count (p_ext_rslt_id IN NUMBER
67 ,p_ext_file_id IN NUMBER
68 ,p_hdr_count OUT NOCOPY NUMBER
69 ,p_dtl_count OUT NOCOPY NUMBER
70 ,p_trl_count OUT NOCOPY NUMBER
71 ,p_per_count OUT NOCOPY NUMBER
72 ,p_err_count OUT NOCOPY NUMBER
73 ,p_tot_count OUT NOCOPY NUMBER
74 );
75
76 --
77 -- create_extract_results
78 --
79 PROCEDURE create_extract_results (p_master_ext_rslt_id IN NUMBER
80 ,p_master_request_id IN NUMBER
81 ,p_ext_dfn_id IN NUMBER
82 ,p_request_id IN NUMBER
83 ,p_business_group_id IN NUMBER
84 ,p_program_application_id IN NUMBER
85 ,p_program_id IN NUMBER
86 ,p_effective_date IN DATE
87 );
88
89 --
90 -- copy_extract_results
91 --
92 PROCEDURE copy_extract_results (p_tab_request_ids IN pqp_gb_tp_ext_process.t_request_ids_type
93 ,p_ext_dfn_id IN NUMBER
94 ,p_master_business_group IN NUMBER
95 );
96 --
97 -- copy_extract_process
98 --
99 PROCEDURE copy_extract_process (errbuf OUT NOCOPY VARCHAR2
100 ,retcode OUT NOCOPY NUMBER
101 ,p_ext_dfn_id IN NUMBER
102 ,p_business_group_id IN NUMBER
103 ,p_request_id_1 IN NUMBER DEFAULT NULL
104 ,p_request_id_2 IN NUMBER DEFAULT NULL
105 ,p_request_id_3 IN NUMBER DEFAULT NULL
106 ,p_request_id_4 IN NUMBER DEFAULT NULL
107 ,p_request_id_5 IN NUMBER DEFAULT NULL
108 );
109
110 --
111 -- set_cross_person_records
112 --
113 PROCEDURE set_cross_person_records
114 (p_business_group_id IN NUMBER
115 ,p_effective_date IN DATE
116 ,p_master_request_id IN NUMBER DEFAULT NULL
117 -- Bugfix 3671727:ENH2 :Added new param
118 ,p_ext_dfn_id IN VARCHAR2
119 );
120
121 --
122 -- tpa_extract_process
123 --
124 PROCEDURE tpa_extract_process
125 (errbuf OUT NOCOPY VARCHAR2
126 ,retcode OUT NOCOPY NUMBER
127 ,p_ext_dfn_id IN NUMBER
128 ,p_effective_date IN VARCHAR2
129 ,p_business_group_id IN NUMBER
130 ,p_lea_yn IN VARCHAR2 DEFAULT NULL
131 ,p_argument1 IN VARCHAR2 DEFAULT NULL
132 ,p_organization_id IN NUMBER
133 -- Bugfix 3671727:ENH1 : Added new param
134 ,p_argument2 IN VARCHAR2
135 ,p_lea_number IN VARCHAR2
136 );
137
138 END pqp_gb_tp_ext_process;