[Home] [Help]
113: X_Global_Name VARCHAR2,
114: X_Local_Name VARCHAR2
115: ) IS
116: --
117: l_old_work_telephone per_phones.phone_number%TYPE;
118: l_phn_object_version_number per_phones.object_version_number%TYPE;
119: l_phone_id per_phones.phone_id%TYPE;
120: --
121: cursor csr_phones is
114: X_Local_Name VARCHAR2
115: ) IS
116: --
117: l_old_work_telephone per_phones.phone_number%TYPE;
118: l_phn_object_version_number per_phones.object_version_number%TYPE;
119: l_phone_id per_phones.phone_id%TYPE;
120: --
121: cursor csr_phones is
122: select phone_number, phone_id, phn.object_version_number
115: ) IS
116: --
117: l_old_work_telephone per_phones.phone_number%TYPE;
118: l_phn_object_version_number per_phones.object_version_number%TYPE;
119: l_phone_id per_phones.phone_id%TYPE;
120: --
121: cursor csr_phones is
122: select phone_number, phone_id, phn.object_version_number
123: from per_phones phn
119: l_phone_id per_phones.phone_id%TYPE;
120: --
121: cursor csr_phones is
122: select phone_number, phone_id, phn.object_version_number
123: from per_phones phn
124: --
125: -- Removed fnd_sessions_f table in From Clause
126: -- becuase it is not used in the data retrieval at all.
127: -- fnd_sessions f
215: registered_disabled_flag = X_Registered_Disabled_Flag,
216: sex = X_Sex,
217: title = X_Title,
218: vendor_id = X_Vendor_Id,
219: -- The update of the work_telephone data is now done on the PER_PHONES table.
220: -- work_telephone = X_Work_Telephone,
221: attribute_category = X_Attribute_Category,
222: attribute1 = X_Attribute1,
223: attribute2 = X_Attribute2,
368: --
369: elsif l_old_work_telephone is not null and x_work_telephone is not null then
370: hr_utility.set_location('Entering : per_people_v7_pkg.update_row',90);
371: --
372: -- 115.22: only one row is maintained in per_phones.
373: -- when changing the phone, date_to should remain null. This keeps the
374: -- row "open" until the "end of time"
375: if ( l_old_work_telephone <> x_work_telephone) then
376: -- Bug 5554383 : Added IF condition.
915: X_Sex => Per_rec.Sex,
916: X_Title => Per_rec.Title,
917: X_Vendor_Id => Per_rec.Vendor_Id,
918: --
919: -- 115.22 : We need to ensure the per_phones table does not create rows.
920: -- Phone changes are handled by the "update_phone" api
921: --
922: X_Work_Telephone => null, -- 1020074 Per_rec.Work_Telephone,
923: X_Attribute_Category => Per_rec.Attribute_Category,
1280: l_dummy_num NUMBER(20);
1281: l_earlier_date DATE;
1282: l_assignment_type VARCHAR2(1);
1283: l_later_date DATE;
1284: l_Work_Telephone per_phones.phone_number%TYPE;
1285: l_Phone_Id per_phones.phone_id%TYPE;
1286: l_Phone_OVN per_phones.object_version_number%TYPE;
1287: --
1288: l_business_group_id per_all_people_f.business_group_id%TYPE;
1281: l_earlier_date DATE;
1282: l_assignment_type VARCHAR2(1);
1283: l_later_date DATE;
1284: l_Work_Telephone per_phones.phone_number%TYPE;
1285: l_Phone_Id per_phones.phone_id%TYPE;
1286: l_Phone_OVN per_phones.object_version_number%TYPE;
1287: --
1288: l_business_group_id per_all_people_f.business_group_id%TYPE;
1289: --
1282: l_assignment_type VARCHAR2(1);
1283: l_later_date DATE;
1284: l_Work_Telephone per_phones.phone_number%TYPE;
1285: l_Phone_Id per_phones.phone_id%TYPE;
1286: l_Phone_OVN per_phones.object_version_number%TYPE;
1287: --
1288: l_business_group_id per_all_people_f.business_group_id%TYPE;
1289: --
1290:
1338: and lc_date_from between date_from and nvl(date_to,hr_api.g_eot);
1339: --
1340: cursor phones is
1341: select phone_id,phone_number,object_version_number
1342: from per_phones
1343: where parent_table = 'PER_ALL_PEOPLE_F'
1344: and parent_id = X_Person_Id
1345: and date_from = X_S_Hire_Date
1346: and phone_type = 'W1';
1741: --
1742: -- While terminating an employee, it creates another row in per_all_people_f
1743: -- and per_phines, and while canceling the termination, it deletes the second
1744: -- row and updates the date_to of first row (reverse Date-track change) in
1745: -- per_all_people_f but not in per_phones table. Modified the code so that while
1746: -- canceling the termination, it removes the second row and updates the
1747: -- date_to (reverse Date-track change) of work_phone in per_phones table too.
1748: --
1749: -- delete from per_phones
1743: -- and per_phines, and while canceling the termination, it deletes the second
1744: -- row and updates the date_to of first row (reverse Date-track change) in
1745: -- per_all_people_f but not in per_phones table. Modified the code so that while
1746: -- canceling the termination, it removes the second row and updates the
1747: -- date_to (reverse Date-track change) of work_phone in per_phones table too.
1748: --
1749: -- delete from per_phones
1750: -- where parent_id = X_person_id
1751: -- and parent_table = 'PER_ALL_PEOPLE_F'
1745: -- per_all_people_f but not in per_phones table. Modified the code so that while
1746: -- canceling the termination, it removes the second row and updates the
1747: -- date_to (reverse Date-track change) of work_phone in per_phones table too.
1748: --
1749: -- delete from per_phones
1750: -- where parent_id = X_person_id
1751: -- and parent_table = 'PER_ALL_PEOPLE_F'
1752: -- and phone_type = 'W1'
1753: -- and date_from =X_s_termination_date + 1;
1751: -- and parent_table = 'PER_ALL_PEOPLE_F'
1752: -- and phone_type = 'W1'
1753: -- and date_from =X_s_termination_date + 1;
1754: --
1755: -- update per_phones
1756: -- set date_to = null
1757: -- where parent_id = X_person_id
1758: -- and parent_table = 'PER_ALL_PEOPLE_F'
1759: -- and phone_type = 'W1'
2117: ,per_rec.Sex
2118: ,per_rec.Title
2119: ,per_rec.Vendor_Id
2120: --
2121: -- 115.22: We need to ensure no rows get created in per_phones
2122: -- table.
2123: --
2124: ,null -- #1020074 per_rec.Work_Telephone
2125: ,per_rec.Attribute_Category