[Home] [Help]
19: -- 23-DEC-05 sbarat Fixed SQL Literal issue for bug# 4614088
20: ---------------------------------------------------------------------------------
21: -- End of comments
22: ------------------------------------------------------------------------------------------
23: -- Procedure: TASK_MERGE_PARTY - Performs party ids merge in JTF_TASKS_B table.
24: -- Columns: CUSTOMER_ID
25: ------------------------------------------------------------------------------------------
26:
27: PROCEDURE TASK_MERGE_PARTY(
75:
76:
77: -- If the parent has changed(ie. Parent is getting merged) then transfer the
78: -- dependent record to the new parent.
79: -- For JTF_TASKS_B table, if party_id 1000 got merged to party_id 2000
80: -- then, we have to update all records with customer_id = 1000 to 2000
81:
82: if p_from_fk_id <> p_to_fk_id then
83:
80: -- then, we have to update all records with customer_id = 1000 to 2000
81:
82: if p_from_fk_id <> p_to_fk_id then
83:
84: UPDATE jtf_tasks_b
85: SET customer_id = p_to_fk_id,
86: last_update_date = hz_utility_pub.last_update_date,
87: last_updated_by = hz_utility_pub.user_id,
88: last_update_login = hz_utility_pub.last_update_login,
267:
268: END TASK_AUDIT_MERGE_OLD_CUSTOMER;
269:
270: ------------------------------------------------------------------------------------------
271: -- Procedure: TASK_MERGE_SOURCE_OBJECT - Performs party ids merge in JTF_TASKS_B table.
272: -- Columns: SOURCE_OBJECT_ID , SOURCE_OBJECT_NAME
273: ------------------------------------------------------------------------------------------
274:
275: PROCEDURE TASK_MERGE_SOURCE_OBJECT(
292:
293: --Cursor c_name Is
294: --select o.select_name
295: --from jtf_objects_vl o,
296: -- jtf_tasks_b t
297: --where t.task_id = p_from_id
298: --and t.source_object_type_code = o.object_code
299: --and nvl(start_date_active, sysdate) <= sysdate
300: --and nvl(end_date_active, sysdate) >= sysdate;
342:
343:
344: -- If the parent has changed(ie. Parent is getting merged) then transfer the
345: -- dependent record to the new parent.
346: -- For JTF_TASKS_B table, if party_id 1000 got merged to party_id 2000
347: -- then, we have to update all records with source_object_id = 1000 to 2000
348: -- and also update the source_object_name where source_object_type_code = 'PARTY'
349:
350: open c_name;
355:
356: -- Modified by TSINGHAL for bug # 3138768 dt 17/sept/2003 start
357: -- Modified by SBARAT on 23/12/2005 for SQL Literal issue, bug# 4614088
358: l_select_stat :=
359: 'UPDATE jtf_tasks_b'
360: || ' SET source_object_id = :1'
361: || ' , source_object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3)'
362: || ' , last_update_date = hz_utility_pub.last_update_date'
363: || ' , last_updated_by = hz_utility_pub.user_id'
891:
892:
893: ------------------------------------------------------------------------------------------
894: -- Procedure: TASK_MERGE_ADDRESS
895: -- Performs party_site merge in JTF_TASKS_B table.
896: -- Columns: ADDRESS_ID
897: ------------------------------------------------------------------------------------------
898:
899: PROCEDURE TASK_MERGE_ADDRESS(
948:
949:
950: -- If the parent has changed(ie. Parent is getting merged) then transfer the
951: -- dependent record to the new parent.
952: -- For JTF_TASKS_B table, if party_site_id 1111 got merged to party_site_id 2222
953: -- then, we have to update all records with address_id = 1111 to 2222
954:
955: if p_from_fk_id <> p_to_fk_id then
956:
953: -- then, we have to update all records with address_id = 1111 to 2222
954:
955: if p_from_fk_id <> p_to_fk_id then
956:
957: UPDATE jtf_tasks_b
958: SET address_id = p_to_fk_id,
959: last_update_date = hz_utility_pub.last_update_date,
960: last_updated_by = hz_utility_pub.user_id,
961: last_update_login = hz_utility_pub.last_update_login,