APPS.PAY_KR_BEE_UPLOAD dependencies on PER_BUSINESS_GROUPS

Line 94: from per_business_groups

90: where session_id = userenv('sessionid');
91:
92: cursor csr_get_leg_code is
93: select legislation_code
94: from per_business_groups
95: where business_group_id = p_bus_group_id;
96:
97: cursor csr_chk_range_match is
98: select range_or_match, user_table_id

Line 189: p_business_group_id IN per_business_groups.business_group_id%TYPE,

185: errbuf OUT NOCOPY VARCHAR2,
186: retcode OUT NOCOPY NUMBER,
187: p_file_name IN VARCHAR2,
188: p_effective_date IN VARCHAR2,
189: p_business_group_id IN per_business_groups.business_group_id%TYPE,
190: p_delimiter IN VARCHAR2,
191: p_action_if_exists IN VARCHAR2 DEFAULT NULL,
192: p_date_effective_changes IN VARCHAR2 DEFAULT NULL,
193: p_batch_name IN VARCHAR2 DEFAULT NULL

Line 205: l_legislation_code per_business_groups.legislation_code%TYPE;

201:
202: -- Procedure name
203:
204: l_proc CONSTANT VARCHAR2 (72) := g_package || 'upload ';
205: l_legislation_code per_business_groups.legislation_code%TYPE;
206:
207: -- File Handling variables
208: l_file_handle UTL_FILE.file_type;
209: l_filename VARCHAR2 (240);

Line 226: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)

222:
223: -- Exceptions
224: e_fatal_error EXCEPTION;
225:
226: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)
227: IS
228: SELECT legislation_code
229: FROM per_business_groups
230: WHERE business_group_id = v_bg_id;

Line 229: FROM per_business_groups

225:
226: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)
227: IS
228: SELECT legislation_code
229: FROM per_business_groups
230: WHERE business_group_id = v_bg_id;
231: BEGIN
232:
233: -- input parameters

Line 607: p_bg_id IN per_business_groups.business_group_id%TYPE,

603: p_session_date IN DATE,
604: p_batch_id IN pay_batch_lines.batch_id%TYPE,
605: p_batch_seq IN pay_batch_lines.batch_sequence%TYPE,
606: p_delimiter IN VARCHAR2,
607: p_bg_id IN per_business_groups.business_group_id%TYPE,
608: p_leg_cd IN per_business_groups.legislation_code%TYPE,
609: p_batch_line OUT NOCOPY g_batch_line
610: )
611: IS

Line 608: p_leg_cd IN per_business_groups.legislation_code%TYPE,

604: p_batch_id IN pay_batch_lines.batch_id%TYPE,
605: p_batch_seq IN pay_batch_lines.batch_sequence%TYPE,
606: p_delimiter IN VARCHAR2,
607: p_bg_id IN per_business_groups.business_group_id%TYPE,
608: p_leg_cd IN per_business_groups.legislation_code%TYPE,
609: p_batch_line OUT NOCOPY g_batch_line
610: )
611: IS
612: -- Procedure name

Line 1864: p_business_group_id IN per_business_groups.business_group_id%TYPE,

1860: errbuf OUT NOCOPY VARCHAR2,
1861: retcode OUT NOCOPY NUMBER,
1862: p_file_name IN VARCHAR2,
1863: p_effective_date IN VARCHAR2,
1864: p_business_group_id IN per_business_groups.business_group_id%TYPE,
1865: p_delimiter IN VARCHAR2,
1866: p_action_if_exists IN VARCHAR2 DEFAULT NULL,
1867: p_date_effective_changes IN VARCHAR2 DEFAULT NULL,
1868: p_batch_name IN VARCHAR2 DEFAULT NULL

Line 1908: p_business_group_id IN per_business_groups.business_group_id%TYPE,

1904: errbuf OUT NOCOPY VARCHAR2,
1905: retcode OUT NOCOPY NUMBER,
1906: p_file_name IN VARCHAR2,
1907: p_effective_date IN VARCHAR2,
1908: p_business_group_id IN per_business_groups.business_group_id%TYPE,
1909: p_delimiter IN VARCHAR2,
1910: p_action_if_exists IN VARCHAR2 DEFAULT NULL,
1911: p_date_effective_changes IN VARCHAR2 DEFAULT NULL,
1912: p_batch_name IN VARCHAR2 DEFAULT NULL