APPS.PAY_NO_ARCHIVE_ABSENCE dependencies on PAY_NO_ARCHIVE_ABSENCE

Line 1: PACKAGE BODY PAY_NO_ARCHIVE_ABSENCE as

1: PACKAGE BODY PAY_NO_ARCHIVE_ABSENCE as
2: /* $Header: pynoabsa.pkb 120.0.12000000.1 2007/05/22 05:24:58 rajesrin noship $ */
3: TYPE lock_rec IS RECORD (
4: archive_assact_id NUMBER);
5: TYPE lock_table IS TABLE OF lock_rec INDEX BY BINARY_INTEGER;

Line 8: g_package VARCHAR2(33) := ' PAY_NO_ARCHIVE_ABSENCE.';

4: archive_assact_id NUMBER);
5: TYPE lock_table IS TABLE OF lock_rec INDEX BY BINARY_INTEGER;
6: g_debug boolean := hr_utility.debug_enabled;
7: g_lock_table lock_table;
8: g_package VARCHAR2(33) := ' PAY_NO_ARCHIVE_ABSENCE.';
9: g_err_num NUMBER;
10: g_errm VARCHAR2(150);
11: /* GET PARAMETER */
12: FUNCTION GET_PARAMETER(

Line 64: SELECT PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER(legislative_parameters,

60: ,p_archive OUT NOCOPY VARCHAR2
61: ,p_effective_date OUT NOCOPY DATE
62: ) IS
63: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
64: SELECT PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER(legislative_parameters,
65: 'LEGAL_EMPLOYER')
66: ,FND_DATE.canonical_to_date(PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER
67: (legislative_parameters,'START_DATE'))
68: ,FND_DATE.canonical_to_date(PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER

Line 66: ,FND_DATE.canonical_to_date(PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER

62: ) IS
63: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
64: SELECT PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER(legislative_parameters,
65: 'LEGAL_EMPLOYER')
66: ,FND_DATE.canonical_to_date(PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER
67: (legislative_parameters,'START_DATE'))
68: ,FND_DATE.canonical_to_date(PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER
69: (legislative_parameters,'END_DATE'))
70: ,PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER(legislative_parameters,'ARCHIVE')

Line 68: ,FND_DATE.canonical_to_date(PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER

64: SELECT PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER(legislative_parameters,
65: 'LEGAL_EMPLOYER')
66: ,FND_DATE.canonical_to_date(PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER
67: (legislative_parameters,'START_DATE'))
68: ,FND_DATE.canonical_to_date(PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER
69: (legislative_parameters,'END_DATE'))
70: ,PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER(legislative_parameters,'ARCHIVE')
71: ,effective_date
72: ,business_group_id

Line 70: ,PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER(legislative_parameters,'ARCHIVE')

66: ,FND_DATE.canonical_to_date(PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER
67: (legislative_parameters,'START_DATE'))
68: ,FND_DATE.canonical_to_date(PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER
69: (legislative_parameters,'END_DATE'))
70: ,PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER(legislative_parameters,'ARCHIVE')
71: ,effective_date
72: ,business_group_id
73: FROM pay_payroll_actions
74: WHERE payroll_action_id = p_payroll_action_id;

Line 410: PAY_NO_ARCHIVE_ABSENCE.GET_ALL_PARAMETERS(

406:
407:
408:
409:
410: PAY_NO_ARCHIVE_ABSENCE.GET_ALL_PARAMETERS(
411: p_payroll_action_id
412: ,l_business_group_id
413: ,l_legal_employer_id
414: ,l_start_date

Line 736: END PAY_NO_ARCHIVE_ABSENCE;

732: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',90);
733: END IF;
734: fnd_file.put_line (fnd_file.LOG, 'Exiting archive code' );
735: END ARCHIVE_CODE;
736: END PAY_NO_ARCHIVE_ABSENCE;