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 1242: -- This procedure will update pay_run_balances for a particular assignment id

1238: ---
1239: ---
1240: ---
1241: --Per bug 2738574
1242: -- This procedure will update pay_run_balances for a particular assignment id
1243:
1244: PROCEDURE pay_run_balances (p_proc_type IN VARCHAR2,
1245: p_person_id IN NUMBER,
1246: p_assign_id IN NUMBER,

Line 1244: PROCEDURE pay_run_balances (p_proc_type IN VARCHAR2,

1240: ---
1241: --Per bug 2738574
1242: -- This procedure will update pay_run_balances for a particular assignment id
1243:
1244: PROCEDURE pay_run_balances (p_proc_type IN VARCHAR2,
1245: p_person_id IN NUMBER,
1246: p_assign_id IN NUMBER,
1247: p_new_city_code IN VARCHAR2,
1248: p_old_juri_code IN VARCHAR2,

Line 1255: FROM pay_run_balances

1251: IS
1252:
1253: CURSOR run_balance_cur(p_new_juri_code varchar2, p_old_juri_code varchar2, p_assign_id number)
1254: IS select 'Y'
1255: FROM pay_run_balances
1256: WHERE jurisdiction_code = p_old_juri_code
1257: AND assignment_id = p_assign_id
1258: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
1259: where pugu.assignment_id = p_assign_id

Line 1262: and pugu.table_name = 'PAY_RUN_BALANCES'

1258: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
1259: where pugu.assignment_id = p_assign_id
1260: and pugu.old_juri_code = p_old_juri_code
1261: and pugu.new_juri_code = p_new_juri_code
1262: and pugu.table_name = 'PAY_RUN_BALANCES'
1263: and pugu.process_mode = g_mode
1264: and pugu.process_type = g_process_type
1265: and pugu.id = g_geo_phase_id);
1266:

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

1268:
1269:
1270: BEGIN
1271:
1272: hr_utility.trace('Entering pay_us_geo_upd_pkg.pay_run_balances');
1273:
1274: IF ((p_proc_type <> 'SU' and p_proc_type <> 'US') and p_api_mode = 'N') THEN
1275:
1276: hr_utility.trace('Before update of pay_run_balances for assignment id: '||to_char(p_assign_id));

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

1272: hr_utility.trace('Entering pay_us_geo_upd_pkg.pay_run_balances');
1273:
1274: IF ((p_proc_type <> 'SU' and p_proc_type <> 'US') and p_api_mode = 'N') THEN
1275:
1276: hr_utility.trace('Before update of pay_run_balances for assignment id: '||to_char(p_assign_id));
1277:
1278: IF G_MODE = 'UPGRADE' THEN
1279:
1280: UPDATE pay_run_balances

Line 1280: UPDATE pay_run_balances

1276: hr_utility.trace('Before update of pay_run_balances for assignment id: '||to_char(p_assign_id));
1277:
1278: IF G_MODE = 'UPGRADE' THEN
1279:
1280: UPDATE pay_run_balances
1281: SET jurisdiction_code = p_new_juri_code,
1282: jurisdiction_comp3 = p_new_city_code
1283: WHERE assignment_id = p_assign_id
1284: AND jurisdiction_code = p_old_juri_code ;

Line 1298: p_location => 'PAY_RUN_BALANCES',

1294: p_person_id => p_person_id,
1295: p_assign_id => p_assign_id,
1296: p_old_juri_code => p_old_juri_code,
1297: p_new_juri_code => p_new_juri_code,
1298: p_location => 'PAY_RUN_BALANCES',
1299: p_id => p_assign_id);
1300:
1301:
1302: /*END IF;*/

Line 1318: p_location => 'PAY_RUN_BALANCES',

1314: p_person_id => p_person_id,
1315: p_assign_id => p_assign_id,
1316: p_old_juri_code => p_old_juri_code,
1317: p_new_juri_code => p_new_juri_code,
1318: p_location => 'PAY_RUN_BALANCES',
1319: p_id => p_assign_id);
1320:
1321:
1322: END IF;

Line 1327: END pay_run_balances ;

1323: CLOSE run_balance_cur;
1324:
1325: END IF;
1326:
1327: END pay_run_balances ;
1328:
1329: ---
1330: ---
1331: ---

Line 2950: --Update the pay_run_balances table.

