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_GEO_UPD_PKG dependencies on PAY_RUN_BALANCES

Line 1451: -- This procedure will update pay_run_balances for a particular assignment id

1447: ---
1448: ---
1449: ---
1450: --Per bug 2738574
1451: -- This procedure will update pay_run_balances for a particular assignment id
1452:
1453: PROCEDURE pay_run_balances (p_proc_type IN VARCHAR2,
1454: p_person_id IN NUMBER,
1455: p_assign_id IN NUMBER,

Line 1453: PROCEDURE pay_run_balances (p_proc_type IN VARCHAR2,

1449: ---
1450: --Per bug 2738574
1451: -- This procedure will update pay_run_balances for a particular assignment id
1452:
1453: PROCEDURE pay_run_balances (p_proc_type IN VARCHAR2,
1454: p_person_id IN NUMBER,
1455: p_assign_id IN NUMBER,
1456: p_new_city_code IN VARCHAR2,
1457: p_old_juri_code IN VARCHAR2,

Line 1464: FROM pay_run_balances

1460: IS
1461:
1462: CURSOR run_balance_cur(p_new_juri_code varchar2, p_old_juri_code varchar2, p_assign_id number)
1463: IS select 'Y'
1464: FROM pay_run_balances
1465: WHERE jurisdiction_code = p_old_juri_code
1466: AND assignment_id = p_assign_id
1467: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
1468: where pugu.assignment_id = p_assign_id

Line 1471: and pugu.table_name = 'PAY_RUN_BALANCES'

1467: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
1468: where pugu.assignment_id = p_assign_id
1469: and pugu.old_juri_code = p_old_juri_code
1470: and pugu.new_juri_code = p_new_juri_code
1471: and pugu.table_name = 'PAY_RUN_BALANCES'
1472: and pugu.process_mode = g_mode
1473: and pugu.process_type = g_process_type
1474: and pugu.id = g_geo_phase_id);
1475:

Line 1481: hr_utility.trace('Entering pay_us_geo_upd_pkg.pay_run_balances');

1477: l_run_balance_count number;
1478:
1479: BEGIN
1480:
1481: hr_utility.trace('Entering pay_us_geo_upd_pkg.pay_run_balances');
1482:
1483: IF ((p_proc_type <> 'SU' and p_proc_type <> 'US') and p_api_mode = 'N') THEN
1484:
1485: hr_utility.trace('Before update of pay_run_balances for assignment id: '||to_char(p_assign_id));

Line 1485: hr_utility.trace('Before update of pay_run_balances for assignment id: '||to_char(p_assign_id));

1481: hr_utility.trace('Entering pay_us_geo_upd_pkg.pay_run_balances');
1482:
1483: IF ((p_proc_type <> 'SU' and p_proc_type <> 'US') and p_api_mode = 'N') THEN
1484:
1485: hr_utility.trace('Before update of pay_run_balances for assignment id: '||to_char(p_assign_id));
1486:
1487: IF G_MODE = 'UPGRADE' THEN
1488:
1489: UPDATE pay_run_balances

Line 1489: UPDATE pay_run_balances

1485: hr_utility.trace('Before update of pay_run_balances for assignment id: '||to_char(p_assign_id));
1486:
1487: IF G_MODE = 'UPGRADE' THEN
1488:
1489: UPDATE pay_run_balances
1490: SET jurisdiction_code = p_new_juri_code,
1491: jurisdiction_comp3 = p_new_city_code
1492: WHERE assignment_id = p_assign_id
1493: AND jurisdiction_code = p_old_juri_code ;

Line 1503: p_location => 'PAY_RUN_BALANCES',

1499: p_person_id => p_person_id,
1500: p_assign_id => p_assign_id,
1501: p_old_juri_code => p_old_juri_code,
1502: p_new_juri_code => p_new_juri_code,
1503: p_location => 'PAY_RUN_BALANCES',
1504: p_id => p_assign_id);
1505:
1506: END IF;
1507:

Line 1516: FROM pay_run_balances prb,

1512: l_run_balance_count := 0;
1513:
1514: SELECT count(*)
1515: INTO l_run_balance_count
1516: FROM pay_run_balances prb,
1517: pay_assignment_actions paa
1518: WHERE paa.assignment_id = p_assign_id
1519: AND paa.assignment_action_id = prb.assignment_action_id
1520: AND paa.assignment_id = prb.assignment_id

Line 1534: p_location => 'PAY_RUN_BALANCES',

1530: p_person_id => p_person_id,
1531: p_assign_id => p_assign_id,
1532: p_old_juri_code => p_old_juri_code,
1533: p_new_juri_code => p_new_juri_code,
1534: p_location => 'PAY_RUN_BALANCES',
1535: p_id => p_assign_id);
1536:
1537:
1538: END IF;

Line 1556: p_location => 'PAY_RUN_BALANCES',

