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.JTF_TASK_PARTY_MERGE_PKG dependencies on JTF_TASK_AUDITS_B

Line 106: -- Performs party ids merge in JTF_TASK_AUDITS_B table.

102: END TASK_MERGE_PARTY;
103:
104: ------------------------------------------------------------------------------------------
105: -- Procedure: TASK_AUDIT_MERGE_NEW_CUSTOMER
106: -- Performs party ids merge in JTF_TASK_AUDITS_B table.
107: -- Columns: NEW_CUSTOMER_ID
108: ------------------------------------------------------------------------------------------
109:
110:

Line 163: -- For JTF_TASK_AUDITS_B table, if party_id 1000 got merged to party_id 2000

159:
160:
161: -- If the parent has changed(ie. Parent is getting merged) then transfer the
162: -- dependent record to the new parent.
163: -- For JTF_TASK_AUDITS_B table, if party_id 1000 got merged to party_id 2000
164: -- then, we have to update all records with new_customer_id = 1000 to 2000
165:
166: if p_from_fk_id <> p_to_fk_id then
167:

Line 168: UPDATE jtf_task_audits_b

164: -- then, we have to update all records with new_customer_id = 1000 to 2000
165:
166: if p_from_fk_id <> p_to_fk_id then
167:
168: UPDATE jtf_task_audits_b
169: SET new_customer_id = p_to_fk_id,
170: last_update_date = hz_utility_pub.last_update_date,
171: last_updated_by = hz_utility_pub.user_id,
172: last_update_login = hz_utility_pub.last_update_login,

Line 190: -- Performs party ids merge in JTF_TASK_AUDITS_B table.

186: END TASK_AUDIT_MERGE_NEW_CUSTOMER;
187:
188: ------------------------------------------------------------------------------------------
189: -- Procedure: TASK_AUDIT_MERGE_OLD_CUSTOMER
190: -- Performs party ids merge in JTF_TASK_AUDITS_B table.
191: -- Columns: OLD_CUSTOMER_ID
192: ------------------------------------------------------------------------------------------
193:
194: PROCEDURE TASK_AUDIT_MERGE_OLD_CUSTOMER(

Line 246: -- For JTF_TASK_AUDITS_B table, if party_id 1000 got merged to party_id 2000

242:
243:
244: -- If the parent has changed(ie. Parent is getting merged) then transfer the
245: -- dependent record to the new parent.
246: -- For JTF_TASK_AUDITS_B table, if party_id 1000 got merged to party_id 2000
247: -- then, we have to update all records with old_customer_id = 1000 to 2000
248:
249: if p_from_fk_id <> p_to_fk_id then
250:

Line 251: UPDATE jtf_task_audits_b

247: -- then, we have to update all records with old_customer_id = 1000 to 2000
248:
249: if p_from_fk_id <> p_to_fk_id then
250:
251: UPDATE jtf_task_audits_b
252: SET old_customer_id = p_to_fk_id,
253: last_update_date = hz_utility_pub.last_update_date,
254: last_updated_by = hz_utility_pub.user_id,
255: last_update_login = hz_utility_pub.last_update_login,

Line 397: -- Performs party ids merge in JTF_TASK_AUDITS_B table.

393: END TASK_MERGE_SOURCE_OBJECT;
394:
395: ------------------------------------------------------------------------------------------
396: -- Procedure: TASK_AUDIT_MERGE_NEW_S_OBJECT
397: -- Performs party ids merge in JTF_TASK_AUDITS_B table.
398: -- Columns: NEW_SOURCE_OBJECT_ID , NEW_SOURCE_OBJECT_NAME
399: ------------------------------------------------------------------------------------------
400:
401: PROCEDURE TASK_AUDIT_MERGE_NEW_S_OBJECT(

Line 421: -- jtf_task_audits_b a

417:
418: --Cursor c_name Is
419: --select o.select_name
420: --from jtf_objects_vl o,
421: -- jtf_task_audits_b a
422: --where a.task_audit_id = p_from_id
423: --and a.new_source_object_type_code = o.object_code
424: --and nvl(start_date_active, sysdate) <= sysdate
425: --and nvl(end_date_active, sysdate) >= sysdate;

Line 470: -- For JTF_TASK_AUDITS_B table, if party_id 1000 got merged to party_id 2000

466:
467:
468: -- If the parent has changed(ie. Parent is getting merged) then transfer the
469: -- dependent record to the new parent.
470: -- For JTF_TASK_AUDITS_B table, if party_id 1000 got merged to party_id 2000
471: -- then, we have to update all records with new_source_object_id = 1000 to 2000
472: -- and also update the new_source_object_name where new_source_object_type_code = 'PARTY'
473:
474: open c_name;

Line 481: l_select_stat := 'UPDATE jtf_task_audits_b '

477:
478: if l_name is not NULL then
479: -- Modified by TSINGHAL for bug # 3138768 dt 17/sept/2003 start
480: -- Modified by SBARAT on 23/12/2005 for SQL Literal issue, bug# 4614088
481: l_select_stat := 'UPDATE jtf_task_audits_b '
482: || 'SET new_source_object_id = :1'
483: || ' , new_source_object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3)'
484: || ' , last_update_date = hz_utility_pub.last_update_date'
485: || ' , last_updated_by = hz_utility_pub.user_id'

Line 518: -- Performs party ids merge in JTF_TASK_AUDITS_B table.

514: END TASK_AUDIT_MERGE_NEW_S_OBJECT;
515:
516: ------------------------------------------------------------------------------------------
517: -- Procedure: TASK_AUDIT_MERGE_OLD_S_OBJECT
518: -- Performs party ids merge in JTF_TASK_AUDITS_B table.
519: -- Columns: OLD_SOURCE_OBJECT_ID , OLD_SOURCE_OBJECT_NAME
520: ------------------------------------------------------------------------------------------
521:
522: PROCEDURE TASK_AUDIT_MERGE_OLD_S_OBJECT(

Line 543: -- jtf_task_audits_b a

539:
540: --Cursor c_name Is
541: --select o.select_name
542: --from jtf_objects_vl o,
543: -- jtf_task_audits_b a
544: --where a.task_audit_id = p_from_id
545: --and a.old_source_object_type_code = o.object_code
546: --and nvl(start_date_active, sysdate) <= sysdate
547: --and nvl(end_date_active, sysdate) >= sysdate;

Line 592: -- For JTF_TASK_AUDITS_B table, if party_id 1000 got merged to party_id 2000

588:
589:
590: -- If the parent has changed(ie. Parent is getting merged) then transfer the
591: -- dependent record to the new parent.
592: -- For JTF_TASK_AUDITS_B table, if party_id 1000 got merged to party_id 2000
593: -- then, we have to update all records with old_source_object_id = 1000 to 2000
594: -- and also update the old_source_object_name where old_source_object_type_code = 'PARTY'
595:
596:

Line 604: l_select_stat := 'UPDATE jtf_task_audits_b'

600:
601: if l_name is not NULL then
602: -- Modified by TSINGHAL for bug # 3138768 dt 01/Oct/2003 Start
603: -- Modified by SBARAT on 23/12/2005 for SQL Literal issue, bug# 4614088
604: l_select_stat := 'UPDATE jtf_task_audits_b'
605: || ' SET old_source_object_id = :1'
606: || ' , old_source_object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3 )'
607: || ' , last_update_date = hz_utility_pub.last_update_date'
608: || ' , last_updated_by = hz_utility_pub.user_id'

Line 980: -- Performs party_site merge in JTF_TASK_AUDITS_B table.

976: END TASK_MERGE_ADDRESS;
977:
978: ------------------------------------------------------------------------------------------
979: -- Procedure: TASK_AUDIT_MERGE_NEW_ADDRESS
980: -- Performs party_site merge in JTF_TASK_AUDITS_B table.
981: -- Columns: NEW_ADDRESS_ID
982: ------------------------------------------------------------------------------------------
983:
984: PROCEDURE TASK_AUDIT_MERGE_NEW_ADDRESS(

Line 1037: -- For JTF_TASK_AUDITS_B table, if party_site_id 1111 got merged to party_site_id 2222

1033:
1034:
1035: -- If the parent has changed(ie. Parent is getting merged) then transfer the
1036: -- dependent record to the new parent.
1037: -- For JTF_TASK_AUDITS_B table, if party_site_id 1111 got merged to party_site_id 2222
1038: -- then, we have to update all records with new_address_id = 1111 to 2222
1039:
1040: if p_from_fk_id <> p_to_fk_id then
1041:

Line 1042: UPDATE jtf_task_audits_b

1038: -- then, we have to update all records with new_address_id = 1111 to 2222
1039:
1040: if p_from_fk_id <> p_to_fk_id then
1041:
1042: UPDATE jtf_task_audits_b
1043: SET new_address_id = p_to_fk_id,
1044: last_update_date = hz_utility_pub.last_update_date,
1045: last_updated_by = hz_utility_pub.user_id,
1046: last_update_login = hz_utility_pub.last_update_login,

Line 1065: -- Performs party_site merge in JTF_TASK_AUDITS_B table.

1061: END TASK_AUDIT_MERGE_NEW_ADDRESS;
1062:
1063: ------------------------------------------------------------------------------------------
1064: -- Procedure: TASK_AUDIT_MERGE_OLD_ADDRESS
1065: -- Performs party_site merge in JTF_TASK_AUDITS_B table.
1066: -- Columns: OLD_ADDRESS_ID
1067: ------------------------------------------------------------------------------------------
1068:
1069: PROCEDURE TASK_AUDIT_MERGE_OLD_ADDRESS(

Line 1122: -- For JTF_TASK_AUDITS_B table, if party_site_id 1111 got merged to party_site_id 2222

1118:
1119:
1120: -- If the parent has changed(ie. Parent is getting merged) then transfer the
1121: -- dependent record to the new parent.
1122: -- For JTF_TASK_AUDITS_B table, if party_site_id 1111 got merged to party_site_id 2222
1123: -- then, we have to update all records with old_address_id = 1111 to 2222
1124:
1125: if p_from_fk_id <> p_to_fk_id then
1126:

Line 1127: UPDATE jtf_task_audits_b

1123: -- then, we have to update all records with old_address_id = 1111 to 2222
1124:
1125: if p_from_fk_id <> p_to_fk_id then
1126:
1127: UPDATE jtf_task_audits_b
1128: SET old_address_id = p_to_fk_id,
1129: last_update_date = hz_utility_pub.last_update_date,
1130: last_updated_by = hz_utility_pub.user_id,
1131: last_update_login = hz_utility_pub.last_update_login,