APPS.PAY_IN_MED_WEB_ADI dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 165: FROM per_assignment_extra_info pae

161:
162: CURSOR c_get_prev_amts
163: IS
164: SELECT pae.aei_information7, pae.aei_information11
165: FROM per_assignment_extra_info pae
166: WHERE pae.assignment_extra_info_id = p_assignment_extra_info_id;
167:
168: CURSOR c_element(p_element_type_id NUMBER)
169: IS

Line 206: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;

202: l_start_date DATE ;
203: l_end_date DATE ;
204: l_effective_start_date DATE ;
205: l_ben_start_date DATE ;
206: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
207: l_ben_version_no per_assignment_extra_info.object_version_number%TYPE ;
208: l_entry_information1 pay_element_entries_f.entry_information2%TYPE ;
209: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
210: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;

Line 207: l_ben_version_no per_assignment_extra_info.object_version_number%TYPE ;

203: l_end_date DATE ;
204: l_effective_start_date DATE ;
205: l_ben_start_date DATE ;
206: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
207: l_ben_version_no per_assignment_extra_info.object_version_number%TYPE ;
208: l_entry_information1 pay_element_entries_f.entry_information2%TYPE ;
209: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
210: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;
211: l_entry_information7 pay_element_entries_f.entry_information2%TYPE ;

Line 747: UPDATE per_assignment_extra_info

743:
744:
745:
746:
747: UPDATE per_assignment_extra_info
748: SET AEI_INFORMATION7 = p_approved_bill_amount
749: ,AEI_INFORMATION9 = p_employer_remarks
750: ,AEI_INFORMATION10 = nvl(l_bill_entry_id,l_element_entry_id)
751: ,AEI_INFORMATION11 = l_ben_entry_id

Line 832: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;

828: l_count NUMBER;
829: l_element_type_id NUMBER;
830: l_start_date DATE ;
831: l_end_date DATE ;
832: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
833:
834:
835:
836: BEGIN

Line 1068: FROM per_assignment_extra_info pae

1064: CURSOR c_get_prev_amts
1065: IS
1066: SELECT pae.aei_information9,
1067: pae.aei_information10
1068: FROM per_assignment_extra_info pae
1069: WHERE pae.assignment_extra_info_id = p_assignment_extra_info_id;
1070:
1071: CURSOR c_element(p_element_type_id NUMBER)
1072: IS

Line 1104: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;

1100: l_element_entry_id NUMBER := NULL ;
1101: l_start_date DATE ;
1102: l_end_date DATE ;
1103: l_effective_start_date DATE ;
1104: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
1105: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;
1106: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
1107: l_submitted NUMBER ;
1108: l_prev_submitted NUMBER ;

Line 1264: UPDATE per_assignment_extra_info

1260: ,p_effective_end_date => l_end_date
1261: ,p_update_warning => l_warnings
1262: );
1263:
1264: UPDATE per_assignment_extra_info
1265: SET
1266: AEI_INFORMATION21 = P_BENEFIT
1267: WHERE AEI_INFORMATION11 = p_element_entry_id
1268: AND assignment_id = p_assignment_id;

Line 1380: UPDATE per_assignment_extra_info

1376: ,p_effective_end_date => l_end_date
1377: ,p_update_warning => l_warnings
1378: );
1379:
1380: UPDATE per_assignment_extra_info
1381: SET
1382: AEI_INFORMATION21 = P_BENEFIT
1383: where AEI_INFORMATION11 = l_element_entry_id
1384: and assignment_id = p_assignment_id;

Line 1474: UPDATE per_assignment_extra_info

1470: pay_in_utils.set_location(g_debug,'Updating Assignment_Extra_Info: '||l_procedure,70);
1471:
1472: IF P_EMPLOYEE_ID <> 0 THEN /* To prevent this from Self Service page and execute only for web adi*/
1473:
1474: UPDATE per_assignment_extra_info
1475: SET AEI_INFORMATION10 = P_EXEMPTED
1476: ,AEI_INFORMATION6 = P_ER_COMMENTS
1477: ,AEI_INFORMATION11 = nvl(l_element_entry_id,p_element_entry_id)
1478: ,aei_information18 = P_CARRY_OVER

Line 1570: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;

1566: l_count NUMBER;
1567: l_element_type_id NUMBER;
1568: l_start_date DATE ;
1569: l_end_date DATE ;
1570: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
1571: l_session NUMBER ;
1572:
1573:
1574:

Line 1687: UPDATE per_assignment_extra_info

1683:
1684:
1685: END IF ;
1686:
1687: UPDATE per_assignment_extra_info
1688: SET AEI_INFORMATION18 = p_carry
1689: ,AEI_INFORMATION21 = P_BENEFIT
1690: where AEI_INFORMATION11 = p_element_entry_id
1691: and assignment_id = p_assignment_id;