1552: p_person_id => p_person_id,
1553: p_assign_id => p_assign_id,
1554: p_old_juri_code => p_old_juri_code,
1555: p_new_juri_code => p_new_juri_code,
1556: p_location => 'PAY_RUN_BALANCES',
1557: p_id => p_assign_id);
1558:
1559:
1560: END IF;

Line 1565: END pay_run_balances ;

1561: CLOSE run_balance_cur;
1562:
1563: END IF;
1564:
1565: END pay_run_balances ;
1566:
1567: ---
1568: ---
1569: ---

Line 3243: --Update the pay_run_balances table.

3239: ---
3240: ---
3241: ---
3242: --Per bug 2738574
3243: --Update the pay_run_balances table.
3244:
3245: l_proc_stage := 'PAY_RUN_BALANCES';
3246:
3247: pay_run_balances(

Line 3245: l_proc_stage := 'PAY_RUN_BALANCES';

3241: ---
3242: --Per bug 2738574
3243: --Update the pay_run_balances table.
3244:
3245: l_proc_stage := 'PAY_RUN_BALANCES';
3246:
3247: pay_run_balances(
3248: p_proc_type => main_proc_type,
3249: p_person_id => main_person_id,

Line 3247: pay_run_balances(

3243: --Update the pay_run_balances table.
3244:
3245: l_proc_stage := 'PAY_RUN_BALANCES';
3246:
3247: pay_run_balances(
3248: p_proc_type => main_proc_type,
3249: p_person_id => main_person_id,
3250: p_assign_id => main_assign_id,
3251: p_new_city_code => main_new_city_code,

Line 5183: --update pay_run_balances.jurisdiction_code

5179: --
5180: --
5181: --
5182: --Per bug 2996546,Created a new procedure group_level_balance to
5183: --update pay_run_balances.jurisdiction_code
5184: --for group level balances (both US and Canadian
5185: --legislation)
5186: --
5187: --

Line 5204: from pay_run_balances prb, pay_us_modified_geocodes pmod

5200:
5201: CURSOR group_level_bal_us (c_payroll_action_id number) IS
5202: select
5203: prb.run_balance_id, prb.jurisdiction_code, prb.jurisdiction_comp3
5204: from pay_run_balances prb, pay_us_modified_geocodes pmod
5205: Where prb.payroll_action_id = c_payroll_action_id
5206: --between p_start_payroll_action and p_end_payroll_action
5207: and prb.assignment_id is null
5208: and pmod.state_code = substr(prb.jurisdiction_code,1,2)

Line 5220: and pugu.table_name = 'PAY_RUN_BALANCES'

5216: and pugu.process_mode = g_mode
5217: and pugu.assignment_id is null
5218: and pugu.old_juri_code = prb.jurisdiction_code
5219: and pugu.person_id = prb.run_balance_id
5220: and pugu.table_name = 'PAY_RUN_BALANCES'
5221: and pugu.id = g_geo_phase_id);*/
5222:
5223: /* select /*+ ORDERED
5224: index(pmod PAY_US_MODIFIED_GEOCODES_N1)

Line 5229: from pay_run_balances prb,

5225: USE_NL(prb pdb pbd pmod) */
5226: /* prb.run_balance_id,
5227: prb.jurisdiction_code,
5228: prb.jurisdiction_comp3
5229: from pay_run_balances prb,
5230: pay_defined_balances pdb,
5231: pay_balance_dimensions pbd,
5232: pay_us_modified_geocodes pmod
5233: Where prb.payroll_action_id = c_payroll_action_id

Line 5251: and pugu.table_name = 'PAY_RUN_BALANCES'

5247: and pugu.process_mode = g_mode
5248: and pugu.assignment_id is null
5249: and pugu.old_juri_code = pmod.state_code || '-' || pmod.county_code || '-' || pmod.old_city_code --prb.jurisdiction_code
5250: and pugu.person_id = prb.payroll_action_id
5251: and pugu.table_name = 'PAY_RUN_BALANCES'
5252: and pugu.id = g_geo_phase_id);
5253: */
5254: group_level_bal_us_rec group_level_bal_us%ROWTYPE;
5255:

Line 5260: from pay_run_balances prb, pay_us_modified_geocodes pmod

5256:
5257: CURSOR group_level_bal_ca (c_payroll_action_id number) IS
5258: select
5259: prb.run_balance_id, prb.jurisdiction_code, prb.jurisdiction_comp3
5260: from pay_run_balances prb, pay_us_modified_geocodes pmod
5261: Where prb.payroll_action_id = c_payroll_action_id
5262: --between p_start_payroll_action and p_end_payroll_action
5263: and prb.assignment_id is null
5264: and pmod.state_code = 'CA'

Line 5274: and pugu.table_name = 'PAY_RUN_BALANCES'

5270: and NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
5271: where pugu.old_juri_code = prb.jurisdiction_code
5272: and pugu.assignment_id is null
5273: and pugu.person_id = prb.run_balance_id
5274: and pugu.table_name = 'PAY_RUN_BALANCES'
5275: and pugu.process_mode = g_mode
5276: and pugu.process_type = g_process_type
5277: and pugu.id = g_geo_phase_id); */
5278:

Line 5285: from pay_run_balances prb,

5281: USE_NL(prb pdb pbd pmod) */
5282: /* prb.run_balance_id,
5283: prb.jurisdiction_code,
5284: prb.jurisdiction_comp3
5285: from pay_run_balances prb,
5286: pay_defined_balances pdb,
5287: pay_balance_dimensions pbd,
5288: pay_us_modified_geocodes pmod
5289: Where prb.payroll_action_id = c_payroll_action_id

Line 5304: and pugu.table_name = 'PAY_RUN_BALANCES'

5300: and NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
5301: where pugu.old_juri_code = prb.jurisdiction_code
5302: and pugu.assignment_id is null
5303: and pugu.person_id = prb.payroll_action_id
5304: and pugu.table_name = 'PAY_RUN_BALANCES'
5305: and pugu.process_mode = g_mode
5306: and pugu.process_type = g_process_type
5307: and pugu.id = g_geo_phase_id); */
5308:

Line 5324: l_geocode pay_run_balances.jurisdiction_code%TYPE;

5320: group_level_bal_ca_rec group_level_bal_ca%ROWTYPE;
5321:
5322:
5323: l_proc_type pay_us_modified_geocodes.process_type%TYPE;
5324: l_geocode pay_run_balances.jurisdiction_code%TYPE;
5325: l_new_city_code pay_us_modified_geocodes.new_city_code%TYPE;
5326: l_legislation_code per_business_groups.legislation_code%TYPE;
5327: l_pactid pay_payroll_actions.payroll_action_id%TYPE;
5328:

Line 5368: and pugu.table_name = 'PAY_RUN_BALANCES'

5364: from PAY_US_GEO_UPDATE pugu
5365: where pugu.old_juri_code = group_level_bal_us_rec.jurisdiction_code
5366: and pugu.assignment_id is null
5367: and pugu.person_id = group_level_bal_us_rec.run_balance_id
5368: and pugu.table_name = 'PAY_RUN_BALANCES'
5369: and pugu.process_mode = g_mode
5370: and pugu.process_type = g_process_type
5371: and pugu.id = g_geo_phase_id;
5372:

Line 5390: UPDATE pay_run_balances

5386: AND pmod.patch_name = p_patch_name;
5387:
5388: IF G_MODE = 'UPGRADE' THEN
5389:
5390: UPDATE pay_run_balances
5391: SET jurisdiction_code = l_geocode,
5392: jurisdiction_comp3 = l_new_city_code
5393: WHERE payroll_action_id = group_level_bal_us_rec.run_balance_id
5394: -- AND jurisdiction_comp3 = group_level_bal_us_rec.jurisdiction_comp3

Line 5409: p_location => 'PAY_RUN_BALANCES',

5405: p_person_id => group_level_bal_us_rec.run_balance_id,
5406: p_assign_id => null,
5407: p_old_juri_code => group_level_bal_us_rec.jurisdiction_code,
5408: p_new_juri_code => l_geocode,
5409: p_location => 'PAY_RUN_BALANCES',
5410: p_id => null);
5411:
5412: hr_utility.set_location('pay_us_geo_upd_pkg. group_level_balance',3);
5413:

Line 5439: and pugu.table_name = 'PAY_RUN_BALANCES'

5435: from PAY_US_GEO_UPDATE pugu
5436: where pugu.old_juri_code = group_level_bal_ca_rec.jurisdiction_code
5437: and pugu.assignment_id is null
5438: and pugu.person_id = group_level_bal_ca_rec.run_balance_id
5439: and pugu.table_name = 'PAY_RUN_BALANCES'
5440: and pugu.process_mode = g_mode
5441: and pugu.process_type = g_process_type
5442: and pugu.id = g_geo_phase_id;
5443:

Line 5462: UPDATE pay_run_balances

5458: hr_utility.trace('Entering pay_us_geo_upd_pkg. group_level_balance - 7003');
5459:
5460: IF G_MODE = 'UPGRADE' THEN
5461:
5462: UPDATE pay_run_balances
5463: SET jurisdiction_code = l_geocode
5464: WHERE payroll_action_id = group_level_bal_ca_rec.run_balance_id
5465: -- AND jurisdiction_comp3 = group_level_bal_ca_rec.jurisdiction_comp3
5466: -- AND jurisdiction_code = group_level_bal_ca_rec.jurisdiction_code

Line 5483: p_location => 'PAY_RUN_BALANCES',

5479: p_person_id => group_level_bal_ca_rec.run_balance_id,
5480: p_assign_id => null,
5481: p_old_juri_code => group_level_bal_ca_rec.jurisdiction_code,
5482: p_new_juri_code => l_geocode,
5483: p_location => 'PAY_RUN_BALANCES',
5484: p_id => null);
5485:
5486: hr_utility.set_location('pay_us_geo_upd_pkg. group_level_balance',6);
5487: