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_US_DEPOSIT_ADVICE_PKG dependencies on PAY_US_DEPOSIT_ADVICE_PKG

Line 1: PACKAGE BODY pay_us_deposit_advice_pkg AS

1: PACKAGE BODY pay_us_deposit_advice_pkg AS
2: /* $Header: payuslivearchive.pkb 120.14.12010000.9 2009/09/25 16:55:20 rnestor ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_us_deposit_advice_pkg.pkb

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_us_deposit_advice_pkg.pkb
21:
22: Description : Package used for Deposit Advice Report.
23:
24: Change List

Line 452: AND pay_us_deposit_advice_pkg.check_if_assignment_paid(

448: ,'PRINT'
449: ,'ASSIGNMENT'
450: ,p_assignment_id
451: ,p_deposit_end_date) = 'Y'
452: AND pay_us_deposit_advice_pkg.check_if_assignment_paid(
453: ln_prepay_action_id
454: ,p_deposit_start_date
455: ,p_deposit_end_date
456: ,p_consolidation_set_id) = 'Y' --Bug 3512116

Line 544: and pay_us_deposit_advice_pkg.check_if_assignment_paid(

540: and pay_us_employee_payslip_web.get_doc_eit(
541: 'PAYSLIP','PRINT',
542: 'ASSIGNMENT',paa_xfr.assignment_id,
543: cp_deposit_end_date) = 'Y'
544: and pay_us_deposit_advice_pkg.check_if_assignment_paid(
545: pai_pre.locked_action_id,
546: cp_deposit_start_date,
547: cp_deposit_end_date,
548: cp_consolidation_set_id) = 'Y' --Bug 3512116

Line 1271: IF pay_us_deposit_advice_pkg.g_payroll_act_id <> ln_curr_payroll_act_id THEN

1267: ln_curr_payroll_act_id := l_actid;
1268: hr_utility.trace('In QualProc l_actid := ' || l_actid);
1269: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
1270:
1271: IF pay_us_deposit_advice_pkg.g_payroll_act_id <> ln_curr_payroll_act_id THEN
1272: pay_us_deposit_advice_pkg.g_payroll_act_id := ln_curr_payroll_act_id;
1273:
1274: pay_payslip_report.get_all_parameters(l_actid
1275: ,l_payroll_id

Line 1272: pay_us_deposit_advice_pkg.g_payroll_act_id := ln_curr_payroll_act_id;

1268: hr_utility.trace('In QualProc l_actid := ' || l_actid);
1269: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
1270:
1271: IF pay_us_deposit_advice_pkg.g_payroll_act_id <> ln_curr_payroll_act_id THEN
1272: pay_us_deposit_advice_pkg.g_payroll_act_id := ln_curr_payroll_act_id;
1273:
1274: pay_payslip_report.get_all_parameters(l_actid
1275: ,l_payroll_id
1276: ,l_consolidation_set_id

Line 1306: pay_us_deposit_advice_pkg.g_payroll_id := l_payroll_id;

1302: --
1303: -- Fetching legislative prameters for the very first time
1304: -- And caching them into global variables.
1305:
1306: pay_us_deposit_advice_pkg.g_payroll_id := l_payroll_id;
1307: pay_us_deposit_advice_pkg.g_consolidation_set_id := l_consolidation_set_id;
1308: pay_us_deposit_advice_pkg.g_start_dt := l_start_dt;
1309: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;
1310: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;

Line 1307: pay_us_deposit_advice_pkg.g_consolidation_set_id := l_consolidation_set_id;

1303: -- Fetching legislative prameters for the very first time
1304: -- And caching them into global variables.
1305:
1306: pay_us_deposit_advice_pkg.g_payroll_id := l_payroll_id;
1307: pay_us_deposit_advice_pkg.g_consolidation_set_id := l_consolidation_set_id;
1308: pay_us_deposit_advice_pkg.g_start_dt := l_start_dt;
1309: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;
1310: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;
1311: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;

Line 1308: pay_us_deposit_advice_pkg.g_start_dt := l_start_dt;

1304: -- And caching them into global variables.
1305:
1306: pay_us_deposit_advice_pkg.g_payroll_id := l_payroll_id;
1307: pay_us_deposit_advice_pkg.g_consolidation_set_id := l_consolidation_set_id;
1308: pay_us_deposit_advice_pkg.g_start_dt := l_start_dt;
1309: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;
1310: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;
1311: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;
1312: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;

Line 1309: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;

1305:
1306: pay_us_deposit_advice_pkg.g_payroll_id := l_payroll_id;
1307: pay_us_deposit_advice_pkg.g_consolidation_set_id := l_consolidation_set_id;
1308: pay_us_deposit_advice_pkg.g_start_dt := l_start_dt;
1309: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;
1310: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;
1311: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;
1312: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;
1313: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;

Line 1310: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;

1306: pay_us_deposit_advice_pkg.g_payroll_id := l_payroll_id;
1307: pay_us_deposit_advice_pkg.g_consolidation_set_id := l_consolidation_set_id;
1308: pay_us_deposit_advice_pkg.g_start_dt := l_start_dt;
1309: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;
1310: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;
1311: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;
1312: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;
1313: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;
1314: pay_us_deposit_advice_pkg.g_effective_date := l_effective_date;

Line 1311: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;

1307: pay_us_deposit_advice_pkg.g_consolidation_set_id := l_consolidation_set_id;
1308: pay_us_deposit_advice_pkg.g_start_dt := l_start_dt;
1309: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;
1310: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;
1311: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;
1312: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;
1313: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;
1314: pay_us_deposit_advice_pkg.g_effective_date := l_effective_date;
1315: pay_us_deposit_advice_pkg.g_business_group_id := l_business_group_id;

Line 1312: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;

1308: pay_us_deposit_advice_pkg.g_start_dt := l_start_dt;
1309: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;
1310: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;
1311: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;
1312: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;
1313: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;
1314: pay_us_deposit_advice_pkg.g_effective_date := l_effective_date;
1315: pay_us_deposit_advice_pkg.g_business_group_id := l_business_group_id;
1316: pay_us_deposit_advice_pkg.g_legislation_code := l_legislation_code;

Line 1313: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;

1309: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;
1310: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;
1311: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;
1312: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;
1313: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;
1314: pay_us_deposit_advice_pkg.g_effective_date := l_effective_date;
1315: pay_us_deposit_advice_pkg.g_business_group_id := l_business_group_id;
1316: pay_us_deposit_advice_pkg.g_legislation_code := l_legislation_code;
1317:

Line 1314: pay_us_deposit_advice_pkg.g_effective_date := l_effective_date;

1310: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;
1311: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;
1312: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;
1313: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;
1314: pay_us_deposit_advice_pkg.g_effective_date := l_effective_date;
1315: pay_us_deposit_advice_pkg.g_business_group_id := l_business_group_id;
1316: pay_us_deposit_advice_pkg.g_legislation_code := l_legislation_code;
1317:
1318: --

Line 1315: pay_us_deposit_advice_pkg.g_business_group_id := l_business_group_id;

1311: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;
1312: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;
1313: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;
1314: pay_us_deposit_advice_pkg.g_effective_date := l_effective_date;
1315: pay_us_deposit_advice_pkg.g_business_group_id := l_business_group_id;
1316: pay_us_deposit_advice_pkg.g_legislation_code := l_legislation_code;
1317:
1318: --
1319: DECLARE

Line 1316: pay_us_deposit_advice_pkg.g_legislation_code := l_legislation_code;

1312: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;
1313: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;
1314: pay_us_deposit_advice_pkg.g_effective_date := l_effective_date;
1315: pay_us_deposit_advice_pkg.g_business_group_id := l_business_group_id;
1316: pay_us_deposit_advice_pkg.g_legislation_code := l_legislation_code;
1317:
1318: --
1319: DECLARE
1320: BEGIN

Line 1347: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN

1343: --
1344: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);
1345: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1346:
1347: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1348: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id
1349: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1350: ,pay_us_deposit_advice_pkg.g_start_dt
1351: ,pay_us_deposit_advice_pkg.g_end_dt

Line 1348: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id

1344: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);
1345: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1346:
1347: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1348: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id
1349: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1350: ,pay_us_deposit_advice_pkg.g_start_dt
1351: ,pay_us_deposit_advice_pkg.g_end_dt
1352: ,pay_payslip_report.g_pa_token

Line 1349: ,pay_us_deposit_advice_pkg.g_consolidation_set_id

1345: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1346:
1347: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1348: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id
1349: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1350: ,pay_us_deposit_advice_pkg.g_start_dt
1351: ,pay_us_deposit_advice_pkg.g_end_dt
1352: ,pay_payslip_report.g_pa_token
1353: ,pay_payslip_report.g_cs_token

Line 1350: ,pay_us_deposit_advice_pkg.g_start_dt

1346:
1347: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1348: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id
1349: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1350: ,pay_us_deposit_advice_pkg.g_start_dt
1351: ,pay_us_deposit_advice_pkg.g_end_dt
1352: ,pay_payslip_report.g_pa_token
1353: ,pay_payslip_report.g_cs_token
1354: ,pay_us_deposit_advice_pkg.g_legislation_code);

Line 1351: ,pay_us_deposit_advice_pkg.g_end_dt

1347: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1348: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id
1349: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1350: ,pay_us_deposit_advice_pkg.g_start_dt
1351: ,pay_us_deposit_advice_pkg.g_end_dt
1352: ,pay_payslip_report.g_pa_token
1353: ,pay_payslip_report.g_cs_token
1354: ,pay_us_deposit_advice_pkg.g_legislation_code);
1355: LOOP

Line 1354: ,pay_us_deposit_advice_pkg.g_legislation_code);

1350: ,pay_us_deposit_advice_pkg.g_start_dt
1351: ,pay_us_deposit_advice_pkg.g_end_dt
1352: ,pay_payslip_report.g_pa_token
1353: ,pay_payslip_report.g_cs_token
1354: ,pay_us_deposit_advice_pkg.g_legislation_code);
1355: LOOP
1356:
1357: ln_assignment_id := -1;
1358: ln_action_ctx_id := -1;

Line 1367: ,pay_us_deposit_advice_pkg.g_start_dt

1363: EXIT;
1364: ELSE
1365: IF check_if_qualified_for_US(ln_action_ctx_id
1366: ,ln_assignment_id
1367: ,pay_us_deposit_advice_pkg.g_start_dt
1368: ,pay_us_deposit_advice_pkg.g_end_dt
1369: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN
1370:
1371: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;

Line 1368: ,pay_us_deposit_advice_pkg.g_end_dt

1364: ELSE
1365: IF check_if_qualified_for_US(ln_action_ctx_id
1366: ,ln_assignment_id
1367: ,pay_us_deposit_advice_pkg.g_start_dt
1368: ,pay_us_deposit_advice_pkg.g_end_dt
1369: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN
1370:
1371: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;
1372: hr_utility.trace('g_tmp_tbl(' || ln_assignment_id || ') := ' || ln_assignment_id);

Line 1369: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN

1365: IF check_if_qualified_for_US(ln_action_ctx_id
1366: ,ln_assignment_id
1367: ,pay_us_deposit_advice_pkg.g_start_dt
1368: ,pay_us_deposit_advice_pkg.g_end_dt
1369: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN
1370:
1371: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;
1372: hr_utility.trace('g_tmp_tbl(' || ln_assignment_id || ') := ' || ln_assignment_id);
1373:

Line 1381: OPEN csr_inc_asg(pay_us_deposit_advice_pkg.g_payroll_id

1377: END LOOP;
1378: CLOSE csr_asg;
1379: --
1380: ELSE
1381: OPEN csr_inc_asg(pay_us_deposit_advice_pkg.g_payroll_id
1382: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1383: ,pay_us_deposit_advice_pkg.g_start_dt
1384: ,pay_us_deposit_advice_pkg.g_end_dt
1385: ,pay_payslip_report.g_pa_token

Line 1382: ,pay_us_deposit_advice_pkg.g_consolidation_set_id

1378: CLOSE csr_asg;
1379: --
1380: ELSE
1381: OPEN csr_inc_asg(pay_us_deposit_advice_pkg.g_payroll_id
1382: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1383: ,pay_us_deposit_advice_pkg.g_start_dt
1384: ,pay_us_deposit_advice_pkg.g_end_dt
1385: ,pay_payslip_report.g_pa_token
1386: ,pay_payslip_report.g_cs_token

Line 1383: ,pay_us_deposit_advice_pkg.g_start_dt

1379: --
1380: ELSE
1381: OPEN csr_inc_asg(pay_us_deposit_advice_pkg.g_payroll_id
1382: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1383: ,pay_us_deposit_advice_pkg.g_start_dt
1384: ,pay_us_deposit_advice_pkg.g_end_dt
1385: ,pay_payslip_report.g_pa_token
1386: ,pay_payslip_report.g_cs_token
1387: ,pay_us_deposit_advice_pkg.g_legislation_code

Line 1384: ,pay_us_deposit_advice_pkg.g_end_dt

1380: ELSE
1381: OPEN csr_inc_asg(pay_us_deposit_advice_pkg.g_payroll_id
1382: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1383: ,pay_us_deposit_advice_pkg.g_start_dt
1384: ,pay_us_deposit_advice_pkg.g_end_dt
1385: ,pay_payslip_report.g_pa_token
1386: ,pay_payslip_report.g_cs_token
1387: ,pay_us_deposit_advice_pkg.g_legislation_code
1388: ,pay_us_deposit_advice_pkg.g_assignment_set_id);

Line 1387: ,pay_us_deposit_advice_pkg.g_legislation_code

1383: ,pay_us_deposit_advice_pkg.g_start_dt
1384: ,pay_us_deposit_advice_pkg.g_end_dt
1385: ,pay_payslip_report.g_pa_token
1386: ,pay_payslip_report.g_cs_token
1387: ,pay_us_deposit_advice_pkg.g_legislation_code
1388: ,pay_us_deposit_advice_pkg.g_assignment_set_id);
1389: LOOP
1390:
1391: ln_assignment_id := -1;

Line 1388: ,pay_us_deposit_advice_pkg.g_assignment_set_id);

1384: ,pay_us_deposit_advice_pkg.g_end_dt
1385: ,pay_payslip_report.g_pa_token
1386: ,pay_payslip_report.g_cs_token
1387: ,pay_us_deposit_advice_pkg.g_legislation_code
1388: ,pay_us_deposit_advice_pkg.g_assignment_set_id);
1389: LOOP
1390:
1391: ln_assignment_id := -1;
1392: ln_action_ctx_id := -1;

Line 1401: ,pay_us_deposit_advice_pkg.g_start_dt

1397: EXIT;
1398: ELSE
1399: IF check_if_qualified_for_US(ln_action_ctx_id
1400: ,ln_assignment_id
1401: ,pay_us_deposit_advice_pkg.g_start_dt
1402: ,pay_us_deposit_advice_pkg.g_end_dt
1403: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN
1404:
1405: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;

Line 1402: ,pay_us_deposit_advice_pkg.g_end_dt

1398: ELSE
1399: IF check_if_qualified_for_US(ln_action_ctx_id
1400: ,ln_assignment_id
1401: ,pay_us_deposit_advice_pkg.g_start_dt
1402: ,pay_us_deposit_advice_pkg.g_end_dt
1403: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN
1404:
1405: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;
1406: hr_utility.trace('g_tmp_tbl(' || ln_assignment_id || ') := ' || ln_assignment_id);

Line 1403: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN

1399: IF check_if_qualified_for_US(ln_action_ctx_id
1400: ,ln_assignment_id
1401: ,pay_us_deposit_advice_pkg.g_start_dt
1402: ,pay_us_deposit_advice_pkg.g_end_dt
1403: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN
1404:
1405: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;
1406: hr_utility.trace('g_tmp_tbl(' || ln_assignment_id || ') := ' || ln_assignment_id);
1407: END IF;

Line 1564: end pay_us_deposit_advice_pkg;

1560:
1561: end DAxml_range_cursor;
1562: --
1563: --
1564: end pay_us_deposit_advice_pkg;