2946: ---
2947: ---
2948: ---
2949: --Per bug 2738574
2950: --Update the pay_run_balances table.
2951:
2952: l_proc_stage := 'PAY_RUN_BALANCES';
2953:
2954: pay_run_balances(

Line 2952: l_proc_stage := 'PAY_RUN_BALANCES';

2948: ---
2949: --Per bug 2738574
2950: --Update the pay_run_balances table.
2951:
2952: l_proc_stage := 'PAY_RUN_BALANCES';
2953:
2954: pay_run_balances(
2955: p_proc_type => main_proc_type,
2956: p_person_id => main_person_id,

Line 2954: pay_run_balances(

2950: --Update the pay_run_balances table.
2951:
2952: l_proc_stage := 'PAY_RUN_BALANCES';
2953:
2954: pay_run_balances(
2955: p_proc_type => main_proc_type,
2956: p_person_id => main_person_id,
2957: p_assign_id => main_assign_id,
2958: p_new_city_code => main_new_city_code,

Line 3911: --update pay_run_balances.jurisdiction_code

3907: --
3908: --
3909: --
3910: --Per bug 2996546,Created a new procedure group_level_balance to
3911: --update pay_run_balances.jurisdiction_code
3912: --for group level balances (both US and Canadian
3913: --legislation)
3914: --
3915: --

Line 3932: from pay_run_balances prb, pay_us_modified_geocodes pmod

3928:
3929: CURSOR group_level_bal_us (c_payroll_action_id number) IS
3930: select
3931: prb.run_balance_id, prb.jurisdiction_code, prb.jurisdiction_comp3
3932: from pay_run_balances prb, pay_us_modified_geocodes pmod
3933: Where prb.payroll_action_id = c_payroll_action_id
3934: --between p_start_payroll_action and p_end_payroll_action
3935: and prb.assignment_id is null
3936: and pmod.state_code = substr(prb.jurisdiction_code,1,2)

Line 3948: and pugu.table_name = 'PAY_RUN_BALANCES'

3944: and pugu.process_mode = g_mode
3945: and pugu.assignment_id is null
3946: and pugu.old_juri_code = prb.jurisdiction_code
3947: and pugu.person_id = prb.run_balance_id
3948: and pugu.table_name = 'PAY_RUN_BALANCES'
3949: and pugu.id = g_geo_phase_id);*/
3950:
3951: /* select /*+ ORDERED
3952: index(pmod PAY_US_MODIFIED_GEOCODES_N1)

Line 3957: from pay_run_balances prb,

3953: USE_NL(prb pdb pbd pmod) */
3954: /* prb.run_balance_id,
3955: prb.jurisdiction_code,
3956: prb.jurisdiction_comp3
3957: from pay_run_balances prb,
3958: pay_defined_balances pdb,
3959: pay_balance_dimensions pbd,
3960: pay_us_modified_geocodes pmod
3961: Where prb.payroll_action_id = c_payroll_action_id

Line 3979: and pugu.table_name = 'PAY_RUN_BALANCES'

3975: and pugu.process_mode = g_mode
3976: and pugu.assignment_id is null
3977: and pugu.old_juri_code = pmod.state_code || '-' || pmod.county_code || '-' || pmod.old_city_code --prb.jurisdiction_code
3978: and pugu.person_id = prb.payroll_action_id
3979: and pugu.table_name = 'PAY_RUN_BALANCES'
3980: and pugu.id = g_geo_phase_id);
3981: */
3982: group_level_bal_us_rec group_level_bal_us%ROWTYPE;
3983:

Line 3988: from pay_run_balances prb, pay_us_modified_geocodes pmod

3984:
3985: CURSOR group_level_bal_ca (c_payroll_action_id number) IS
3986: select
3987: prb.run_balance_id, prb.jurisdiction_code, prb.jurisdiction_comp3
3988: from pay_run_balances prb, pay_us_modified_geocodes pmod
3989: Where prb.payroll_action_id = c_payroll_action_id
3990: --between p_start_payroll_action and p_end_payroll_action
3991: and prb.assignment_id is null
3992: and pmod.state_code = 'CA'

Line 4002: and pugu.table_name = 'PAY_RUN_BALANCES'

3998: and NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
3999: where pugu.old_juri_code = prb.jurisdiction_code
4000: and pugu.assignment_id is null
4001: and pugu.person_id = prb.run_balance_id
4002: and pugu.table_name = 'PAY_RUN_BALANCES'
4003: and pugu.process_mode = g_mode
4004: and pugu.process_type = g_process_type
4005: and pugu.id = g_geo_phase_id); */
4006:

Line 4013: from pay_run_balances prb,

4009: USE_NL(prb pdb pbd pmod) */
4010: /* prb.run_balance_id,
4011: prb.jurisdiction_code,
4012: prb.jurisdiction_comp3
4013: from pay_run_balances prb,
4014: pay_defined_balances pdb,
4015: pay_balance_dimensions pbd,
4016: pay_us_modified_geocodes pmod
4017: Where prb.payroll_action_id = c_payroll_action_id

Line 4032: and pugu.table_name = 'PAY_RUN_BALANCES'

4028: and NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
4029: where pugu.old_juri_code = prb.jurisdiction_code
4030: and pugu.assignment_id is null
4031: and pugu.person_id = prb.payroll_action_id
4032: and pugu.table_name = 'PAY_RUN_BALANCES'
4033: and pugu.process_mode = g_mode
4034: and pugu.process_type = g_process_type
4035: and pugu.id = g_geo_phase_id); */
4036:

Line 4052: l_geocode pay_run_balances.jurisdiction_code%TYPE;

4048: group_level_bal_ca_rec group_level_bal_ca%ROWTYPE;
4049:
4050:
4051: l_proc_type pay_us_modified_geocodes.process_type%TYPE;
4052: l_geocode pay_run_balances.jurisdiction_code%TYPE;
4053: l_new_city_code pay_us_modified_geocodes.new_city_code%TYPE;
4054: l_legislation_code per_business_groups.legislation_code%TYPE;
4055: l_pactid pay_payroll_actions.payroll_action_id%TYPE;
4056:

Line 4096: and pugu.table_name = 'PAY_RUN_BALANCES'

4092: from PAY_US_GEO_UPDATE pugu
4093: where pugu.old_juri_code = group_level_bal_us_rec.jurisdiction_code
4094: and pugu.assignment_id is null
4095: and pugu.person_id = group_level_bal_us_rec.run_balance_id
4096: and pugu.table_name = 'PAY_RUN_BALANCES'
4097: and pugu.process_mode = g_mode
4098: and pugu.process_type = g_process_type
4099: and pugu.id = g_geo_phase_id;
4100:

Line 4118: UPDATE pay_run_balances

4114: AND pmod.patch_name = p_patch_name;
4115:
4116: IF G_MODE = 'UPGRADE' THEN
4117:
4118: UPDATE pay_run_balances
4119: SET jurisdiction_code = l_geocode,
4120: jurisdiction_comp3 = l_new_city_code
4121: WHERE payroll_action_id = group_level_bal_us_rec.run_balance_id
4122: -- AND jurisdiction_comp3 = group_level_bal_us_rec.jurisdiction_comp3

Line 4137: p_location => 'PAY_RUN_BALANCES',

4133: p_person_id => group_level_bal_us_rec.run_balance_id,
4134: p_assign_id => null,
4135: p_old_juri_code => group_level_bal_us_rec.jurisdiction_code,
4136: p_new_juri_code => l_geocode,
4137: p_location => 'PAY_RUN_BALANCES',
4138: p_id => null);
4139:
4140: hr_utility.set_location('pay_us_geo_upd_pkg. group_level_balance',3);
4141:

Line 4167: and pugu.table_name = 'PAY_RUN_BALANCES'

4163: from PAY_US_GEO_UPDATE pugu
4164: where pugu.old_juri_code = group_level_bal_ca_rec.jurisdiction_code
4165: and pugu.assignment_id is null
4166: and pugu.person_id = group_level_bal_ca_rec.run_balance_id
4167: and pugu.table_name = 'PAY_RUN_BALANCES'
4168: and pugu.process_mode = g_mode
4169: and pugu.process_type = g_process_type
4170: and pugu.id = g_geo_phase_id;
4171:

Line 4190: UPDATE pay_run_balances

4186: hr_utility.trace('Entering pay_us_geo_upd_pkg. group_level_balance - 7003');
4187:
4188: IF G_MODE = 'UPGRADE' THEN
4189:
4190: UPDATE pay_run_balances
4191: SET jurisdiction_code = l_geocode
4192: WHERE payroll_action_id = group_level_bal_ca_rec.run_balance_id
4193: -- AND jurisdiction_comp3 = group_level_bal_ca_rec.jurisdiction_comp3
4194: -- AND jurisdiction_code = group_level_bal_ca_rec.jurisdiction_code

Line 4211: p_location => 'PAY_RUN_BALANCES',

4207: p_person_id => group_level_bal_ca_rec.run_balance_id,
4208: p_assign_id => null,
4209: p_old_juri_code => group_level_bal_ca_rec.jurisdiction_code,
4210: p_new_juri_code => l_geocode,
4211: p_location => 'PAY_RUN_BALANCES',
4212: p_id => null);
4213:
4214: hr_utility.set_location('pay_us_geo_upd_pkg. group_level_balance',6);
4215: