eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.40.12020000.12 2013/03/26 13:26:33 sgmaram ship $ */
3: --------------------------------------------------------------------------------
4: -- Global Variables
5: --------------------------------------------------------------------------------

Line 78: --,NVL(to_char(fnd_date.canonical_to_date(pay_nl_wage_report_pkg.get_parameters(c_payroll_action_id, 'CORR_YR')),'RRRR'),-9999) --10100628

74: ,get_parameters(c_payroll_action_id, 'Sequence_Number')
75: ,start_date
76: ,effective_date
77: ,business_group_id
78: --,NVL(to_char(fnd_date.canonical_to_date(pay_nl_wage_report_pkg.get_parameters(c_payroll_action_id, 'CORR_YR')),'RRRR'),-9999) --10100628
79: ,NVL(pay_nl_wage_report_pkg.get_parameters(c_payroll_action_id, 'CORR_YR'),'N') --10100628
80: ,NVL(pay_nl_wage_report_pkg.get_parameters(c_payroll_action_id, 'ER_ONLY'),'N') --10100628
81: FROM pay_payroll_actions
82: WHERE payroll_action_id = c_payroll_action_id;

Line 79: ,NVL(pay_nl_wage_report_pkg.get_parameters(c_payroll_action_id, 'CORR_YR'),'N') --10100628

75: ,start_date
76: ,effective_date
77: ,business_group_id
78: --,NVL(to_char(fnd_date.canonical_to_date(pay_nl_wage_report_pkg.get_parameters(c_payroll_action_id, 'CORR_YR')),'RRRR'),-9999) --10100628
79: ,NVL(pay_nl_wage_report_pkg.get_parameters(c_payroll_action_id, 'CORR_YR'),'N') --10100628
80: ,NVL(pay_nl_wage_report_pkg.get_parameters(c_payroll_action_id, 'ER_ONLY'),'N') --10100628
81: FROM pay_payroll_actions
82: WHERE payroll_action_id = c_payroll_action_id;
83: --

Line 80: ,NVL(pay_nl_wage_report_pkg.get_parameters(c_payroll_action_id, 'ER_ONLY'),'N') --10100628

76: ,effective_date
77: ,business_group_id
78: --,NVL(to_char(fnd_date.canonical_to_date(pay_nl_wage_report_pkg.get_parameters(c_payroll_action_id, 'CORR_YR')),'RRRR'),-9999) --10100628
79: ,NVL(pay_nl_wage_report_pkg.get_parameters(c_payroll_action_id, 'CORR_YR'),'N') --10100628
80: ,NVL(pay_nl_wage_report_pkg.get_parameters(c_payroll_action_id, 'ER_ONLY'),'N') --10100628
81: FROM pay_payroll_actions
82: WHERE payroll_action_id = c_payroll_action_id;
83: --
84: BEGIN

Line 189: -- get_defined_balance_id pay_nl_wage_report_pkg.get_defined_balance_id

185: 'from dual where to_char(:payroll_action_id) = dummy';
186: hr_utility.set_location(' Leaving: range code',110);
187: END archive_range_code;
188: --------------------------------------------------------------------------------
189: -- get_defined_balance_id pay_nl_wage_report_pkg.get_defined_balance_id
190: --------------------------------------------------------------------------------
191: FUNCTION get_defined_balance_id(p_balance_name VARCHAR2
192: ,p_database_item_suffix VARCHAR2) RETURN NUMBER IS
193: --

Line 223: -- populate_balance_table pay_nl_wage_report_pkg.populate_balance_table

219: --
220: END get_defined_balance_id;
221: --
222: --------------------------------------------------------------------------------
223: -- populate_balance_table pay_nl_wage_report_pkg.populate_balance_table
224: --------------------------------------------------------------------------------
225: PROCEDURE populate_nom_balance_table(p_payroll_type VARCHAR2) IS
226: --
227: --

Line 1186: -- populate_col_balance_values pay_nl_wage_report_pkg.populate_col_balance_values

