DBA Data[Home] [Help]

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_NL_WAGE_REPORT_PKG

Line 1: PACKAGE BODY pay_nl_wage_report_pkg AS

1: PACKAGE BODY pay_nl_wage_report_pkg AS
2: /* $Header: pynlwrar.pkb 120.7.12010000.4 2008/09/30 07:23:20 rsahai ship $ */
3: --------------------------------------------------------------------------------
4: -- Global Variables
5: --------------------------------------------------------------------------------

Line 102: -- get_defined_balance_id pay_nl_wage_report_pkg.get_defined_balance_id

98: 'from dual where to_char(:payroll_action_id) = dummy';
99: hr_utility.set_location(' Leaving: range code',110);
100: END archive_range_code;
101: --------------------------------------------------------------------------------
102: -- get_defined_balance_id pay_nl_wage_report_pkg.get_defined_balance_id
103: --------------------------------------------------------------------------------
104: FUNCTION get_defined_balance_id(p_balance_name VARCHAR2
105: ,p_database_item_suffix VARCHAR2) RETURN NUMBER IS
106: --

Line 136: -- populate_balance_table pay_nl_wage_report_pkg.populate_balance_table

132: --
133: END get_defined_balance_id;
134: --
135: --------------------------------------------------------------------------------
136: -- populate_balance_table pay_nl_wage_report_pkg.populate_balance_table
137: --------------------------------------------------------------------------------
138: PROCEDURE populate_nom_balance_table(p_payroll_type VARCHAR2) IS
139: --
140: --

Line 897: -- populate_col_balance_values pay_nl_wage_report_pkg.populate_col_balance_values

893: --
894: END populate_nom_balance_table;
895: --
896: --------------------------------------------------------------------------------
897: -- populate_col_balance_values pay_nl_wage_report_pkg.populate_col_balance_values
898: --------------------------------------------------------------------------------
899: PROCEDURE populate_col_balance_values(p_col_bal_def_table IN OUT NOCOPY BAL_COL_TABLE
900: ,p_tax_unit_id IN NUMBER
901: ,p_effective_date IN DATE

Line 1074: -- populate_col_balance_table pay_nl_wage_report_pkg.populate_col_balance_table

1070: END LOOP;
1071: END populate_col_balance_values;
1072: --
1073: --------------------------------------------------------------------------------
1074: -- populate_col_balance_table pay_nl_wage_report_pkg.populate_col_balance_table
1075: --------------------------------------------------------------------------------
1076: PROCEDURE populate_col_balance_table(p_payroll_type VARCHAR2
1077: ,p_effective_date DATE
1078: ,p_payroll_action_id NUMBER

Line 1756: -- populate_coll_bal_table pay_nl_wage_report_pkg.populate_coll_bal_table

1752: --
1753: END populate_col_balance_table;
1754: --
1755: --------------------------------------------------------------------------------
1756: -- populate_coll_bal_table pay_nl_wage_report_pkg.populate_coll_bal_table
1757: --------------------------------------------------------------------------------
1758: PROCEDURE populate_coll_bal_table(p_actid IN NUMBER
1759: ,p_tax_unit_id IN NUMBER
1760: ,p_effective_date IN DATE

Line 2260: -- populate_nom_balance_values pay_nl_wage_report_pkg.populate_nom_balance_values

2256: --END LOOP;
2257: END populate_coll_bal_table;
2258: --
2259: --------------------------------------------------------------------------------
2260: -- populate_nom_balance_values pay_nl_wage_report_pkg.populate_nom_balance_values
2261: --------------------------------------------------------------------------------
2262: PROCEDURE populate_nom_balance_values(p_master_assignment_action_id NUMBER
2263: ,p_assignment_action_id NUMBER
2264: ,p_effective_date DATE

Line 2523: pay_nl_wage_report_pkg.get_all_parameters(p_actid

2519: l_date DATE;
2520: --
2521: BEGIN
2522: --
2523: pay_nl_wage_report_pkg.get_all_parameters(p_actid
2524: ,l_business_group_id
2525: ,l_start_date
2526: ,l_end_date
2527: ,l_tax_unit_id

Line 2567: -- INITIALIZE_CODE pay_nl_wage_report_pkg.archive_init_code

2563: END IF;
2564: --
2565: END set_company_type;
2566: --------------------------------------------------------------------------------
2567: -- INITIALIZE_CODE pay_nl_wage_report_pkg.archive_init_code
2568: --------------------------------------------------------------------------------
2569: PROCEDURE archive_init_code(p_actid IN NUMBER) IS
2570: l_payroll_type VARCHAR2(80);
2571: BEGIN

Line 2747: -- DEINITIALIZE_CODE pay_nl_wage_report_pkg.archive_deinit_code

2743: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
2744: hr_utility.set_location(sqlerrm(sqlcode),110);
2745: END archive_deinit_code_yearly;
2746: --------------------------------------------------------------------------------
2747: -- DEINITIALIZE_CODE pay_nl_wage_report_pkg.archive_deinit_code
2748: --------------------------------------------------------------------------------
2749: PROCEDURE archive_deinit_code(p_actid IN NUMBER)
2750: IS
2751: -- DECLARE LOCAL VARIABLES

Line 3051: pay_nl_wage_report_pkg.get_all_parameters(p_actid

3047: empe_flag := 'N';
3048: l_exception_flag := 'N';
3049: --
3050: --Fnd_file.put_line(FND_FILE.LOG,' 0 ');
3051: pay_nl_wage_report_pkg.get_all_parameters(p_actid
3052: ,l_business_group_id
3053: ,l_start_date
3054: ,l_end_date
3055: ,l_tax_unit_id

Line 8996: pay_nl_wage_report_pkg.get_all_parameters(p_actid

8992: l_exception VARCHAR2(20);
8993: --
8994: BEGIN
8995: --
8996: pay_nl_wage_report_pkg.get_all_parameters(p_actid
8997: ,l_business_group_id
8998: ,l_start_date
8999: ,l_end_date
9000: ,l_tax_unit_id

Line 9022: END pay_nl_wage_report_pkg;

9018: RETURN(l_return_string);
9019: --
9020: END get_archive_details;
9021: --
9022: END pay_nl_wage_report_pkg;