APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_BALANCE_BATCH_LINES

Line 1145: -- This procedure will update pay balance batch lines for a particular assignment id

1141:
1142:
1143: END load_input_values;
1144:
1145: -- This procedure will update pay balance batch lines for a particular assignment id
1146: -- Note the cursor use here. Where we have the cursor in before both write messages
1147: -- this is because if we want to run in debug mode and the type is not SU and US the
1148: -- sql rowcount wont work because we are bypassing the update.
1149:

Line 1160: FROM pay_balance_batch_lines

1156: IS
1157:
1158: CURSOR bal_batch_cur(p_new_juri_code varchar2, p_old_juri_code varchar2, p_assign_id number)
1159: IS select 'Y'
1160: FROM pay_balance_batch_lines
1161: WHERE jurisdiction_code = p_old_juri_code
1162: AND assignment_id = p_assign_id
1163: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
1164: where pugu.assignment_id = p_assign_id

Line 1167: and pugu.table_name = 'PAY_BALANCE_BATCH_LINES'

1163: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
1164: where pugu.assignment_id = p_assign_id
1165: and pugu.old_juri_code = p_old_juri_code
1166: and pugu.new_juri_code = p_new_juri_code
1167: and pugu.table_name = 'PAY_BALANCE_BATCH_LINES'
1168: and pugu.process_mode = g_mode
1169: and pugu.process_type = g_process_type
1170: and pugu.id = g_geo_phase_id);
1171:

Line 1185: UPDATE pay_balance_batch_lines

1181: hr_utility.trace('Before update of balance_batch_lines for assignment id: '||to_char(p_assign_id));
1182:
1183: IF G_MODE = 'UPGRADE' THEN
1184:
1185: UPDATE pay_balance_batch_lines
1186: SET jurisdiction_code = p_new_juri_code
1187: WHERE jurisdiction_code = p_old_juri_code
1188: AND assignment_id = p_assign_id;
1189:

Line 1206: p_location => 'PAY_BALANCE_BATCH_LINES',

1202: p_person_id => p_person_id,
1203: p_assign_id => p_assign_id,
1204: p_old_juri_code => p_old_juri_code,
1205: p_new_juri_code => p_new_juri_code,
1206: p_location => 'PAY_BALANCE_BATCH_LINES',
1207: p_id => p_assign_id);
1208:
1209: END IF;
1210: CLOSE bal_batch_cur;

Line 1228: p_location => 'PAY_BALANCE_BATCH_LINES',

1224: p_person_id => p_person_id,
1225: p_assign_id => p_assign_id,
1226: p_old_juri_code => p_old_juri_code,
1227: p_new_juri_code => p_new_juri_code,
1228: p_location => 'PAY_BALANCE_BATCH_LINES',
1229: p_id => p_assign_id);
1230:
1231:
1232: END IF;

Line 2933: --Update the pay_balance_batch_lines table.

2929: END LOOP;
2930: CLOSE plbcv_cur;
2931: -- End Rosie Monge addition for bug 4602222
2932:
2933: --Update the pay_balance_batch_lines table.
2934:
2935: l_proc_stage := 'BALANCE_BATCH_LINES';
2936:
2937: balance_batch_lines(