1182: --
1183: END populate_nom_balance_table;
1184: --
1185: --------------------------------------------------------------------------------
1186: -- populate_col_balance_values pay_nl_wage_report_pkg.populate_col_balance_values
1187: --------------------------------------------------------------------------------
1188: PROCEDURE populate_col_balance_values(p_col_bal_def_table IN OUT NOCOPY BAL_COL_TABLE
1189: ,p_tax_unit_id IN NUMBER
1190: ,p_effective_date IN DATE

Line 1363: -- populate_col_balance_table pay_nl_wage_report_pkg.populate_col_balance_table

1359: END LOOP;
1360: END populate_col_balance_values;
1361: --
1362: --------------------------------------------------------------------------------
1363: -- populate_col_balance_table pay_nl_wage_report_pkg.populate_col_balance_table
1364: --------------------------------------------------------------------------------
1365: PROCEDURE populate_col_balance_table(p_payroll_type VARCHAR2
1366: ,p_effective_date DATE
1367: ,p_payroll_action_id NUMBER

Line 2149: -- populate_coll_bal_table pay_nl_wage_report_pkg.populate_coll_bal_table

2145: --
2146: END populate_col_balance_table;
2147: --
2148: --------------------------------------------------------------------------------
2149: -- populate_coll_bal_table pay_nl_wage_report_pkg.populate_coll_bal_table
2150: --------------------------------------------------------------------------------
2151: PROCEDURE populate_coll_bal_table(p_actid IN NUMBER
2152: ,p_tax_unit_id IN NUMBER
2153: ,p_effective_date IN DATE

Line 2624: l_prev_corr_yr := pay_nl_wage_report_pkg.get_parameters1(p_actid,'CORR_YR');

2620: --##--Fnd_file.put_line(FND_FILE.LOG,'#######~~~~ l_no_pay_period '||l_no_pay_period||' ');
2621: --
2622:
2623: --10100628
2624: l_prev_corr_yr := pay_nl_wage_report_pkg.get_parameters1(p_actid,'CORR_YR');
2625: IF l_prev_corr_yr <> '-9999' THEN
2626:
2627: OPEN C_PREV_CORR_COLL_VAL(p_actid, p_balance_date);
2628: FETCH C_PREV_CORR_COLL_VAL INTO

Line 3429: -- populate_nom_balance_values pay_nl_wage_report_pkg.populate_nom_balance_values

3425: --END LOOP;
3426: END populate_coll_bal_table;
3427: --
3428: --------------------------------------------------------------------------------
3429: -- populate_nom_balance_values pay_nl_wage_report_pkg.populate_nom_balance_values
3430: --------------------------------------------------------------------------------
3431: PROCEDURE populate_nom_balance_values(p_master_assignment_action_id NUMBER
3432: ,p_assignment_action_id NUMBER
3433: ,p_effective_date DATE

Line 3694: pay_nl_wage_report_pkg.get_all_parameters(p_actid

3690: l_er_only VARCHAR2(10); --10100628
3691: --
3692: BEGIN
3693: --
3694: pay_nl_wage_report_pkg.get_all_parameters(p_actid
3695: ,l_business_group_id
3696: ,l_start_date
3697: ,l_end_date
3698: ,l_tax_unit_id

Line 3747: -- INITIALIZE_CODE pay_nl_wage_report_pkg.archive_init_code

3743:
3744: --
3745: END set_company_type;
3746: --------------------------------------------------------------------------------
3747: -- INITIALIZE_CODE pay_nl_wage_report_pkg.archive_init_code
3748: --------------------------------------------------------------------------------
3749: PROCEDURE archive_init_code(p_actid IN NUMBER) IS
3750: l_payroll_type VARCHAR2(80);
3751: BEGIN

Line 3882: pay_nl_wage_report_pkg.get_all_parameters(p_actid

3878: END IF;
3879:
3880: --13106837
3881: --
3882: pay_nl_wage_report_pkg.get_all_parameters(p_actid
3883: ,l_business_group_id
3884: ,l_start_date
3885: ,l_end_date
3886: ,l_tax_unit_id

Line 4125: -- DEINITIALIZE_CODE pay_nl_wage_report_pkg.archive_deinit_code

4121: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
4122: hr_utility.set_location(sqlerrm(sqlcode),110);
4123: END archive_deinit_code_yearly;
4124: --------------------------------------------------------------------------------
4125: -- DEINITIALIZE_CODE pay_nl_wage_report_pkg.archive_deinit_code
4126: --------------------------------------------------------------------------------
4127: PROCEDURE archive_deinit_code(p_actid IN NUMBER)
4128: IS
4129: -- DECLARE LOCAL VARIABLES

Line 4728: pay_nl_wage_report_pkg.get_all_parameters(p_actid

4724: empe_flag := 'N';
4725: l_exception_flag := 'N';
4726: --
4727: --Fnd_file.put_line(FND_FILE.LOG,' 0 ');
4728: pay_nl_wage_report_pkg.get_all_parameters(p_actid
4729: ,l_business_group_id
4730: ,l_start_date
4731: ,l_end_date
4732: ,l_tax_unit_id

Line 14856: pay_nl_wage_report_pkg.get_all_parameters(p_actid

14852: l_er_only VARCHAR2(10);
14853: --
14854: BEGIN
14855: --
14856: pay_nl_wage_report_pkg.get_all_parameters(p_actid
14857: ,l_business_group_id
14858: ,l_start_date
14859: ,l_end_date
14860: ,l_tax_unit_id

Line 14903: AND pay_nl_wage_report_pkg.get_parameters (generator.payroll_action_id

14899: AND datalock.report_type = 'NL_WAGES_REP_LOCK'
14900: AND datalock.business_group_id = c_bg_id
14901: AND datalock.action_status = 'C'
14902: AND to_char (generator.effective_date,'YYYY') = c_year
14903: AND pay_nl_wage_report_pkg.get_parameters (generator.payroll_action_id
14904: ,'Legal_Employer') = c_tax_unit_id
14905: AND pay_nl_wage_report_pkg.get_parameters (datalock.payroll_action_id
14906: ,'REQUEST_ID') = generator.payroll_action_id ;
14907:

Line 14905: AND pay_nl_wage_report_pkg.get_parameters (datalock.payroll_action_id

14901: AND datalock.action_status = 'C'
14902: AND to_char (generator.effective_date,'YYYY') = c_year
14903: AND pay_nl_wage_report_pkg.get_parameters (generator.payroll_action_id
14904: ,'Legal_Employer') = c_tax_unit_id
14905: AND pay_nl_wage_report_pkg.get_parameters (datalock.payroll_action_id
14906: ,'REQUEST_ID') = generator.payroll_action_id ;
14907:
14908: r_get_archived_value csr_get_archived_value%ROWTYPE;
14909: BEGIN

Line 14924: END pay_nl_wage_report_pkg;

14920: RETURN NVL(r_get_archived_value.taxableincome,0);
14921:
14922: END get_archived_taxable_income;
14923:
14924: END pay_nl_wage_report_pkg;