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 HZ_UTILITY_PUB

Line 86: last_update_date = hz_utility_pub.last_update_date,

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,
89: object_version_number = object_version_number + 1
90: WHERE customer_id = p_from_fk_id; -- just to make sure it is the right one

Line 87: last_updated_by = hz_utility_pub.user_id,

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,
89: object_version_number = object_version_number + 1
90: WHERE customer_id = p_from_fk_id; -- just to make sure it is the right one
91: end if;

Line 88: last_update_login = hz_utility_pub.last_update_login,

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,
89: object_version_number = object_version_number + 1
90: WHERE customer_id = p_from_fk_id; -- just to make sure it is the right one
91: end if;
92:

Line 170: last_update_date = hz_utility_pub.last_update_date,

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,
173: object_version_number = object_version_number + 1
174: WHERE new_customer_id = p_from_fk_id; -- just to make sure it is the right one

Line 171: last_updated_by = hz_utility_pub.user_id,

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,
173: object_version_number = object_version_number + 1
174: WHERE new_customer_id = p_from_fk_id; -- just to make sure it is the right one
175: end if;

Line 172: last_update_login = hz_utility_pub.last_update_login,

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,
173: object_version_number = object_version_number + 1
174: WHERE new_customer_id = p_from_fk_id; -- just to make sure it is the right one
175: end if;
176:

Line 253: last_update_date = hz_utility_pub.last_update_date,

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,
256: object_version_number = object_version_number + 1
257: WHERE old_customer_id = p_from_fk_id; -- just to make sure it is the right one

Line 254: last_updated_by = hz_utility_pub.user_id,

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,
256: object_version_number = object_version_number + 1
257: WHERE old_customer_id = p_from_fk_id; -- just to make sure it is the right one
258: end if;

Line 255: last_update_login = hz_utility_pub.last_update_login,

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,
256: object_version_number = object_version_number + 1
257: WHERE old_customer_id = p_from_fk_id; -- just to make sure it is the right one
258: end if;
259:

Line 362: || ' , last_update_date = hz_utility_pub.last_update_date'

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'
364: || ' , last_update_login = hz_utility_pub.last_update_login'
365: || ' , object_version_number = object_version_number + 1'
366: || ' WHERE source_object_id = :4'

Line 363: || ' , last_updated_by = hz_utility_pub.user_id'

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'
364: || ' , last_update_login = hz_utility_pub.last_update_login'
365: || ' , object_version_number = object_version_number + 1'
366: || ' WHERE source_object_id = :4'
367: || ' AND source_object_type_code = ''PARTY''';

Line 364: || ' , last_update_login = hz_utility_pub.last_update_login'

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'
364: || ' , last_update_login = hz_utility_pub.last_update_login'
365: || ' , object_version_number = object_version_number + 1'
366: || ' WHERE source_object_id = :4'
367: || ' AND source_object_type_code = ''PARTY''';
368:

Line 484: || ' , last_update_date = hz_utility_pub.last_update_date'

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'
486: || ' , last_update_login = hz_utility_pub.last_update_login'
487: || ' , object_version_number = object_version_number + 1'
488: || ' WHERE new_source_object_id = :4'

Line 485: || ' , last_updated_by = hz_utility_pub.user_id'

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'
486: || ' , last_update_login = hz_utility_pub.last_update_login'
487: || ' , object_version_number = object_version_number + 1'
488: || ' WHERE new_source_object_id = :4'
489: || ' AND new_source_object_type_code = ''PARTY''';

Line 486: || ' , last_update_login = hz_utility_pub.last_update_login'

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'
486: || ' , last_update_login = hz_utility_pub.last_update_login'
487: || ' , object_version_number = object_version_number + 1'
488: || ' WHERE new_source_object_id = :4'
489: || ' AND new_source_object_type_code = ''PARTY''';
490: end if;

Line 607: || ' , last_update_date = hz_utility_pub.last_update_date'

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'
609: || ' , last_update_login = hz_utility_pub.last_update_login'
610: || ' , object_version_number = object_version_number + 1'
611: || ' WHERE old_source_object_id = :4'

Line 608: || ' , last_updated_by = hz_utility_pub.user_id'

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'
609: || ' , last_update_login = hz_utility_pub.last_update_login'
610: || ' , object_version_number = object_version_number + 1'
611: || ' WHERE old_source_object_id = :4'
612: || ' AND old_source_object_type_code = ''PARTY''';

Line 609: || ' , last_update_login = hz_utility_pub.last_update_login'

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'
609: || ' , last_update_login = hz_utility_pub.last_update_login'
610: || ' , object_version_number = object_version_number + 1'
611: || ' WHERE old_source_object_id = :4'
612: || ' AND old_source_object_type_code = ''PARTY''';
613: -- Modified by TSINGHAL for bug # 3138768 dt 01/Oct/2003 End

Line 733: || ' , last_update_date = hz_utility_pub.last_update_date'

729: -- Modified by SBARAT on 23/12/2005 for SQL Literal issue, bug# 4614088
730: l_select_stat := 'UPDATE jtf_task_references_b'
731: || ' SET object_id = :1'
732: || ' , object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3 )'
733: || ' , last_update_date = hz_utility_pub.last_update_date'
734: || ' , last_updated_by = hz_utility_pub.user_id'
735: || ' , last_update_login = hz_utility_pub.last_update_login'
736: || ' , object_version_number = object_version_number + 1'
737: || ' WHERE object_id = :4'

Line 734: || ' , last_updated_by = hz_utility_pub.user_id'

730: l_select_stat := 'UPDATE jtf_task_references_b'
731: || ' SET object_id = :1'
732: || ' , object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3 )'
733: || ' , last_update_date = hz_utility_pub.last_update_date'
734: || ' , last_updated_by = hz_utility_pub.user_id'
735: || ' , last_update_login = hz_utility_pub.last_update_login'
736: || ' , object_version_number = object_version_number + 1'
737: || ' WHERE object_id = :4'
738: || ' AND object_type_code = ''PARTY''';

Line 735: || ' , last_update_login = hz_utility_pub.last_update_login'

731: || ' SET object_id = :1'
732: || ' , object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3 )'
733: || ' , last_update_date = hz_utility_pub.last_update_date'
734: || ' , last_updated_by = hz_utility_pub.user_id'
735: || ' , last_update_login = hz_utility_pub.last_update_login'
736: || ' , object_version_number = object_version_number + 1'
737: || ' WHERE object_id = :4'
738: || ' AND object_type_code = ''PARTY''';
739: end if;

Line 860: || ' , last_update_date = hz_utility_pub.last_update_date'

856: -- Modified by SBARAT on 23/12/2005 for SQL Literal issue, bug# 4614088
857: l_select_stat := 'UPDATE jtf_task_references_b'
858: || ' SET object_id = :1'
859: || ' , object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_party_sites WHERE party_site_id = :3 )'
860: || ' , last_update_date = hz_utility_pub.last_update_date'
861: || ' , last_updated_by = hz_utility_pub.user_id'
862: || ' , last_update_login = hz_utility_pub.last_update_login'
863: || ' , object_version_number = object_version_number + 1'
864: || ' WHERE object_id = :4'

Line 861: || ' , last_updated_by = hz_utility_pub.user_id'

857: l_select_stat := 'UPDATE jtf_task_references_b'
858: || ' SET object_id = :1'
859: || ' , object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_party_sites WHERE party_site_id = :3 )'
860: || ' , last_update_date = hz_utility_pub.last_update_date'
861: || ' , last_updated_by = hz_utility_pub.user_id'
862: || ' , last_update_login = hz_utility_pub.last_update_login'
863: || ' , object_version_number = object_version_number + 1'
864: || ' WHERE object_id = :4'
865: || ' AND object_type_code = ''SITE''';

Line 862: || ' , last_update_login = hz_utility_pub.last_update_login'

858: || ' SET object_id = :1'
859: || ' , object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_party_sites WHERE party_site_id = :3 )'
860: || ' , last_update_date = hz_utility_pub.last_update_date'
861: || ' , last_updated_by = hz_utility_pub.user_id'
862: || ' , last_update_login = hz_utility_pub.last_update_login'
863: || ' , object_version_number = object_version_number + 1'
864: || ' WHERE object_id = :4'
865: || ' AND object_type_code = ''SITE''';
866: end if;

Line 959: last_update_date = hz_utility_pub.last_update_date,

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,
962: object_version_number = object_version_number + 1
963: WHERE --task_id = p_from_id

Line 960: last_updated_by = hz_utility_pub.user_id,

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,
962: object_version_number = object_version_number + 1
963: WHERE --task_id = p_from_id
964: --AND

Line 961: last_update_login = hz_utility_pub.last_update_login,

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,
962: object_version_number = object_version_number + 1
963: WHERE --task_id = p_from_id
964: --AND
965: address_id = p_from_fk_id; -- just to make sure it is the right one

Line 1044: last_update_date = hz_utility_pub.last_update_date,

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,
1047: object_version_number = object_version_number + 1
1048: WHERE --task_audit_id = p_from_id

Line 1045: last_updated_by = hz_utility_pub.user_id,

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,
1047: object_version_number = object_version_number + 1
1048: WHERE --task_audit_id = p_from_id
1049: --AND

Line 1046: last_update_login = hz_utility_pub.last_update_login,

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,
1047: object_version_number = object_version_number + 1
1048: WHERE --task_audit_id = p_from_id
1049: --AND
1050: new_address_id = p_from_fk_id; -- just to make sure it is the right one

Line 1129: last_update_date = hz_utility_pub.last_update_date,

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,
1132: object_version_number = object_version_number + 1
1133: WHERE --task_audit_id = p_from_id

Line 1130: last_updated_by = hz_utility_pub.user_id,

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,
1132: object_version_number = object_version_number + 1
1133: WHERE --task_audit_id = p_from_id
1134: --AND

Line 1131: last_update_login = hz_utility_pub.last_update_login,

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,
1132: object_version_number = object_version_number + 1
1133: WHERE --task_audit_id = p_from_id
1134: --AND
1135: old_address_id = p_from_fk_id; -- just to make sure it is the right one

Line 1213: last_update_date = hz_utility_pub.last_update_date,

1209: if p_from_fk_id <> p_to_fk_id then
1210:
1211: UPDATE jtf_task_contacts
1212: SET contact_id = p_to_fk_id,
1213: last_update_date = hz_utility_pub.last_update_date,
1214: last_updated_by = hz_utility_pub.user_id,
1215: last_update_login = hz_utility_pub.last_update_login,
1216: object_version_number = object_version_number + 1
1217: WHERE --task_contact_id = p_from_id

Line 1214: last_updated_by = hz_utility_pub.user_id,

1210:
1211: UPDATE jtf_task_contacts
1212: SET contact_id = p_to_fk_id,
1213: last_update_date = hz_utility_pub.last_update_date,
1214: last_updated_by = hz_utility_pub.user_id,
1215: last_update_login = hz_utility_pub.last_update_login,
1216: object_version_number = object_version_number + 1
1217: WHERE --task_contact_id = p_from_id
1218: contact_type_code = 'CUST'

Line 1215: last_update_login = hz_utility_pub.last_update_login,

1211: UPDATE jtf_task_contacts
1212: SET contact_id = p_to_fk_id,
1213: last_update_date = hz_utility_pub.last_update_date,
1214: last_updated_by = hz_utility_pub.user_id,
1215: last_update_login = hz_utility_pub.last_update_login,
1216: object_version_number = object_version_number + 1
1217: WHERE --task_contact_id = p_from_id
1218: contact_type_code = 'CUST'
1219: AND contact_id = p_from_fk_id; --just to make sure it is the right one

Line 1298: last_update_date = hz_utility_pub.last_update_date,

1294: if p_from_fk_id <> p_to_fk_id then
1295:
1296: UPDATE jtf_task_phones
1297: SET phone_id = p_to_fk_id,
1298: last_update_date = hz_utility_pub.last_update_date,
1299: last_updated_by = hz_utility_pub.user_id,
1300: last_update_login = hz_utility_pub.last_update_login,
1301: object_version_number = object_version_number + 1
1302: WHERE --task_phone_id = p_from_id

Line 1299: last_updated_by = hz_utility_pub.user_id,

1295:
1296: UPDATE jtf_task_phones
1297: SET phone_id = p_to_fk_id,
1298: last_update_date = hz_utility_pub.last_update_date,
1299: last_updated_by = hz_utility_pub.user_id,
1300: last_update_login = hz_utility_pub.last_update_login,
1301: object_version_number = object_version_number + 1
1302: WHERE --task_phone_id = p_from_id
1303: --AND

Line 1300: last_update_login = hz_utility_pub.last_update_login,

1296: UPDATE jtf_task_phones
1297: SET phone_id = p_to_fk_id,
1298: last_update_date = hz_utility_pub.last_update_date,
1299: last_updated_by = hz_utility_pub.user_id,
1300: last_update_login = hz_utility_pub.last_update_login,
1301: object_version_number = object_version_number + 1
1302: WHERE --task_phone_id = p_from_id
1303: --AND
1304: phone_id = p_from_fk_id; --just to make sure it is the right one

Line 1420: last_update_date = hz_utility_pub.last_update_date,

1416:
1417: UPDATE jtf_perz_query_param
1418: -- Fix bug 3738509
1419: SET parameter_value = l_customer_new_number,
1420: last_update_date = hz_utility_pub.last_update_date,
1421: last_updated_by = hz_utility_pub.user_id,
1422: last_update_login = hz_utility_pub.last_update_login
1423: WHERE --query_param_id = l_query_customer_name_id
1424: query_param_id IN (SELECT param.query_param_id

Line 1421: last_updated_by = hz_utility_pub.user_id,

1417: UPDATE jtf_perz_query_param
1418: -- Fix bug 3738509
1419: SET parameter_value = l_customer_new_number,
1420: last_update_date = hz_utility_pub.last_update_date,
1421: last_updated_by = hz_utility_pub.user_id,
1422: last_update_login = hz_utility_pub.last_update_login
1423: WHERE --query_param_id = l_query_customer_name_id
1424: query_param_id IN (SELECT param.query_param_id
1425: FROM jtf_perz_query_param param

Line 1422: last_update_login = hz_utility_pub.last_update_login

1418: -- Fix bug 3738509
1419: SET parameter_value = l_customer_new_number,
1420: last_update_date = hz_utility_pub.last_update_date,
1421: last_updated_by = hz_utility_pub.user_id,
1422: last_update_login = hz_utility_pub.last_update_login
1423: WHERE --query_param_id = l_query_customer_name_id
1424: query_param_id IN (SELECT param.query_param_id
1425: FROM jtf_perz_query_param param
1426: , (SELECT q.query_id

Line 1447: last_update_date = hz_utility_pub.last_update_date,

1443: end if;
1444:
1445: UPDATE jtf_perz_query_param p
1446: SET parameter_value = to_char(p_to_fk_id),
1447: last_update_date = hz_utility_pub.last_update_date,
1448: last_updated_by = hz_utility_pub.user_id,
1449: last_update_login = hz_utility_pub.last_update_login
1450: WHERE --query_param_id = p_from_id
1451: query_param_id IN (SELECT param.query_param_id

Line 1448: last_updated_by = hz_utility_pub.user_id,

1444:
1445: UPDATE jtf_perz_query_param p
1446: SET parameter_value = to_char(p_to_fk_id),
1447: last_update_date = hz_utility_pub.last_update_date,
1448: last_updated_by = hz_utility_pub.user_id,
1449: last_update_login = hz_utility_pub.last_update_login
1450: WHERE --query_param_id = p_from_id
1451: query_param_id IN (SELECT param.query_param_id
1452: FROM jtf_perz_query_param param

Line 1449: last_update_login = hz_utility_pub.last_update_login

1445: UPDATE jtf_perz_query_param p
1446: SET parameter_value = to_char(p_to_fk_id),
1447: last_update_date = hz_utility_pub.last_update_date,
1448: last_updated_by = hz_utility_pub.user_id,
1449: last_update_login = hz_utility_pub.last_update_login
1450: WHERE --query_param_id = p_from_id
1451: query_param_id IN (SELECT param.query_param_id
1452: FROM jtf_perz_query_param param
1453: , (SELECT q.query_id

Line 1573: -- last_update_date = hz_utility_pub.last_update_date,

1569: close get_new_customer_name;
1570:
1571: -- UPDATE jtf_perz_query_param
1572: -- SET parameter_value = to_char(p_to_fk_id),
1573: -- last_update_date = hz_utility_pub.last_update_date,
1574: -- last_updated_by = hz_utility_pub.user_id,
1575: -- last_update_login = hz_utility_pub.last_update_login
1576: -- WHERE query_param_id = p_from_id
1577: -- AND parameter_value = to_char(p_from_fk_id);

Line 1574: -- last_updated_by = hz_utility_pub.user_id,

1570:
1571: -- UPDATE jtf_perz_query_param
1572: -- SET parameter_value = to_char(p_to_fk_id),
1573: -- last_update_date = hz_utility_pub.last_update_date,
1574: -- last_updated_by = hz_utility_pub.user_id,
1575: -- last_update_login = hz_utility_pub.last_update_login
1576: -- WHERE query_param_id = p_from_id
1577: -- AND parameter_value = to_char(p_from_fk_id);
1578:

Line 1575: -- last_update_login = hz_utility_pub.last_update_login

1571: -- UPDATE jtf_perz_query_param
1572: -- SET parameter_value = to_char(p_to_fk_id),
1573: -- last_update_date = hz_utility_pub.last_update_date,
1574: -- last_updated_by = hz_utility_pub.user_id,
1575: -- last_update_login = hz_utility_pub.last_update_login
1576: -- WHERE query_param_id = p_from_id
1577: -- AND parameter_value = to_char(p_from_fk_id);
1578:
1579:

Line 1588: -- last_update_date = hz_utility_pub.last_update_date,

1584: then
1585:
1586: -- UPDATE jtf_perz_query_param
1587: -- SET parameter_value = l_customer_new_name,
1588: -- last_update_date = hz_utility_pub.last_update_date,
1589: -- last_updated_by = hz_utility_pub.user_id,
1590: -- last_update_login = hz_utility_pub.last_update_login
1591: -- WHERE query_param_id = l_query_customer_name_id;
1592:

Line 1589: -- last_updated_by = hz_utility_pub.user_id,

1585:
1586: -- UPDATE jtf_perz_query_param
1587: -- SET parameter_value = l_customer_new_name,
1588: -- last_update_date = hz_utility_pub.last_update_date,
1589: -- last_updated_by = hz_utility_pub.user_id,
1590: -- last_update_login = hz_utility_pub.last_update_login
1591: -- WHERE query_param_id = l_query_customer_name_id;
1592:
1593: -- end if;

Line 1590: -- last_update_login = hz_utility_pub.last_update_login

1586: -- UPDATE jtf_perz_query_param
1587: -- SET parameter_value = l_customer_new_name,
1588: -- last_update_date = hz_utility_pub.last_update_date,
1589: -- last_updated_by = hz_utility_pub.user_id,
1590: -- last_update_login = hz_utility_pub.last_update_login
1591: -- WHERE query_param_id = l_query_customer_name_id;
1592:
1593: -- end if;
1594:

Line 1597: last_update_date = hz_utility_pub.last_update_date,

1593: -- end if;
1594:
1595: UPDATE jtf_perz_query_param
1596: SET parameter_value = l_customer_new_name,
1597: last_update_date = hz_utility_pub.last_update_date,
1598: last_updated_by = hz_utility_pub.user_id,
1599: last_update_login = hz_utility_pub.last_update_login
1600: WHERE --query_param_id = l_query_customer_name_id
1601: query_param_id IN (SELECT param.query_param_id

Line 1598: last_updated_by = hz_utility_pub.user_id,

1594:
1595: UPDATE jtf_perz_query_param
1596: SET parameter_value = l_customer_new_name,
1597: last_update_date = hz_utility_pub.last_update_date,
1598: last_updated_by = hz_utility_pub.user_id,
1599: last_update_login = hz_utility_pub.last_update_login
1600: WHERE --query_param_id = l_query_customer_name_id
1601: query_param_id IN (SELECT param.query_param_id
1602: FROM jtf_perz_query_param param

Line 1599: last_update_login = hz_utility_pub.last_update_login

1595: UPDATE jtf_perz_query_param
1596: SET parameter_value = l_customer_new_name,
1597: last_update_date = hz_utility_pub.last_update_date,
1598: last_updated_by = hz_utility_pub.user_id,
1599: last_update_login = hz_utility_pub.last_update_login
1600: WHERE --query_param_id = l_query_customer_name_id
1601: query_param_id IN (SELECT param.query_param_id
1602: FROM jtf_perz_query_param param
1603: , (SELECT q.query_id

Line 1624: last_update_date = hz_utility_pub.last_update_date,

1620: end if;
1621:
1622: UPDATE jtf_perz_query_param p
1623: SET parameter_value = to_char(p_to_fk_id),
1624: last_update_date = hz_utility_pub.last_update_date,
1625: last_updated_by = hz_utility_pub.user_id,
1626: last_update_login = hz_utility_pub.last_update_login
1627: WHERE --query_param_id = p_from_id
1628: query_param_id IN (SELECT param.query_param_id

Line 1625: last_updated_by = hz_utility_pub.user_id,

1621:
1622: UPDATE jtf_perz_query_param p
1623: SET parameter_value = to_char(p_to_fk_id),
1624: last_update_date = hz_utility_pub.last_update_date,
1625: last_updated_by = hz_utility_pub.user_id,
1626: last_update_login = hz_utility_pub.last_update_login
1627: WHERE --query_param_id = p_from_id
1628: query_param_id IN (SELECT param.query_param_id
1629: FROM jtf_perz_query_param param

Line 1626: last_update_login = hz_utility_pub.last_update_login

1622: UPDATE jtf_perz_query_param p
1623: SET parameter_value = to_char(p_to_fk_id),
1624: last_update_date = hz_utility_pub.last_update_date,
1625: last_updated_by = hz_utility_pub.user_id,
1626: last_update_login = hz_utility_pub.last_update_login
1627: WHERE --query_param_id = p_from_id
1628: query_param_id IN (SELECT param.query_param_id
1629: FROM jtf_perz_query_param param
1630: , (SELECT q.query_id

Line 1725: last_update_date = hz_utility_pub.last_update_date,

1721: if p_from_fk_id <> p_to_fk_id then
1722:
1723: UPDATE jtf_task_assignments
1724: SET resource_id = p_to_fk_id,
1725: last_update_date = hz_utility_pub.last_update_date,
1726: last_updated_by = hz_utility_pub.user_id,
1727: last_update_login = hz_utility_pub.last_update_login,
1728: object_version_number = object_version_number + 1
1729: WHERE resource_id = p_from_fk_id

Line 1726: last_updated_by = hz_utility_pub.user_id,

1722:
1723: UPDATE jtf_task_assignments
1724: SET resource_id = p_to_fk_id,
1725: last_update_date = hz_utility_pub.last_update_date,
1726: last_updated_by = hz_utility_pub.user_id,
1727: last_update_login = hz_utility_pub.last_update_login,
1728: object_version_number = object_version_number + 1
1729: WHERE resource_id = p_from_fk_id
1730: AND resource_type_code IN (SELECT object_code

Line 1727: last_update_login = hz_utility_pub.last_update_login,

1723: UPDATE jtf_task_assignments
1724: SET resource_id = p_to_fk_id,
1725: last_update_date = hz_utility_pub.last_update_date,
1726: last_updated_by = hz_utility_pub.user_id,
1727: last_update_login = hz_utility_pub.last_update_login,
1728: object_version_number = object_version_number + 1
1729: WHERE resource_id = p_from_fk_id
1730: AND resource_type_code IN (SELECT object_code
1731: FROM jtf_objects_b