APPS.PER_GB_TAX_BEN_PKG dependencies on PER_BUSINESS_GROUPS

Line 31: p_business_group_id IN per_business_groups.business_group_id%TYPE,

27: errbuf OUT NOCOPY VARCHAR2,
28: retcode OUT NOCOPY NUMBER,
29: p_file_name IN VARCHAR2,
30: p_effective_date IN VARCHAR2,
31: p_business_group_id IN per_business_groups.business_group_id%TYPE,
32: p_delimiter IN VARCHAR2,
33: p_action_if_exists IN VARCHAR2 DEFAULT NULL,
34: p_date_effective_changes IN VARCHAR2 DEFAULT NULL,
35: p_batch_name IN VARCHAR2 DEFAULT NULL

Line 46: p_legislation_code per_business_groups.legislation_code%TYPE;

42: c_data_exchange_dir CONSTANT VARCHAR2 (30) := 'PER_DATA_EXCHANGE_DIR';
43: -- Procedure name
44: l_proc CONSTANT VARCHAR2 (72) := g_package
45: || 'upload_tax_ben';
46: p_legislation_code per_business_groups.legislation_code%TYPE;
47: -- File Handling variables
48: l_file_handle UTL_FILE.file_type;
49: l_filename VARCHAR2 (240);
50: l_location VARCHAR2 (4000);

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

60: l_ovn NUMBER;
61: -- Exceptions
62: e_fatal_error EXCEPTION;
63:
64: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)
65: IS
66: SELECT legislation_code
67: FROM per_business_groups
68: WHERE business_group_id = v_bg_id;

Line 67: FROM per_business_groups

63:
64: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)
65: IS
66: SELECT legislation_code
67: FROM per_business_groups
68: WHERE business_group_id = v_bg_id;
69: BEGIN
70: --hr_utility.trace_on(null,'KTBEN');
71: hr_utility.set_location ( 'Entering:'

Line 408: p_bg_id IN per_business_groups.business_group_id%TYPE,

404: p_session_date IN DATE,
405: p_batch_id IN pay_batch_lines.batch_id%TYPE,
406: p_batch_seq IN pay_batch_lines.batch_sequence%TYPE,
407: p_delimiter IN VARCHAR2,
408: p_bg_id IN per_business_groups.business_group_id%TYPE,
409: p_leg_cd IN per_business_groups.legislation_code%TYPE,
410: p_batch_line OUT NOCOPY g_batch_line
411: )
412: IS

Line 409: p_leg_cd IN per_business_groups.legislation_code%TYPE,

405: p_batch_id IN pay_batch_lines.batch_id%TYPE,
406: p_batch_seq IN pay_batch_lines.batch_sequence%TYPE,
407: p_delimiter IN VARCHAR2,
408: p_bg_id IN per_business_groups.business_group_id%TYPE,
409: p_leg_cd IN per_business_groups.legislation_code%TYPE,
410: p_batch_line OUT NOCOPY g_batch_line
411: )
412: IS
413: -- Procedure name