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.7 2009/02/17 17:27:27 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 447: AND pay_us_deposit_advice_pkg.check_if_assignment_paid(

443: ,'PRINT'
444: ,'ASSIGNMENT'
445: ,p_assignment_id
446: ,p_deposit_end_date) = 'Y'
447: AND pay_us_deposit_advice_pkg.check_if_assignment_paid(
448: ln_prepay_action_id
449: ,p_deposit_start_date
450: ,p_deposit_end_date
451: ,p_consolidation_set_id) = 'Y' --Bug 3512116

Line 537: and pay_us_deposit_advice_pkg.check_if_assignment_paid(

533: and pay_us_employee_payslip_web.get_doc_eit(
534: 'PAYSLIP','PRINT',
535: 'ASSIGNMENT',paa_xfr.assignment_id,
536: cp_deposit_end_date) = 'Y'
537: and pay_us_deposit_advice_pkg.check_if_assignment_paid(
538: pai_pre.locked_action_id,
539: cp_deposit_start_date,
540: cp_deposit_end_date,
541: cp_consolidation_set_id) = 'Y' --Bug 3512116

Line 1261: IF pay_us_deposit_advice_pkg.g_payroll_act_id <> ln_curr_payroll_act_id THEN

1257: ln_curr_payroll_act_id := l_actid;
1258: hr_utility.trace('In QualProc l_actid := ' || l_actid);
1259: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
1260:
1261: IF pay_us_deposit_advice_pkg.g_payroll_act_id <> ln_curr_payroll_act_id THEN
1262: pay_us_deposit_advice_pkg.g_payroll_act_id := ln_curr_payroll_act_id;
1263:
1264: pay_payslip_report.get_all_parameters(l_actid
1265: ,l_payroll_id

Line 1262: pay_us_deposit_advice_pkg.g_payroll_act_id := ln_curr_payroll_act_id;

1258: hr_utility.trace('In QualProc l_actid := ' || l_actid);
1259: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
1260:
1261: IF pay_us_deposit_advice_pkg.g_payroll_act_id <> ln_curr_payroll_act_id THEN
1262: pay_us_deposit_advice_pkg.g_payroll_act_id := ln_curr_payroll_act_id;
1263:
1264: pay_payslip_report.get_all_parameters(l_actid
1265: ,l_payroll_id
1266: ,l_consolidation_set_id

Line 1296: pay_us_deposit_advice_pkg.g_payroll_id := l_payroll_id;

1292: --
1293: -- Fetching legislative prameters for the very first time
1294: -- And caching them into global variables.
1295:
1296: pay_us_deposit_advice_pkg.g_payroll_id := l_payroll_id;
1297: pay_us_deposit_advice_pkg.g_consolidation_set_id := l_consolidation_set_id;
1298: pay_us_deposit_advice_pkg.g_start_dt := l_start_dt;
1299: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;
1300: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;

Line 1297: pay_us_deposit_advice_pkg.g_consolidation_set_id := l_consolidation_set_id;

1293: -- Fetching legislative prameters for the very first time
1294: -- And caching them into global variables.
1295:
1296: pay_us_deposit_advice_pkg.g_payroll_id := l_payroll_id;
1297: pay_us_deposit_advice_pkg.g_consolidation_set_id := l_consolidation_set_id;
1298: pay_us_deposit_advice_pkg.g_start_dt := l_start_dt;
1299: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;
1300: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;
1301: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;

Line 1298: pay_us_deposit_advice_pkg.g_start_dt := l_start_dt;

1294: -- And caching them into global variables.
1295:
1296: pay_us_deposit_advice_pkg.g_payroll_id := l_payroll_id;
1297: pay_us_deposit_advice_pkg.g_consolidation_set_id := l_consolidation_set_id;
1298: pay_us_deposit_advice_pkg.g_start_dt := l_start_dt;
1299: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;
1300: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;
1301: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;
1302: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;

Line 1299: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;

1295:
1296: pay_us_deposit_advice_pkg.g_payroll_id := l_payroll_id;
1297: pay_us_deposit_advice_pkg.g_consolidation_set_id := l_consolidation_set_id;
1298: pay_us_deposit_advice_pkg.g_start_dt := l_start_dt;
1299: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;
1300: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;
1301: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;
1302: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;
1303: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;

Line 1300: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;

1296: pay_us_deposit_advice_pkg.g_payroll_id := l_payroll_id;
1297: pay_us_deposit_advice_pkg.g_consolidation_set_id := l_consolidation_set_id;
1298: pay_us_deposit_advice_pkg.g_start_dt := l_start_dt;
1299: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;
1300: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;
1301: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;
1302: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;
1303: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;
1304: pay_us_deposit_advice_pkg.g_effective_date := l_effective_date;

Line 1301: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;

1297: pay_us_deposit_advice_pkg.g_consolidation_set_id := l_consolidation_set_id;
1298: pay_us_deposit_advice_pkg.g_start_dt := l_start_dt;
1299: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;
1300: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;
1301: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;
1302: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;
1303: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;
1304: pay_us_deposit_advice_pkg.g_effective_date := l_effective_date;
1305: pay_us_deposit_advice_pkg.g_business_group_id := l_business_group_id;

Line 1302: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;

1298: pay_us_deposit_advice_pkg.g_start_dt := l_start_dt;
1299: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;
1300: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;
1301: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;
1302: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;
1303: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;
1304: pay_us_deposit_advice_pkg.g_effective_date := l_effective_date;
1305: pay_us_deposit_advice_pkg.g_business_group_id := l_business_group_id;
1306: pay_us_deposit_advice_pkg.g_legislation_code := l_legislation_code;

Line 1303: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;

1299: pay_us_deposit_advice_pkg.g_end_dt := l_end_dt;
1300: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;
1301: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;
1302: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;
1303: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;
1304: pay_us_deposit_advice_pkg.g_effective_date := l_effective_date;
1305: pay_us_deposit_advice_pkg.g_business_group_id := l_business_group_id;
1306: pay_us_deposit_advice_pkg.g_legislation_code := l_legislation_code;
1307:

Line 1304: pay_us_deposit_advice_pkg.g_effective_date := l_effective_date;

1300: pay_us_deposit_advice_pkg.g_rep_group := l_rep_group;
1301: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;
1302: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;
1303: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;
1304: pay_us_deposit_advice_pkg.g_effective_date := l_effective_date;
1305: pay_us_deposit_advice_pkg.g_business_group_id := l_business_group_id;
1306: pay_us_deposit_advice_pkg.g_legislation_code := l_legislation_code;
1307:
1308: --

Line 1305: pay_us_deposit_advice_pkg.g_business_group_id := l_business_group_id;

1301: pay_us_deposit_advice_pkg.g_rep_category := l_rep_category;
1302: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;
1303: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;
1304: pay_us_deposit_advice_pkg.g_effective_date := l_effective_date;
1305: pay_us_deposit_advice_pkg.g_business_group_id := l_business_group_id;
1306: pay_us_deposit_advice_pkg.g_legislation_code := l_legislation_code;
1307:
1308: --
1309: DECLARE

Line 1306: pay_us_deposit_advice_pkg.g_legislation_code := l_legislation_code;

1302: pay_us_deposit_advice_pkg.g_assignment_set_id := l_assignment_set_id;
1303: pay_us_deposit_advice_pkg.g_assignment_id := l_assignment_id;
1304: pay_us_deposit_advice_pkg.g_effective_date := l_effective_date;
1305: pay_us_deposit_advice_pkg.g_business_group_id := l_business_group_id;
1306: pay_us_deposit_advice_pkg.g_legislation_code := l_legislation_code;
1307:
1308: --
1309: DECLARE
1310: BEGIN

Line 1337: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN

1333: --
1334: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);
1335: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1336:
1337: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1338: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id
1339: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1340: ,pay_us_deposit_advice_pkg.g_start_dt
1341: ,pay_us_deposit_advice_pkg.g_end_dt

Line 1338: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id

1334: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);
1335: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1336:
1337: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1338: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id
1339: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1340: ,pay_us_deposit_advice_pkg.g_start_dt
1341: ,pay_us_deposit_advice_pkg.g_end_dt
1342: ,pay_payslip_report.g_pa_token

Line 1339: ,pay_us_deposit_advice_pkg.g_consolidation_set_id

1335: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1336:
1337: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1338: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id
1339: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1340: ,pay_us_deposit_advice_pkg.g_start_dt
1341: ,pay_us_deposit_advice_pkg.g_end_dt
1342: ,pay_payslip_report.g_pa_token
1343: ,pay_payslip_report.g_cs_token

Line 1340: ,pay_us_deposit_advice_pkg.g_start_dt

1336:
1337: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1338: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id
1339: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1340: ,pay_us_deposit_advice_pkg.g_start_dt
1341: ,pay_us_deposit_advice_pkg.g_end_dt
1342: ,pay_payslip_report.g_pa_token
1343: ,pay_payslip_report.g_cs_token
1344: ,pay_us_deposit_advice_pkg.g_legislation_code);

Line 1341: ,pay_us_deposit_advice_pkg.g_end_dt

1337: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1338: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id
1339: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1340: ,pay_us_deposit_advice_pkg.g_start_dt
1341: ,pay_us_deposit_advice_pkg.g_end_dt
1342: ,pay_payslip_report.g_pa_token
1343: ,pay_payslip_report.g_cs_token
1344: ,pay_us_deposit_advice_pkg.g_legislation_code);
1345: LOOP

Line 1344: ,pay_us_deposit_advice_pkg.g_legislation_code);

1340: ,pay_us_deposit_advice_pkg.g_start_dt
1341: ,pay_us_deposit_advice_pkg.g_end_dt
1342: ,pay_payslip_report.g_pa_token
1343: ,pay_payslip_report.g_cs_token
1344: ,pay_us_deposit_advice_pkg.g_legislation_code);
1345: LOOP
1346:
1347: ln_assignment_id := -1;
1348: ln_action_ctx_id := -1;

Line 1357: ,pay_us_deposit_advice_pkg.g_start_dt

1353: EXIT;
1354: ELSE
1355: IF check_if_qualified_for_US(ln_action_ctx_id
1356: ,ln_assignment_id
1357: ,pay_us_deposit_advice_pkg.g_start_dt
1358: ,pay_us_deposit_advice_pkg.g_end_dt
1359: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN
1360:
1361: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;

Line 1358: ,pay_us_deposit_advice_pkg.g_end_dt

1354: ELSE
1355: IF check_if_qualified_for_US(ln_action_ctx_id
1356: ,ln_assignment_id
1357: ,pay_us_deposit_advice_pkg.g_start_dt
1358: ,pay_us_deposit_advice_pkg.g_end_dt
1359: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN
1360:
1361: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;
1362: hr_utility.trace('g_tmp_tbl(' || ln_assignment_id || ') := ' || ln_assignment_id);

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

1355: IF check_if_qualified_for_US(ln_action_ctx_id
1356: ,ln_assignment_id
1357: ,pay_us_deposit_advice_pkg.g_start_dt
1358: ,pay_us_deposit_advice_pkg.g_end_dt
1359: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN
1360:
1361: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;
1362: hr_utility.trace('g_tmp_tbl(' || ln_assignment_id || ') := ' || ln_assignment_id);
1363:

Line 1371: OPEN csr_inc_asg(pay_us_deposit_advice_pkg.g_payroll_id

1367: END LOOP;
1368: CLOSE csr_asg;
1369: --
1370: ELSE
1371: OPEN csr_inc_asg(pay_us_deposit_advice_pkg.g_payroll_id
1372: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1373: ,pay_us_deposit_advice_pkg.g_start_dt
1374: ,pay_us_deposit_advice_pkg.g_end_dt
1375: ,pay_payslip_report.g_pa_token

Line 1372: ,pay_us_deposit_advice_pkg.g_consolidation_set_id

1368: CLOSE csr_asg;
1369: --
1370: ELSE
1371: OPEN csr_inc_asg(pay_us_deposit_advice_pkg.g_payroll_id
1372: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1373: ,pay_us_deposit_advice_pkg.g_start_dt
1374: ,pay_us_deposit_advice_pkg.g_end_dt
1375: ,pay_payslip_report.g_pa_token
1376: ,pay_payslip_report.g_cs_token

Line 1373: ,pay_us_deposit_advice_pkg.g_start_dt

1369: --
1370: ELSE
1371: OPEN csr_inc_asg(pay_us_deposit_advice_pkg.g_payroll_id
1372: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1373: ,pay_us_deposit_advice_pkg.g_start_dt
1374: ,pay_us_deposit_advice_pkg.g_end_dt
1375: ,pay_payslip_report.g_pa_token
1376: ,pay_payslip_report.g_cs_token
1377: ,pay_us_deposit_advice_pkg.g_legislation_code

Line 1374: ,pay_us_deposit_advice_pkg.g_end_dt

1370: ELSE
1371: OPEN csr_inc_asg(pay_us_deposit_advice_pkg.g_payroll_id
1372: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1373: ,pay_us_deposit_advice_pkg.g_start_dt
1374: ,pay_us_deposit_advice_pkg.g_end_dt
1375: ,pay_payslip_report.g_pa_token
1376: ,pay_payslip_report.g_cs_token
1377: ,pay_us_deposit_advice_pkg.g_legislation_code
1378: ,pay_us_deposit_advice_pkg.g_assignment_set_id);

Line 1377: ,pay_us_deposit_advice_pkg.g_legislation_code

1373: ,pay_us_deposit_advice_pkg.g_start_dt
1374: ,pay_us_deposit_advice_pkg.g_end_dt
1375: ,pay_payslip_report.g_pa_token
1376: ,pay_payslip_report.g_cs_token
1377: ,pay_us_deposit_advice_pkg.g_legislation_code
1378: ,pay_us_deposit_advice_pkg.g_assignment_set_id);
1379: LOOP
1380:
1381: ln_assignment_id := -1;

Line 1378: ,pay_us_deposit_advice_pkg.g_assignment_set_id);

1374: ,pay_us_deposit_advice_pkg.g_end_dt
1375: ,pay_payslip_report.g_pa_token
1376: ,pay_payslip_report.g_cs_token
1377: ,pay_us_deposit_advice_pkg.g_legislation_code
1378: ,pay_us_deposit_advice_pkg.g_assignment_set_id);
1379: LOOP
1380:
1381: ln_assignment_id := -1;
1382: ln_action_ctx_id := -1;

Line 1391: ,pay_us_deposit_advice_pkg.g_start_dt

1387: EXIT;
1388: ELSE
1389: IF check_if_qualified_for_US(ln_action_ctx_id
1390: ,ln_assignment_id
1391: ,pay_us_deposit_advice_pkg.g_start_dt
1392: ,pay_us_deposit_advice_pkg.g_end_dt
1393: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN
1394:
1395: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;

Line 1392: ,pay_us_deposit_advice_pkg.g_end_dt

1388: ELSE
1389: IF check_if_qualified_for_US(ln_action_ctx_id
1390: ,ln_assignment_id
1391: ,pay_us_deposit_advice_pkg.g_start_dt
1392: ,pay_us_deposit_advice_pkg.g_end_dt
1393: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN
1394:
1395: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;
1396: hr_utility.trace('g_tmp_tbl(' || ln_assignment_id || ') := ' || ln_assignment_id);

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

1389: IF check_if_qualified_for_US(ln_action_ctx_id
1390: ,ln_assignment_id
1391: ,pay_us_deposit_advice_pkg.g_start_dt
1392: ,pay_us_deposit_advice_pkg.g_end_dt
1393: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN
1394:
1395: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;
1396: hr_utility.trace('g_tmp_tbl(' || ln_assignment_id || ') := ' || ln_assignment_id);
1397: END IF;

Line 1554: end pay_us_deposit_advice_pkg;

1550:
1551: end DAxml_range_cursor;
1552: --
1553: --
1554: end pay_us_deposit_advice_pkg;