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.HZ_PARTY_MERGE dependencies on HZ_UTILITY_PUB

Line 225: g_request_id :=hz_utility_pub.request_id;

221: --4534175
222: l_count1 number;
223: BEGIN
224:
225: g_request_id :=hz_utility_pub.request_id;
226: g_created_by :=hz_utility_pub.created_by;
227: g_creation_date :=hz_utility_pub.creation_date;
228: g_last_update_login:=hz_utility_pub.last_update_login;
229: g_last_update_date :=hz_utility_pub.last_update_date;

Line 226: g_created_by :=hz_utility_pub.created_by;

222: l_count1 number;
223: BEGIN
224:
225: g_request_id :=hz_utility_pub.request_id;
226: g_created_by :=hz_utility_pub.created_by;
227: g_creation_date :=hz_utility_pub.creation_date;
228: g_last_update_login:=hz_utility_pub.last_update_login;
229: g_last_update_date :=hz_utility_pub.last_update_date;
230: g_user_id :=hz_utility_pub.user_id;

Line 227: g_creation_date :=hz_utility_pub.creation_date;

223: BEGIN
224:
225: g_request_id :=hz_utility_pub.request_id;
226: g_created_by :=hz_utility_pub.created_by;
227: g_creation_date :=hz_utility_pub.creation_date;
228: g_last_update_login:=hz_utility_pub.last_update_login;
229: g_last_update_date :=hz_utility_pub.last_update_date;
230: g_user_id :=hz_utility_pub.user_id;
231:

Line 228: g_last_update_login:=hz_utility_pub.last_update_login;

224:
225: g_request_id :=hz_utility_pub.request_id;
226: g_created_by :=hz_utility_pub.created_by;
227: g_creation_date :=hz_utility_pub.creation_date;
228: g_last_update_login:=hz_utility_pub.last_update_login;
229: g_last_update_date :=hz_utility_pub.last_update_date;
230: g_user_id :=hz_utility_pub.user_id;
231:
232: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_id||'#');

Line 229: g_last_update_date :=hz_utility_pub.last_update_date;

225: g_request_id :=hz_utility_pub.request_id;
226: g_created_by :=hz_utility_pub.created_by;
227: g_creation_date :=hz_utility_pub.creation_date;
228: g_last_update_login:=hz_utility_pub.last_update_login;
229: g_last_update_date :=hz_utility_pub.last_update_date;
230: g_user_id :=hz_utility_pub.user_id;
231:
232: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_id||'#');
233: FND_FILE.put_line(FND_FILE.log,'User ID:'||g_user_id||'#');

Line 230: g_user_id :=hz_utility_pub.user_id;

226: g_created_by :=hz_utility_pub.created_by;
227: g_creation_date :=hz_utility_pub.creation_date;
228: g_last_update_login:=hz_utility_pub.last_update_login;
229: g_last_update_date :=hz_utility_pub.last_update_date;
230: g_user_id :=hz_utility_pub.user_id;
231:
232: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_id||'#');
233: FND_FILE.put_line(FND_FILE.log,'User ID:'||g_user_id||'#');
234: FND_FILE.put_line(FND_FILE.log,'Creation Date:'||TO_CHAR(g_creation_date)||'#');

Line 652: SET REQUEST_ID = hz_utility_pub.request_id

648:
649:
650: -- Stamp concurrent request id to batch
651: UPDATE HZ_MERGE_BATCH
652: SET REQUEST_ID = hz_utility_pub.request_id
653: WHERE batch_id = p_batch_id;
654:
655: -- If not preview mode update batch status to COMPLETE
656: IF p_preview <> 'Y' then

Line 1149: HZ_BES_BO_UTIL_PKG.upd_entity_ids(hz_utility_pub.request_id);

1145:
1146:
1147: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED','BO_EVENTS_ENABLED')) THEN
1148:
1149: HZ_BES_BO_UTIL_PKG.upd_entity_ids(hz_utility_pub.request_id);
1150:
1151: END IF;
1152:
1153: -- Check if the whole batch was successfully executed

Line 2247: AND h.request_id = hz_utility_pub.request_id

2243: SELECT h.from_entity_id, d.entity_name, d.pk_column_name
2244: FROM HZ_MERGE_PARTY_HISTORY h, HZ_MERGE_DICTIONARY d
2245: WHERE h.merge_dict_id = d.merge_dict_id
2246: AND h.batch_party_id = p_batch_party_id
2247: AND h.request_id = hz_utility_pub.request_id
2248: AND h.operation_type = 'Merge'
2249: ORDER BY h.merge_dict_id desc;
2250:
2251: l_record_id HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_ID%TYPE;

Line 2658: g_request_id, -- Bug No : 2998004 hz_utility_pub.request_id,

2654: last_update_date,
2655: last_updated_by)
2656: VALUES (
2657: H_batch_party_id(I),
2658: g_request_id, -- Bug No : 2998004 hz_utility_pub.request_id,
2659: H_from_id(I),
2660: H_to_id(I),
2661: H_from_fk_id(I),
2662: H_to_fk_id(I),

Line 2667: g_created_by, -- hz_utility_pub.created_by,

2663: H_from_desc(I),
2664: H_to_desc(I),
2665: H_merge_dict_id(I),
2666: H_op_type(I),
2667: g_created_by, -- hz_utility_pub.created_by,
2668: g_creation_date, -- hz_utility_pub.creation_date,
2669: g_last_update_login, -- hz_utility_pub.last_update_login,
2670: g_last_update_date, -- hz_utility_pub.last_update_date,
2671: g_user_id -- hz_utility_pub.user_id

Line 2668: g_creation_date, -- hz_utility_pub.creation_date,

2664: H_to_desc(I),
2665: H_merge_dict_id(I),
2666: H_op_type(I),
2667: g_created_by, -- hz_utility_pub.created_by,
2668: g_creation_date, -- hz_utility_pub.creation_date,
2669: g_last_update_login, -- hz_utility_pub.last_update_login,
2670: g_last_update_date, -- hz_utility_pub.last_update_date,
2671: g_user_id -- hz_utility_pub.user_id
2672: );

Line 2669: g_last_update_login, -- hz_utility_pub.last_update_login,

2665: H_merge_dict_id(I),
2666: H_op_type(I),
2667: g_created_by, -- hz_utility_pub.created_by,
2668: g_creation_date, -- hz_utility_pub.creation_date,
2669: g_last_update_login, -- hz_utility_pub.last_update_login,
2670: g_last_update_date, -- hz_utility_pub.last_update_date,
2671: g_user_id -- hz_utility_pub.user_id
2672: );
2673: H_Counter := 0;

Line 2670: g_last_update_date, -- hz_utility_pub.last_update_date,

2666: H_op_type(I),
2667: g_created_by, -- hz_utility_pub.created_by,
2668: g_creation_date, -- hz_utility_pub.creation_date,
2669: g_last_update_login, -- hz_utility_pub.last_update_login,
2670: g_last_update_date, -- hz_utility_pub.last_update_date,
2671: g_user_id -- hz_utility_pub.user_id
2672: );
2673: H_Counter := 0;
2674: END IF;

Line 2671: g_user_id -- hz_utility_pub.user_id

2667: g_created_by, -- hz_utility_pub.created_by,
2668: g_creation_date, -- hz_utility_pub.creation_date,
2669: g_last_update_login, -- hz_utility_pub.last_update_login,
2670: g_last_update_date, -- hz_utility_pub.last_update_date,
2671: g_user_id -- hz_utility_pub.user_id
2672: );
2673: H_Counter := 0;
2674: END IF;
2675: IF p_flush = 'Y' THEN

Line 2758: g_request_id, -- Bug No : 2998004 hz_utility_pub.request_id,

2754: last_update_date,
2755: last_updated_by)
2756: VALUES (
2757: I_batch_party_id(I),
2758: g_request_id, -- Bug No : 2998004 hz_utility_pub.request_id,
2759: I_from_id(I),
2760: I_to_id(I),
2761: I_from_fk_id(I),
2762: I_to_fk_id(I),

Line 2768: g_created_by, -- hz_utility_pub.created_by,

2764: I_to_desc(I),
2765: I_merge_dict_id(I),
2766: I_error(I),
2767: I_op_type(I),
2768: g_created_by, -- hz_utility_pub.created_by,
2769: g_creation_date, -- hz_utility_pub.creation_date,
2770: g_last_update_login, -- hz_utility_pub.last_update_login,
2771: g_last_update_date, -- hz_utility_pub.last_update_date,
2772: g_user_id -- hz_utility_pub.user_id

Line 2769: g_creation_date, -- hz_utility_pub.creation_date,

2765: I_merge_dict_id(I),
2766: I_error(I),
2767: I_op_type(I),
2768: g_created_by, -- hz_utility_pub.created_by,
2769: g_creation_date, -- hz_utility_pub.creation_date,
2770: g_last_update_login, -- hz_utility_pub.last_update_login,
2771: g_last_update_date, -- hz_utility_pub.last_update_date,
2772: g_user_id -- hz_utility_pub.user_id
2773: );

Line 2770: g_last_update_login, -- hz_utility_pub.last_update_login,

2766: I_error(I),
2767: I_op_type(I),
2768: g_created_by, -- hz_utility_pub.created_by,
2769: g_creation_date, -- hz_utility_pub.creation_date,
2770: g_last_update_login, -- hz_utility_pub.last_update_login,
2771: g_last_update_date, -- hz_utility_pub.last_update_date,
2772: g_user_id -- hz_utility_pub.user_id
2773: );
2774:

Line 2771: g_last_update_date, -- hz_utility_pub.last_update_date,

2767: I_op_type(I),
2768: g_created_by, -- hz_utility_pub.created_by,
2769: g_creation_date, -- hz_utility_pub.creation_date,
2770: g_last_update_login, -- hz_utility_pub.last_update_login,
2771: g_last_update_date, -- hz_utility_pub.last_update_date,
2772: g_user_id -- hz_utility_pub.user_id
2773: );
2774:
2775: I_Counter := 0;

Line 2772: g_user_id -- hz_utility_pub.user_id

2768: g_created_by, -- hz_utility_pub.created_by,
2769: g_creation_date, -- hz_utility_pub.creation_date,
2770: g_last_update_login, -- hz_utility_pub.last_update_login,
2771: g_last_update_date, -- hz_utility_pub.last_update_date,
2772: g_user_id -- hz_utility_pub.user_id
2773: );
2774:
2775: I_Counter := 0;
2776: -- Commit the log entry

Line 3027: last_update_date = hz_utility_pub.last_update_date,

3023: --the hz_merge_pkg.do_party_site_merge sets it to 'M' in pre-merge
3024: UPDATE HZ_PARTY_SITES
3025: SET
3026: STATUS = 'A',
3027: last_update_date = hz_utility_pub.last_update_date,
3028: last_updated_by = hz_utility_pub.user_id,
3029: last_update_login = hz_utility_pub.last_update_login,
3030: request_id = hz_utility_pub.request_id,
3031: program_application_id = hz_utility_pub.program_application_id,

Line 3028: last_updated_by = hz_utility_pub.user_id,

3024: UPDATE HZ_PARTY_SITES
3025: SET
3026: STATUS = 'A',
3027: last_update_date = hz_utility_pub.last_update_date,
3028: last_updated_by = hz_utility_pub.user_id,
3029: last_update_login = hz_utility_pub.last_update_login,
3030: request_id = hz_utility_pub.request_id,
3031: program_application_id = hz_utility_pub.program_application_id,
3032: program_id = hz_utility_pub.program_id,

Line 3029: last_update_login = hz_utility_pub.last_update_login,

3025: SET
3026: STATUS = 'A',
3027: last_update_date = hz_utility_pub.last_update_date,
3028: last_updated_by = hz_utility_pub.user_id,
3029: last_update_login = hz_utility_pub.last_update_login,
3030: request_id = hz_utility_pub.request_id,
3031: program_application_id = hz_utility_pub.program_application_id,
3032: program_id = hz_utility_pub.program_id,
3033: program_update_date = sysdate

Line 3030: request_id = hz_utility_pub.request_id,

3026: STATUS = 'A',
3027: last_update_date = hz_utility_pub.last_update_date,
3028: last_updated_by = hz_utility_pub.user_id,
3029: last_update_login = hz_utility_pub.last_update_login,
3030: request_id = hz_utility_pub.request_id,
3031: program_application_id = hz_utility_pub.program_application_id,
3032: program_id = hz_utility_pub.program_id,
3033: program_update_date = sysdate
3034: WHERE party_site_id = l_merge_to_entity_id;

Line 3031: program_application_id = hz_utility_pub.program_application_id,

3027: last_update_date = hz_utility_pub.last_update_date,
3028: last_updated_by = hz_utility_pub.user_id,
3029: last_update_login = hz_utility_pub.last_update_login,
3030: request_id = hz_utility_pub.request_id,
3031: program_application_id = hz_utility_pub.program_application_id,
3032: program_id = hz_utility_pub.program_id,
3033: program_update_date = sysdate
3034: WHERE party_site_id = l_merge_to_entity_id;
3035:

Line 3032: program_id = hz_utility_pub.program_id,

3028: last_updated_by = hz_utility_pub.user_id,
3029: last_update_login = hz_utility_pub.last_update_login,
3030: request_id = hz_utility_pub.request_id,
3031: program_application_id = hz_utility_pub.program_application_id,
3032: program_id = hz_utility_pub.program_id,
3033: program_update_date = sysdate
3034: WHERE party_site_id = l_merge_to_entity_id;
3035:
3036:

Line 3589: hz_utility_pub.created_by,

3585: 'HZ_ORGANIZATION_PROFILES',
3586: l_from_profile_id,
3587: l_to_profile_id,
3588: 'Y',
3589: hz_utility_pub.created_by,
3590: hz_utility_pub.creation_Date,
3591: hz_utility_pub.last_update_login,
3592: hz_utility_pub.last_update_date,
3593: hz_utility_pub.last_updated_by);

Line 3590: hz_utility_pub.creation_Date,

3586: l_from_profile_id,
3587: l_to_profile_id,
3588: 'Y',
3589: hz_utility_pub.created_by,
3590: hz_utility_pub.creation_Date,
3591: hz_utility_pub.last_update_login,
3592: hz_utility_pub.last_update_date,
3593: hz_utility_pub.last_updated_by);
3594:

Line 3591: hz_utility_pub.last_update_login,

3587: l_to_profile_id,
3588: 'Y',
3589: hz_utility_pub.created_by,
3590: hz_utility_pub.creation_Date,
3591: hz_utility_pub.last_update_login,
3592: hz_utility_pub.last_update_date,
3593: hz_utility_pub.last_updated_by);
3594:
3595:

Line 3592: hz_utility_pub.last_update_date,

3588: 'Y',
3589: hz_utility_pub.created_by,
3590: hz_utility_pub.creation_Date,
3591: hz_utility_pub.last_update_login,
3592: hz_utility_pub.last_update_date,
3593: hz_utility_pub.last_updated_by);
3594:
3595:
3596:

Line 3593: hz_utility_pub.last_updated_by);

3589: hz_utility_pub.created_by,
3590: hz_utility_pub.creation_Date,
3591: hz_utility_pub.last_update_login,
3592: hz_utility_pub.last_update_date,
3593: hz_utility_pub.last_updated_by);
3594:
3595:
3596:
3597: -- *******************************************

Line 3605: last_update_date = hz_utility_pub.last_update_date,

3601: -- Inactivate the from's active party site.
3602: UPDATE HZ_PARTY_SITES ps
3603: SET STATUS = 'M',
3604: end_date_active = trunc(SYSDATE-1),
3605: last_update_date = hz_utility_pub.last_update_date,
3606: last_updated_by = hz_utility_pub.user_id,
3607: last_update_login = hz_utility_pub.last_update_login,
3608: request_id = hz_utility_pub.request_id,
3609: program_application_id = hz_utility_pub.program_application_id,

Line 3606: last_updated_by = hz_utility_pub.user_id,

3602: UPDATE HZ_PARTY_SITES ps
3603: SET STATUS = 'M',
3604: end_date_active = trunc(SYSDATE-1),
3605: last_update_date = hz_utility_pub.last_update_date,
3606: last_updated_by = hz_utility_pub.user_id,
3607: last_update_login = hz_utility_pub.last_update_login,
3608: request_id = hz_utility_pub.request_id,
3609: program_application_id = hz_utility_pub.program_application_id,
3610: program_id = hz_utility_pub.program_id,

Line 3607: last_update_login = hz_utility_pub.last_update_login,

3603: SET STATUS = 'M',
3604: end_date_active = trunc(SYSDATE-1),
3605: last_update_date = hz_utility_pub.last_update_date,
3606: last_updated_by = hz_utility_pub.user_id,
3607: last_update_login = hz_utility_pub.last_update_login,
3608: request_id = hz_utility_pub.request_id,
3609: program_application_id = hz_utility_pub.program_application_id,
3610: program_id = hz_utility_pub.program_id,
3611: program_update_date = sysdate

Line 3608: request_id = hz_utility_pub.request_id,

3604: end_date_active = trunc(SYSDATE-1),
3605: last_update_date = hz_utility_pub.last_update_date,
3606: last_updated_by = hz_utility_pub.user_id,
3607: last_update_login = hz_utility_pub.last_update_login,
3608: request_id = hz_utility_pub.request_id,
3609: program_application_id = hz_utility_pub.program_application_id,
3610: program_id = hz_utility_pub.program_id,
3611: program_update_date = sysdate
3612: WHERE party_id= p_from_id

Line 3609: program_application_id = hz_utility_pub.program_application_id,

3605: last_update_date = hz_utility_pub.last_update_date,
3606: last_updated_by = hz_utility_pub.user_id,
3607: last_update_login = hz_utility_pub.last_update_login,
3608: request_id = hz_utility_pub.request_id,
3609: program_application_id = hz_utility_pub.program_application_id,
3610: program_id = hz_utility_pub.program_id,
3611: program_update_date = sysdate
3612: WHERE party_id= p_from_id
3613: AND actual_content_source = 'DNB'

Line 3610: program_id = hz_utility_pub.program_id,

3606: last_updated_by = hz_utility_pub.user_id,
3607: last_update_login = hz_utility_pub.last_update_login,
3608: request_id = hz_utility_pub.request_id,
3609: program_application_id = hz_utility_pub.program_application_id,
3610: program_id = hz_utility_pub.program_id,
3611: program_update_date = sysdate
3612: WHERE party_id= p_from_id
3613: AND actual_content_source = 'DNB'
3614: AND nvl(status,'A') in ('A','I');

Line 3631: last_update_date = hz_utility_pub.last_update_date,

3627:
3628: UPDATE HZ_RELATIONSHIPS
3629: SET end_date = TRUNC(SYSDATE-1),
3630: status = 'M',
3631: last_update_date = hz_utility_pub.last_update_date,
3632: last_updated_by = hz_utility_pub.user_id,
3633: last_update_login = hz_utility_pub.last_update_login,
3634: request_id = hz_utility_pub.request_id,
3635: program_application_id = hz_utility_pub.program_application_id,

Line 3632: last_updated_by = hz_utility_pub.user_id,

3628: UPDATE HZ_RELATIONSHIPS
3629: SET end_date = TRUNC(SYSDATE-1),
3630: status = 'M',
3631: last_update_date = hz_utility_pub.last_update_date,
3632: last_updated_by = hz_utility_pub.user_id,
3633: last_update_login = hz_utility_pub.last_update_login,
3634: request_id = hz_utility_pub.request_id,
3635: program_application_id = hz_utility_pub.program_application_id,
3636: program_id = hz_utility_pub.program_id,

Line 3633: last_update_login = hz_utility_pub.last_update_login,

3629: SET end_date = TRUNC(SYSDATE-1),
3630: status = 'M',
3631: last_update_date = hz_utility_pub.last_update_date,
3632: last_updated_by = hz_utility_pub.user_id,
3633: last_update_login = hz_utility_pub.last_update_login,
3634: request_id = hz_utility_pub.request_id,
3635: program_application_id = hz_utility_pub.program_application_id,
3636: program_id = hz_utility_pub.program_id,
3637: program_update_date = sysdate

Line 3634: request_id = hz_utility_pub.request_id,

3630: status = 'M',
3631: last_update_date = hz_utility_pub.last_update_date,
3632: last_updated_by = hz_utility_pub.user_id,
3633: last_update_login = hz_utility_pub.last_update_login,
3634: request_id = hz_utility_pub.request_id,
3635: program_application_id = hz_utility_pub.program_application_id,
3636: program_id = hz_utility_pub.program_id,
3637: program_update_date = sysdate
3638: WHERE relationship_id =FROM_REL.RELATIONSHIP_ID;

Line 3635: program_application_id = hz_utility_pub.program_application_id,

3631: last_update_date = hz_utility_pub.last_update_date,
3632: last_updated_by = hz_utility_pub.user_id,
3633: last_update_login = hz_utility_pub.last_update_login,
3634: request_id = hz_utility_pub.request_id,
3635: program_application_id = hz_utility_pub.program_application_id,
3636: program_id = hz_utility_pub.program_id,
3637: program_update_date = sysdate
3638: WHERE relationship_id =FROM_REL.RELATIONSHIP_ID;
3639:

Line 3636: program_id = hz_utility_pub.program_id,

3632: last_updated_by = hz_utility_pub.user_id,
3633: last_update_login = hz_utility_pub.last_update_login,
3634: request_id = hz_utility_pub.request_id,
3635: program_application_id = hz_utility_pub.program_application_id,
3636: program_id = hz_utility_pub.program_id,
3637: program_update_date = sysdate
3638: WHERE relationship_id =FROM_REL.RELATIONSHIP_ID;
3639:
3640: ----Inactivating SSM Record

Line 3644: last_update_date = hz_utility_pub.last_update_date,

3640: ----Inactivating SSM Record
3641: UPDATE HZ_ORIG_SYS_REFERENCES
3642: SET STATUS = 'I',
3643: END_DATE_ACTIVE =trunc(SYSDATE-1),
3644: last_update_date = hz_utility_pub.last_update_date,
3645: last_updated_by = hz_utility_pub.user_id,
3646: last_update_login = hz_utility_pub.last_update_login,
3647: request_id = hz_utility_pub.request_id,
3648: program_application_id = hz_utility_pub.program_application_id,

Line 3645: last_updated_by = hz_utility_pub.user_id,

3641: UPDATE HZ_ORIG_SYS_REFERENCES
3642: SET STATUS = 'I',
3643: END_DATE_ACTIVE =trunc(SYSDATE-1),
3644: last_update_date = hz_utility_pub.last_update_date,
3645: last_updated_by = hz_utility_pub.user_id,
3646: last_update_login = hz_utility_pub.last_update_login,
3647: request_id = hz_utility_pub.request_id,
3648: program_application_id = hz_utility_pub.program_application_id,
3649: program_id = hz_utility_pub.program_id,

Line 3646: last_update_login = hz_utility_pub.last_update_login,

3642: SET STATUS = 'I',
3643: END_DATE_ACTIVE =trunc(SYSDATE-1),
3644: last_update_date = hz_utility_pub.last_update_date,
3645: last_updated_by = hz_utility_pub.user_id,
3646: last_update_login = hz_utility_pub.last_update_login,
3647: request_id = hz_utility_pub.request_id,
3648: program_application_id = hz_utility_pub.program_application_id,
3649: program_id = hz_utility_pub.program_id,
3650: program_update_date = sysdate

Line 3647: request_id = hz_utility_pub.request_id,

3643: END_DATE_ACTIVE =trunc(SYSDATE-1),
3644: last_update_date = hz_utility_pub.last_update_date,
3645: last_updated_by = hz_utility_pub.user_id,
3646: last_update_login = hz_utility_pub.last_update_login,
3647: request_id = hz_utility_pub.request_id,
3648: program_application_id = hz_utility_pub.program_application_id,
3649: program_id = hz_utility_pub.program_id,
3650: program_update_date = sysdate
3651: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'

Line 3648: program_application_id = hz_utility_pub.program_application_id,

3644: last_update_date = hz_utility_pub.last_update_date,
3645: last_updated_by = hz_utility_pub.user_id,
3646: last_update_login = hz_utility_pub.last_update_login,
3647: request_id = hz_utility_pub.request_id,
3648: program_application_id = hz_utility_pub.program_application_id,
3649: program_id = hz_utility_pub.program_id,
3650: program_update_date = sysdate
3651: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
3652: AND OWNER_TABLE_ID = FROM_REL.PARTY_ID

Line 3649: program_id = hz_utility_pub.program_id,

3645: last_updated_by = hz_utility_pub.user_id,
3646: last_update_login = hz_utility_pub.last_update_login,
3647: request_id = hz_utility_pub.request_id,
3648: program_application_id = hz_utility_pub.program_application_id,
3649: program_id = hz_utility_pub.program_id,
3650: program_update_date = sysdate
3651: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
3652: AND OWNER_TABLE_ID = FROM_REL.PARTY_ID
3653: AND ORIG_SYSTEM = 'DNB'

Line 3658: last_update_date = hz_utility_pub.last_update_date,

3654: AND STATUS = 'A';
3655:
3656: UPDATE HZ_PARTIES
3657: SET status = 'M',
3658: last_update_date = hz_utility_pub.last_update_date,
3659: last_updated_by = hz_utility_pub.user_id,
3660: last_update_login = hz_utility_pub.last_update_login,
3661: request_id = hz_utility_pub.request_id,
3662: program_application_id = hz_utility_pub.program_application_id,

Line 3659: last_updated_by = hz_utility_pub.user_id,

3655:
3656: UPDATE HZ_PARTIES
3657: SET status = 'M',
3658: last_update_date = hz_utility_pub.last_update_date,
3659: last_updated_by = hz_utility_pub.user_id,
3660: last_update_login = hz_utility_pub.last_update_login,
3661: request_id = hz_utility_pub.request_id,
3662: program_application_id = hz_utility_pub.program_application_id,
3663: program_id = hz_utility_pub.program_id,

Line 3660: last_update_login = hz_utility_pub.last_update_login,

3656: UPDATE HZ_PARTIES
3657: SET status = 'M',
3658: last_update_date = hz_utility_pub.last_update_date,
3659: last_updated_by = hz_utility_pub.user_id,
3660: last_update_login = hz_utility_pub.last_update_login,
3661: request_id = hz_utility_pub.request_id,
3662: program_application_id = hz_utility_pub.program_application_id,
3663: program_id = hz_utility_pub.program_id,
3664: program_update_date = sysdate

Line 3661: request_id = hz_utility_pub.request_id,

3657: SET status = 'M',
3658: last_update_date = hz_utility_pub.last_update_date,
3659: last_updated_by = hz_utility_pub.user_id,
3660: last_update_login = hz_utility_pub.last_update_login,
3661: request_id = hz_utility_pub.request_id,
3662: program_application_id = hz_utility_pub.program_application_id,
3663: program_id = hz_utility_pub.program_id,
3664: program_update_date = sysdate
3665: WHERE party_id = FROM_REL.party_id;

Line 3662: program_application_id = hz_utility_pub.program_application_id,

3658: last_update_date = hz_utility_pub.last_update_date,
3659: last_updated_by = hz_utility_pub.user_id,
3660: last_update_login = hz_utility_pub.last_update_login,
3661: request_id = hz_utility_pub.request_id,
3662: program_application_id = hz_utility_pub.program_application_id,
3663: program_id = hz_utility_pub.program_id,
3664: program_update_date = sysdate
3665: WHERE party_id = FROM_REL.party_id;
3666:

Line 3663: program_id = hz_utility_pub.program_id,

3659: last_updated_by = hz_utility_pub.user_id,
3660: last_update_login = hz_utility_pub.last_update_login,
3661: request_id = hz_utility_pub.request_id,
3662: program_application_id = hz_utility_pub.program_application_id,
3663: program_id = hz_utility_pub.program_id,
3664: program_update_date = sysdate
3665: WHERE party_id = FROM_REL.party_id;
3666:
3667: IF FROM_REL.relationship_type = 'DNB_HIERARCHY' THEN

Line 3819: hz_utility_pub.created_by,

3815: 'HZ_CONTACT_POINTS',
3816: l_to,
3817: FROM_CP.contact_point_id,
3818: 'T',
3819: hz_utility_pub.created_by,
3820: hz_utility_pub.creation_Date,
3821: hz_utility_pub.last_update_login,
3822: hz_utility_pub.last_update_date,
3823: hz_utility_pub.last_updated_by);

Line 3820: hz_utility_pub.creation_Date,

3816: l_to,
3817: FROM_CP.contact_point_id,
3818: 'T',
3819: hz_utility_pub.created_by,
3820: hz_utility_pub.creation_Date,
3821: hz_utility_pub.last_update_login,
3822: hz_utility_pub.last_update_date,
3823: hz_utility_pub.last_updated_by);
3824: ELSE

Line 3821: hz_utility_pub.last_update_login,

3817: FROM_CP.contact_point_id,
3818: 'T',
3819: hz_utility_pub.created_by,
3820: hz_utility_pub.creation_Date,
3821: hz_utility_pub.last_update_login,
3822: hz_utility_pub.last_update_date,
3823: hz_utility_pub.last_updated_by);
3824: ELSE
3825: UPDATE HZ_CONTACT_POINTS

Line 3822: hz_utility_pub.last_update_date,

3818: 'T',
3819: hz_utility_pub.created_by,
3820: hz_utility_pub.creation_Date,
3821: hz_utility_pub.last_update_login,
3822: hz_utility_pub.last_update_date,
3823: hz_utility_pub.last_updated_by);
3824: ELSE
3825: UPDATE HZ_CONTACT_POINTS
3826: SET actual_content_source = 'USER_ENTERED',

Line 3823: hz_utility_pub.last_updated_by);

3819: hz_utility_pub.created_by,
3820: hz_utility_pub.creation_Date,
3821: hz_utility_pub.last_update_login,
3822: hz_utility_pub.last_update_date,
3823: hz_utility_pub.last_updated_by);
3824: ELSE
3825: UPDATE HZ_CONTACT_POINTS
3826: SET actual_content_source = 'USER_ENTERED',
3827: last_update_date =hz_utility_pub.last_update_date,

Line 3827: last_update_date =hz_utility_pub.last_update_date,

3823: hz_utility_pub.last_updated_by);
3824: ELSE
3825: UPDATE HZ_CONTACT_POINTS
3826: SET actual_content_source = 'USER_ENTERED',
3827: last_update_date =hz_utility_pub.last_update_date,
3828: last_updated_by = hz_utility_pub.last_updated_by,
3829: last_update_login=hz_utility_pub.last_update_login,
3830: request_id = hz_utility_pub.request_id,
3831: program_application_id = hz_utility_pub.program_application_id,

Line 3828: last_updated_by = hz_utility_pub.last_updated_by,

3824: ELSE
3825: UPDATE HZ_CONTACT_POINTS
3826: SET actual_content_source = 'USER_ENTERED',
3827: last_update_date =hz_utility_pub.last_update_date,
3828: last_updated_by = hz_utility_pub.last_updated_by,
3829: last_update_login=hz_utility_pub.last_update_login,
3830: request_id = hz_utility_pub.request_id,
3831: program_application_id = hz_utility_pub.program_application_id,
3832: program_id = hz_utility_pub.program_id,

Line 3829: last_update_login=hz_utility_pub.last_update_login,

3825: UPDATE HZ_CONTACT_POINTS
3826: SET actual_content_source = 'USER_ENTERED',
3827: last_update_date =hz_utility_pub.last_update_date,
3828: last_updated_by = hz_utility_pub.last_updated_by,
3829: last_update_login=hz_utility_pub.last_update_login,
3830: request_id = hz_utility_pub.request_id,
3831: program_application_id = hz_utility_pub.program_application_id,
3832: program_id = hz_utility_pub.program_id,
3833: program_update_date = sysdate

Line 3830: request_id = hz_utility_pub.request_id,

3826: SET actual_content_source = 'USER_ENTERED',
3827: last_update_date =hz_utility_pub.last_update_date,
3828: last_updated_by = hz_utility_pub.last_updated_by,
3829: last_update_login=hz_utility_pub.last_update_login,
3830: request_id = hz_utility_pub.request_id,
3831: program_application_id = hz_utility_pub.program_application_id,
3832: program_id = hz_utility_pub.program_id,
3833: program_update_date = sysdate
3834: WHERE contact_point_id = l_to;

Line 3831: program_application_id = hz_utility_pub.program_application_id,

3827: last_update_date =hz_utility_pub.last_update_date,
3828: last_updated_by = hz_utility_pub.last_updated_by,
3829: last_update_login=hz_utility_pub.last_update_login,
3830: request_id = hz_utility_pub.request_id,
3831: program_application_id = hz_utility_pub.program_application_id,
3832: program_id = hz_utility_pub.program_id,
3833: program_update_date = sysdate
3834: WHERE contact_point_id = l_to;
3835: ----Inactivating SSM Record

Line 3832: program_id = hz_utility_pub.program_id,

3828: last_updated_by = hz_utility_pub.last_updated_by,
3829: last_update_login=hz_utility_pub.last_update_login,
3830: request_id = hz_utility_pub.request_id,
3831: program_application_id = hz_utility_pub.program_application_id,
3832: program_id = hz_utility_pub.program_id,
3833: program_update_date = sysdate
3834: WHERE contact_point_id = l_to;
3835: ----Inactivating SSM Record
3836: UPDATE HZ_ORIG_SYS_REFERENCES

Line 3839: last_update_date = hz_utility_pub.last_update_date,

3835: ----Inactivating SSM Record
3836: UPDATE HZ_ORIG_SYS_REFERENCES
3837: SET STATUS = 'I',
3838: END_DATE_ACTIVE =trunc(SYSDATE-1),
3839: last_update_date = hz_utility_pub.last_update_date,
3840: last_updated_by = hz_utility_pub.user_id,
3841: last_update_login = hz_utility_pub.last_update_login,
3842: request_id = hz_utility_pub.request_id,
3843: program_application_id = hz_utility_pub.program_application_id,

Line 3840: last_updated_by = hz_utility_pub.user_id,

3836: UPDATE HZ_ORIG_SYS_REFERENCES
3837: SET STATUS = 'I',
3838: END_DATE_ACTIVE =trunc(SYSDATE-1),
3839: last_update_date = hz_utility_pub.last_update_date,
3840: last_updated_by = hz_utility_pub.user_id,
3841: last_update_login = hz_utility_pub.last_update_login,
3842: request_id = hz_utility_pub.request_id,
3843: program_application_id = hz_utility_pub.program_application_id,
3844: program_id = hz_utility_pub.program_id,

Line 3841: last_update_login = hz_utility_pub.last_update_login,

3837: SET STATUS = 'I',
3838: END_DATE_ACTIVE =trunc(SYSDATE-1),
3839: last_update_date = hz_utility_pub.last_update_date,
3840: last_updated_by = hz_utility_pub.user_id,
3841: last_update_login = hz_utility_pub.last_update_login,
3842: request_id = hz_utility_pub.request_id,
3843: program_application_id = hz_utility_pub.program_application_id,
3844: program_id = hz_utility_pub.program_id,
3845: program_update_date = sysdate

Line 3842: request_id = hz_utility_pub.request_id,

3838: END_DATE_ACTIVE =trunc(SYSDATE-1),
3839: last_update_date = hz_utility_pub.last_update_date,
3840: last_updated_by = hz_utility_pub.user_id,
3841: last_update_login = hz_utility_pub.last_update_login,
3842: request_id = hz_utility_pub.request_id,
3843: program_application_id = hz_utility_pub.program_application_id,
3844: program_id = hz_utility_pub.program_id,
3845: program_update_date = sysdate
3846: WHERE OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'

Line 3843: program_application_id = hz_utility_pub.program_application_id,

3839: last_update_date = hz_utility_pub.last_update_date,
3840: last_updated_by = hz_utility_pub.user_id,
3841: last_update_login = hz_utility_pub.last_update_login,
3842: request_id = hz_utility_pub.request_id,
3843: program_application_id = hz_utility_pub.program_application_id,
3844: program_id = hz_utility_pub.program_id,
3845: program_update_date = sysdate
3846: WHERE OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
3847: AND OWNER_TABLE_ID = l_to

Line 3844: program_id = hz_utility_pub.program_id,

3840: last_updated_by = hz_utility_pub.user_id,
3841: last_update_login = hz_utility_pub.last_update_login,
3842: request_id = hz_utility_pub.request_id,
3843: program_application_id = hz_utility_pub.program_application_id,
3844: program_id = hz_utility_pub.program_id,
3845: program_update_date = sysdate
3846: WHERE OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
3847: AND OWNER_TABLE_ID = l_to
3848: AND ORIG_SYSTEM = 'DNB'

Line 3936: hz_utility_pub.created_by,

3932: 'HZ_CONTACT_POINTS',
3933: FROM_CP.contact_point_id,
3934: l_to,
3935: 'Y',
3936: hz_utility_pub.created_by,
3937: hz_utility_pub.creation_Date,
3938: hz_utility_pub.last_update_login,
3939: hz_utility_pub.last_update_date,
3940: hz_utility_pub.last_updated_by);

Line 3937: hz_utility_pub.creation_Date,

3933: FROM_CP.contact_point_id,
3934: l_to,
3935: 'Y',
3936: hz_utility_pub.created_by,
3937: hz_utility_pub.creation_Date,
3938: hz_utility_pub.last_update_login,
3939: hz_utility_pub.last_update_date,
3940: hz_utility_pub.last_updated_by);
3941: ELSE

Line 3938: hz_utility_pub.last_update_login,

3934: l_to,
3935: 'Y',
3936: hz_utility_pub.created_by,
3937: hz_utility_pub.creation_Date,
3938: hz_utility_pub.last_update_login,
3939: hz_utility_pub.last_update_date,
3940: hz_utility_pub.last_updated_by);
3941: ELSE
3942: UPDATE HZ_CONTACT_POINTS

Line 3939: hz_utility_pub.last_update_date,

3935: 'Y',
3936: hz_utility_pub.created_by,
3937: hz_utility_pub.creation_Date,
3938: hz_utility_pub.last_update_login,
3939: hz_utility_pub.last_update_date,
3940: hz_utility_pub.last_updated_by);
3941: ELSE
3942: UPDATE HZ_CONTACT_POINTS
3943: SET actual_content_source = 'USER_ENTERED',

Line 3940: hz_utility_pub.last_updated_by);

3936: hz_utility_pub.created_by,
3937: hz_utility_pub.creation_Date,
3938: hz_utility_pub.last_update_login,
3939: hz_utility_pub.last_update_date,
3940: hz_utility_pub.last_updated_by);
3941: ELSE
3942: UPDATE HZ_CONTACT_POINTS
3943: SET actual_content_source = 'USER_ENTERED',
3944: last_update_date =hz_utility_pub.last_update_date,

Line 3944: last_update_date =hz_utility_pub.last_update_date,

3940: hz_utility_pub.last_updated_by);
3941: ELSE
3942: UPDATE HZ_CONTACT_POINTS
3943: SET actual_content_source = 'USER_ENTERED',
3944: last_update_date =hz_utility_pub.last_update_date,
3945: last_updated_by = hz_utility_pub.last_updated_by,
3946: last_update_login=hz_utility_pub.last_update_login,
3947: request_id = hz_utility_pub.request_id,
3948: program_application_id = hz_utility_pub.program_application_id,

Line 3945: last_updated_by = hz_utility_pub.last_updated_by,

3941: ELSE
3942: UPDATE HZ_CONTACT_POINTS
3943: SET actual_content_source = 'USER_ENTERED',
3944: last_update_date =hz_utility_pub.last_update_date,
3945: last_updated_by = hz_utility_pub.last_updated_by,
3946: last_update_login=hz_utility_pub.last_update_login,
3947: request_id = hz_utility_pub.request_id,
3948: program_application_id = hz_utility_pub.program_application_id,
3949: program_id = hz_utility_pub.program_id,

Line 3946: last_update_login=hz_utility_pub.last_update_login,

3942: UPDATE HZ_CONTACT_POINTS
3943: SET actual_content_source = 'USER_ENTERED',
3944: last_update_date =hz_utility_pub.last_update_date,
3945: last_updated_by = hz_utility_pub.last_updated_by,
3946: last_update_login=hz_utility_pub.last_update_login,
3947: request_id = hz_utility_pub.request_id,
3948: program_application_id = hz_utility_pub.program_application_id,
3949: program_id = hz_utility_pub.program_id,
3950: program_update_date = sysdate

Line 3947: request_id = hz_utility_pub.request_id,

3943: SET actual_content_source = 'USER_ENTERED',
3944: last_update_date =hz_utility_pub.last_update_date,
3945: last_updated_by = hz_utility_pub.last_updated_by,
3946: last_update_login=hz_utility_pub.last_update_login,
3947: request_id = hz_utility_pub.request_id,
3948: program_application_id = hz_utility_pub.program_application_id,
3949: program_id = hz_utility_pub.program_id,
3950: program_update_date = sysdate
3951: WHERE contact_point_id = FROM_CP.contact_point_id;

Line 3948: program_application_id = hz_utility_pub.program_application_id,

3944: last_update_date =hz_utility_pub.last_update_date,
3945: last_updated_by = hz_utility_pub.last_updated_by,
3946: last_update_login=hz_utility_pub.last_update_login,
3947: request_id = hz_utility_pub.request_id,
3948: program_application_id = hz_utility_pub.program_application_id,
3949: program_id = hz_utility_pub.program_id,
3950: program_update_date = sysdate
3951: WHERE contact_point_id = FROM_CP.contact_point_id;
3952: ----Inactivating SSM Record

Line 3949: program_id = hz_utility_pub.program_id,

3945: last_updated_by = hz_utility_pub.last_updated_by,
3946: last_update_login=hz_utility_pub.last_update_login,
3947: request_id = hz_utility_pub.request_id,
3948: program_application_id = hz_utility_pub.program_application_id,
3949: program_id = hz_utility_pub.program_id,
3950: program_update_date = sysdate
3951: WHERE contact_point_id = FROM_CP.contact_point_id;
3952: ----Inactivating SSM Record
3953: UPDATE HZ_ORIG_SYS_REFERENCES

Line 3956: last_update_date = hz_utility_pub.last_update_date,

3952: ----Inactivating SSM Record
3953: UPDATE HZ_ORIG_SYS_REFERENCES
3954: SET STATUS = 'I',
3955: END_DATE_ACTIVE =trunc(SYSDATE-1),
3956: last_update_date = hz_utility_pub.last_update_date,
3957: last_updated_by = hz_utility_pub.user_id,
3958: last_update_login = hz_utility_pub.last_update_login,
3959: request_id = hz_utility_pub.request_id,
3960: program_application_id = hz_utility_pub.program_application_id,

Line 3957: last_updated_by = hz_utility_pub.user_id,

3953: UPDATE HZ_ORIG_SYS_REFERENCES
3954: SET STATUS = 'I',
3955: END_DATE_ACTIVE =trunc(SYSDATE-1),
3956: last_update_date = hz_utility_pub.last_update_date,
3957: last_updated_by = hz_utility_pub.user_id,
3958: last_update_login = hz_utility_pub.last_update_login,
3959: request_id = hz_utility_pub.request_id,
3960: program_application_id = hz_utility_pub.program_application_id,
3961: program_id = hz_utility_pub.program_id,

Line 3958: last_update_login = hz_utility_pub.last_update_login,

3954: SET STATUS = 'I',
3955: END_DATE_ACTIVE =trunc(SYSDATE-1),
3956: last_update_date = hz_utility_pub.last_update_date,
3957: last_updated_by = hz_utility_pub.user_id,
3958: last_update_login = hz_utility_pub.last_update_login,
3959: request_id = hz_utility_pub.request_id,
3960: program_application_id = hz_utility_pub.program_application_id,
3961: program_id = hz_utility_pub.program_id,
3962: program_update_date = sysdate

Line 3959: request_id = hz_utility_pub.request_id,

3955: END_DATE_ACTIVE =trunc(SYSDATE-1),
3956: last_update_date = hz_utility_pub.last_update_date,
3957: last_updated_by = hz_utility_pub.user_id,
3958: last_update_login = hz_utility_pub.last_update_login,
3959: request_id = hz_utility_pub.request_id,
3960: program_application_id = hz_utility_pub.program_application_id,
3961: program_id = hz_utility_pub.program_id,
3962: program_update_date = sysdate
3963: WHERE OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'

Line 3960: program_application_id = hz_utility_pub.program_application_id,

3956: last_update_date = hz_utility_pub.last_update_date,
3957: last_updated_by = hz_utility_pub.user_id,
3958: last_update_login = hz_utility_pub.last_update_login,
3959: request_id = hz_utility_pub.request_id,
3960: program_application_id = hz_utility_pub.program_application_id,
3961: program_id = hz_utility_pub.program_id,
3962: program_update_date = sysdate
3963: WHERE OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
3964: AND OWNER_TABLE_ID =FROM_CP.contact_point_id

Line 3961: program_id = hz_utility_pub.program_id,

3957: last_updated_by = hz_utility_pub.user_id,
3958: last_update_login = hz_utility_pub.last_update_login,
3959: request_id = hz_utility_pub.request_id,
3960: program_application_id = hz_utility_pub.program_application_id,
3961: program_id = hz_utility_pub.program_id,
3962: program_update_date = sysdate
3963: WHERE OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
3964: AND OWNER_TABLE_ID =FROM_CP.contact_point_id
3965: AND ORIG_SYSTEM = 'DNB'

Line 4005: hz_utility_pub.created_by,

4001: 'HZ_CREDIT_RATINGS',
4002: l_to,
4003: FROM_CR.credit_rating_id,
4004: 'T',
4005: hz_utility_pub.created_by,
4006: hz_utility_pub.creation_Date,
4007: hz_utility_pub.last_update_login,
4008: hz_utility_pub.last_update_date,
4009: hz_utility_pub.last_updated_by);

Line 4006: hz_utility_pub.creation_Date,

4002: l_to,
4003: FROM_CR.credit_rating_id,
4004: 'T',
4005: hz_utility_pub.created_by,
4006: hz_utility_pub.creation_Date,
4007: hz_utility_pub.last_update_login,
4008: hz_utility_pub.last_update_date,
4009: hz_utility_pub.last_updated_by);
4010: */

Line 4007: hz_utility_pub.last_update_login,

4003: FROM_CR.credit_rating_id,
4004: 'T',
4005: hz_utility_pub.created_by,
4006: hz_utility_pub.creation_Date,
4007: hz_utility_pub.last_update_login,
4008: hz_utility_pub.last_update_date,
4009: hz_utility_pub.last_updated_by);
4010: */
4011: ELSE -- To Newer

Line 4008: hz_utility_pub.last_update_date,

4004: 'T',
4005: hz_utility_pub.created_by,
4006: hz_utility_pub.creation_Date,
4007: hz_utility_pub.last_update_login,
4008: hz_utility_pub.last_update_date,
4009: hz_utility_pub.last_updated_by);
4010: */
4011: ELSE -- To Newer
4012: -- Merge from into to

Line 4009: hz_utility_pub.last_updated_by);

4005: hz_utility_pub.created_by,
4006: hz_utility_pub.creation_Date,
4007: hz_utility_pub.last_update_login,
4008: hz_utility_pub.last_update_date,
4009: hz_utility_pub.last_updated_by);
4010: */
4011: ELSE -- To Newer
4012: -- Merge from into to
4013: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

Line 4019: hz_utility_pub.created_by,

4015: 'HZ_CREDIT_RATINGS',
4016: FROM_CR.credit_rating_id,
4017: l_to,
4018: 'Y',
4019: hz_utility_pub.created_by,
4020: hz_utility_pub.creation_Date,
4021: hz_utility_pub.last_update_login,
4022: hz_utility_pub.last_update_date,
4023: hz_utility_pub.last_updated_by);

Line 4020: hz_utility_pub.creation_Date,

4016: FROM_CR.credit_rating_id,
4017: l_to,
4018: 'Y',
4019: hz_utility_pub.created_by,
4020: hz_utility_pub.creation_Date,
4021: hz_utility_pub.last_update_login,
4022: hz_utility_pub.last_update_date,
4023: hz_utility_pub.last_updated_by);
4024: END IF;

Line 4021: hz_utility_pub.last_update_login,

4017: l_to,
4018: 'Y',
4019: hz_utility_pub.created_by,
4020: hz_utility_pub.creation_Date,
4021: hz_utility_pub.last_update_login,
4022: hz_utility_pub.last_update_date,
4023: hz_utility_pub.last_updated_by);
4024: END IF;
4025: EXCEPTION

Line 4022: hz_utility_pub.last_update_date,

4018: 'Y',
4019: hz_utility_pub.created_by,
4020: hz_utility_pub.creation_Date,
4021: hz_utility_pub.last_update_login,
4022: hz_utility_pub.last_update_date,
4023: hz_utility_pub.last_updated_by);
4024: END IF;
4025: EXCEPTION
4026: WHEN NO_DATA_FOUND THEN

Line 4023: hz_utility_pub.last_updated_by);

4019: hz_utility_pub.created_by,
4020: hz_utility_pub.creation_Date,
4021: hz_utility_pub.last_update_login,
4022: hz_utility_pub.last_update_date,
4023: hz_utility_pub.last_updated_by);
4024: END IF;
4025: EXCEPTION
4026: WHEN NO_DATA_FOUND THEN
4027: -- Transfer

Line 4062: hz_utility_pub.created_by,

4058: 'HZ_CODE_ASSIGNMENTS',
4059: FROM_CA.code_assignment_id,
4060: l_to,
4061: 'Y',
4062: hz_utility_pub.created_by,
4063: hz_utility_pub.creation_Date,
4064: hz_utility_pub.last_update_login,
4065: hz_utility_pub.last_update_date,
4066: hz_utility_pub.last_updated_by);

Line 4063: hz_utility_pub.creation_Date,

4059: FROM_CA.code_assignment_id,
4060: l_to,
4061: 'Y',
4062: hz_utility_pub.created_by,
4063: hz_utility_pub.creation_Date,
4064: hz_utility_pub.last_update_login,
4065: hz_utility_pub.last_update_date,
4066: hz_utility_pub.last_updated_by);
4067: ELSE -- To Newer

Line 4064: hz_utility_pub.last_update_login,

4060: l_to,
4061: 'Y',
4062: hz_utility_pub.created_by,
4063: hz_utility_pub.creation_Date,
4064: hz_utility_pub.last_update_login,
4065: hz_utility_pub.last_update_date,
4066: hz_utility_pub.last_updated_by);
4067: ELSE -- To Newer
4068: -- Merge from into to

Line 4065: hz_utility_pub.last_update_date,

4061: 'Y',
4062: hz_utility_pub.created_by,
4063: hz_utility_pub.creation_Date,
4064: hz_utility_pub.last_update_login,
4065: hz_utility_pub.last_update_date,
4066: hz_utility_pub.last_updated_by);
4067: ELSE -- To Newer
4068: -- Merge from into to
4069: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

Line 4066: hz_utility_pub.last_updated_by);

4062: hz_utility_pub.created_by,
4063: hz_utility_pub.creation_Date,
4064: hz_utility_pub.last_update_login,
4065: hz_utility_pub.last_update_date,
4066: hz_utility_pub.last_updated_by);
4067: ELSE -- To Newer
4068: -- Merge from into to
4069: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4070: p_batch_party_id,

Line 4075: hz_utility_pub.created_by,

4071: 'HZ_CODE_ASSIGNMENTS',
4072: FROM_CA.code_assignment_id,
4073: l_to,
4074: 'Y',
4075: hz_utility_pub.created_by,
4076: hz_utility_pub.creation_Date,
4077: hz_utility_pub.last_update_login,
4078: hz_utility_pub.last_update_date,
4079: hz_utility_pub.last_updated_by);

Line 4076: hz_utility_pub.creation_Date,

4072: FROM_CA.code_assignment_id,
4073: l_to,
4074: 'Y',
4075: hz_utility_pub.created_by,
4076: hz_utility_pub.creation_Date,
4077: hz_utility_pub.last_update_login,
4078: hz_utility_pub.last_update_date,
4079: hz_utility_pub.last_updated_by);
4080: END IF;

Line 4077: hz_utility_pub.last_update_login,

4073: l_to,
4074: 'Y',
4075: hz_utility_pub.created_by,
4076: hz_utility_pub.creation_Date,
4077: hz_utility_pub.last_update_login,
4078: hz_utility_pub.last_update_date,
4079: hz_utility_pub.last_updated_by);
4080: END IF;
4081: EXCEPTION

Line 4078: hz_utility_pub.last_update_date,

4074: 'Y',
4075: hz_utility_pub.created_by,
4076: hz_utility_pub.creation_Date,
4077: hz_utility_pub.last_update_login,
4078: hz_utility_pub.last_update_date,
4079: hz_utility_pub.last_updated_by);
4080: END IF;
4081: EXCEPTION
4082: WHEN NO_DATA_FOUND THEN

Line 4079: hz_utility_pub.last_updated_by);

4075: hz_utility_pub.created_by,
4076: hz_utility_pub.creation_Date,
4077: hz_utility_pub.last_update_login,
4078: hz_utility_pub.last_update_date,
4079: hz_utility_pub.last_updated_by);
4080: END IF;
4081: EXCEPTION
4082: WHEN NO_DATA_FOUND THEN
4083: -- Transfer

Line 4130: last_update_date = hz_utility_pub.last_update_date,

4126:
4127: /*
4128: UPDATE HZ_FINANCIAL_REPORTS
4129: SET status = 'I',
4130: last_update_date = hz_utility_pub.last_update_date,
4131: last_updated_by = hz_utility_pub.user_id,
4132: last_update_login = hz_utility_pub.last_update_login,
4133: request_id = hz_utility_pub.request_id,
4134: program_application_id = hz_utility_pub.program_application_id,

Line 4131: last_updated_by = hz_utility_pub.user_id,

4127: /*
4128: UPDATE HZ_FINANCIAL_REPORTS
4129: SET status = 'I',
4130: last_update_date = hz_utility_pub.last_update_date,
4131: last_updated_by = hz_utility_pub.user_id,
4132: last_update_login = hz_utility_pub.last_update_login,
4133: request_id = hz_utility_pub.request_id,
4134: program_application_id = hz_utility_pub.program_application_id,
4135: program_id = hz_utility_pub.program_id,

Line 4132: last_update_login = hz_utility_pub.last_update_login,

4128: UPDATE HZ_FINANCIAL_REPORTS
4129: SET status = 'I',
4130: last_update_date = hz_utility_pub.last_update_date,
4131: last_updated_by = hz_utility_pub.user_id,
4132: last_update_login = hz_utility_pub.last_update_login,
4133: request_id = hz_utility_pub.request_id,
4134: program_application_id = hz_utility_pub.program_application_id,
4135: program_id = hz_utility_pub.program_id,
4136: program_update_date = sysdate

Line 4133: request_id = hz_utility_pub.request_id,

4129: SET status = 'I',
4130: last_update_date = hz_utility_pub.last_update_date,
4131: last_updated_by = hz_utility_pub.user_id,
4132: last_update_login = hz_utility_pub.last_update_login,
4133: request_id = hz_utility_pub.request_id,
4134: program_application_id = hz_utility_pub.program_application_id,
4135: program_id = hz_utility_pub.program_id,
4136: program_update_date = sysdate
4137: WHERE financial_report_id = l_to;

Line 4134: program_application_id = hz_utility_pub.program_application_id,

4130: last_update_date = hz_utility_pub.last_update_date,
4131: last_updated_by = hz_utility_pub.user_id,
4132: last_update_login = hz_utility_pub.last_update_login,
4133: request_id = hz_utility_pub.request_id,
4134: program_application_id = hz_utility_pub.program_application_id,
4135: program_id = hz_utility_pub.program_id,
4136: program_update_date = sysdate
4137: WHERE financial_report_id = l_to;
4138:

Line 4135: program_id = hz_utility_pub.program_id,

4131: last_updated_by = hz_utility_pub.user_id,
4132: last_update_login = hz_utility_pub.last_update_login,
4133: request_id = hz_utility_pub.request_id,
4134: program_application_id = hz_utility_pub.program_application_id,
4135: program_id = hz_utility_pub.program_id,
4136: program_update_date = sysdate
4137: WHERE financial_report_id = l_to;
4138:
4139: UPDATE HZ_FINANCIAL_NUMBERS

Line 4141: last_update_date = hz_utility_pub.last_update_date,

4137: WHERE financial_report_id = l_to;
4138:
4139: UPDATE HZ_FINANCIAL_NUMBERS
4140: SET status='I',
4141: last_update_date = hz_utility_pub.last_update_date,
4142: last_updated_by = hz_utility_pub.user_id,
4143: last_update_login = hz_utility_pub.last_update_login,
4144: request_id = hz_utility_pub.request_id,
4145: program_application_id = hz_utility_pub.program_application_id,

Line 4142: last_updated_by = hz_utility_pub.user_id,

4138:
4139: UPDATE HZ_FINANCIAL_NUMBERS
4140: SET status='I',
4141: last_update_date = hz_utility_pub.last_update_date,
4142: last_updated_by = hz_utility_pub.user_id,
4143: last_update_login = hz_utility_pub.last_update_login,
4144: request_id = hz_utility_pub.request_id,
4145: program_application_id = hz_utility_pub.program_application_id,
4146: program_id = hz_utility_pub.program_id,

Line 4143: last_update_login = hz_utility_pub.last_update_login,

4139: UPDATE HZ_FINANCIAL_NUMBERS
4140: SET status='I',
4141: last_update_date = hz_utility_pub.last_update_date,
4142: last_updated_by = hz_utility_pub.user_id,
4143: last_update_login = hz_utility_pub.last_update_login,
4144: request_id = hz_utility_pub.request_id,
4145: program_application_id = hz_utility_pub.program_application_id,
4146: program_id = hz_utility_pub.program_id,
4147: program_update_date = sysdate

Line 4144: request_id = hz_utility_pub.request_id,

4140: SET status='I',
4141: last_update_date = hz_utility_pub.last_update_date,
4142: last_updated_by = hz_utility_pub.user_id,
4143: last_update_login = hz_utility_pub.last_update_login,
4144: request_id = hz_utility_pub.request_id,
4145: program_application_id = hz_utility_pub.program_application_id,
4146: program_id = hz_utility_pub.program_id,
4147: program_update_date = sysdate
4148: WHERE financial_report_id = l_to;

Line 4145: program_application_id = hz_utility_pub.program_application_id,

4141: last_update_date = hz_utility_pub.last_update_date,
4142: last_updated_by = hz_utility_pub.user_id,
4143: last_update_login = hz_utility_pub.last_update_login,
4144: request_id = hz_utility_pub.request_id,
4145: program_application_id = hz_utility_pub.program_application_id,
4146: program_id = hz_utility_pub.program_id,
4147: program_update_date = sysdate
4148: WHERE financial_report_id = l_to;
4149: */

Line 4146: program_id = hz_utility_pub.program_id,

4142: last_updated_by = hz_utility_pub.user_id,
4143: last_update_login = hz_utility_pub.last_update_login,
4144: request_id = hz_utility_pub.request_id,
4145: program_application_id = hz_utility_pub.program_application_id,
4146: program_id = hz_utility_pub.program_id,
4147: program_update_date = sysdate
4148: WHERE financial_report_id = l_to;
4149: */
4150: ELSE

Line 4153: last_update_date = hz_utility_pub.last_update_date,

4149: */
4150: ELSE
4151: UPDATE HZ_FINANCIAL_REPORTS
4152: SET status = 'M',
4153: last_update_date = hz_utility_pub.last_update_date,
4154: last_updated_by = hz_utility_pub.user_id,
4155: last_update_login = hz_utility_pub.last_update_login,
4156: request_id = hz_utility_pub.request_id,
4157: program_application_id = hz_utility_pub.program_application_id,

Line 4154: last_updated_by = hz_utility_pub.user_id,

4150: ELSE
4151: UPDATE HZ_FINANCIAL_REPORTS
4152: SET status = 'M',
4153: last_update_date = hz_utility_pub.last_update_date,
4154: last_updated_by = hz_utility_pub.user_id,
4155: last_update_login = hz_utility_pub.last_update_login,
4156: request_id = hz_utility_pub.request_id,
4157: program_application_id = hz_utility_pub.program_application_id,
4158: program_id = hz_utility_pub.program_id,

Line 4155: last_update_login = hz_utility_pub.last_update_login,

4151: UPDATE HZ_FINANCIAL_REPORTS
4152: SET status = 'M',
4153: last_update_date = hz_utility_pub.last_update_date,
4154: last_updated_by = hz_utility_pub.user_id,
4155: last_update_login = hz_utility_pub.last_update_login,
4156: request_id = hz_utility_pub.request_id,
4157: program_application_id = hz_utility_pub.program_application_id,
4158: program_id = hz_utility_pub.program_id,
4159: program_update_date = sysdate

Line 4156: request_id = hz_utility_pub.request_id,

4152: SET status = 'M',
4153: last_update_date = hz_utility_pub.last_update_date,
4154: last_updated_by = hz_utility_pub.user_id,
4155: last_update_login = hz_utility_pub.last_update_login,
4156: request_id = hz_utility_pub.request_id,
4157: program_application_id = hz_utility_pub.program_application_id,
4158: program_id = hz_utility_pub.program_id,
4159: program_update_date = sysdate
4160: WHERE financial_report_id = FROM_FR.financial_report_id;

Line 4157: program_application_id = hz_utility_pub.program_application_id,

4153: last_update_date = hz_utility_pub.last_update_date,
4154: last_updated_by = hz_utility_pub.user_id,
4155: last_update_login = hz_utility_pub.last_update_login,
4156: request_id = hz_utility_pub.request_id,
4157: program_application_id = hz_utility_pub.program_application_id,
4158: program_id = hz_utility_pub.program_id,
4159: program_update_date = sysdate
4160: WHERE financial_report_id = FROM_FR.financial_report_id;
4161:

Line 4158: program_id = hz_utility_pub.program_id,

4154: last_updated_by = hz_utility_pub.user_id,
4155: last_update_login = hz_utility_pub.last_update_login,
4156: request_id = hz_utility_pub.request_id,
4157: program_application_id = hz_utility_pub.program_application_id,
4158: program_id = hz_utility_pub.program_id,
4159: program_update_date = sysdate
4160: WHERE financial_report_id = FROM_FR.financial_report_id;
4161:
4162: UPDATE HZ_FINANCIAL_NUMBERS

Line 4164: last_update_date = hz_utility_pub.last_update_date,

4160: WHERE financial_report_id = FROM_FR.financial_report_id;
4161:
4162: UPDATE HZ_FINANCIAL_NUMBERS
4163: SET status='M',
4164: last_update_date = hz_utility_pub.last_update_date,
4165: last_updated_by = hz_utility_pub.user_id,
4166: last_update_login = hz_utility_pub.last_update_login,
4167: request_id = hz_utility_pub.request_id,
4168: program_application_id = hz_utility_pub.program_application_id,

Line 4165: last_updated_by = hz_utility_pub.user_id,

4161:
4162: UPDATE HZ_FINANCIAL_NUMBERS
4163: SET status='M',
4164: last_update_date = hz_utility_pub.last_update_date,
4165: last_updated_by = hz_utility_pub.user_id,
4166: last_update_login = hz_utility_pub.last_update_login,
4167: request_id = hz_utility_pub.request_id,
4168: program_application_id = hz_utility_pub.program_application_id,
4169: program_id = hz_utility_pub.program_id,

Line 4166: last_update_login = hz_utility_pub.last_update_login,

4162: UPDATE HZ_FINANCIAL_NUMBERS
4163: SET status='M',
4164: last_update_date = hz_utility_pub.last_update_date,
4165: last_updated_by = hz_utility_pub.user_id,
4166: last_update_login = hz_utility_pub.last_update_login,
4167: request_id = hz_utility_pub.request_id,
4168: program_application_id = hz_utility_pub.program_application_id,
4169: program_id = hz_utility_pub.program_id,
4170: program_update_date = sysdate

Line 4167: request_id = hz_utility_pub.request_id,

4163: SET status='M',
4164: last_update_date = hz_utility_pub.last_update_date,
4165: last_updated_by = hz_utility_pub.user_id,
4166: last_update_login = hz_utility_pub.last_update_login,
4167: request_id = hz_utility_pub.request_id,
4168: program_application_id = hz_utility_pub.program_application_id,
4169: program_id = hz_utility_pub.program_id,
4170: program_update_date = sysdate
4171: WHERE financial_report_id = FROM_FR.financial_report_id; -- Bug 3313609

Line 4168: program_application_id = hz_utility_pub.program_application_id,

4164: last_update_date = hz_utility_pub.last_update_date,
4165: last_updated_by = hz_utility_pub.user_id,
4166: last_update_login = hz_utility_pub.last_update_login,
4167: request_id = hz_utility_pub.request_id,
4168: program_application_id = hz_utility_pub.program_application_id,
4169: program_id = hz_utility_pub.program_id,
4170: program_update_date = sysdate
4171: WHERE financial_report_id = FROM_FR.financial_report_id; -- Bug 3313609
4172:

Line 4169: program_id = hz_utility_pub.program_id,

4165: last_updated_by = hz_utility_pub.user_id,
4166: last_update_login = hz_utility_pub.last_update_login,
4167: request_id = hz_utility_pub.request_id,
4168: program_application_id = hz_utility_pub.program_application_id,
4169: program_id = hz_utility_pub.program_id,
4170: program_update_date = sysdate
4171: WHERE financial_report_id = FROM_FR.financial_report_id; -- Bug 3313609
4172:
4173: END IF;

Line 4237: hz_utility_pub.created_by,

4233: 'HZ_PARTY_SITES',
4234: l_ps_id,
4235: l_dup_ps_id,
4236: 'Y',
4237: hz_utility_pub.created_by,
4238: hz_utility_pub.creation_Date,
4239: hz_utility_pub.last_update_login,
4240: hz_utility_pub.last_update_date,
4241: hz_utility_pub.last_updated_by);

Line 4238: hz_utility_pub.creation_Date,

4234: l_ps_id,
4235: l_dup_ps_id,
4236: 'Y',
4237: hz_utility_pub.created_by,
4238: hz_utility_pub.creation_Date,
4239: hz_utility_pub.last_update_login,
4240: hz_utility_pub.last_update_date,
4241: hz_utility_pub.last_updated_by);
4242: ELSE

Line 4239: hz_utility_pub.last_update_login,

4235: l_dup_ps_id,
4236: 'Y',
4237: hz_utility_pub.created_by,
4238: hz_utility_pub.creation_Date,
4239: hz_utility_pub.last_update_login,
4240: hz_utility_pub.last_update_date,
4241: hz_utility_pub.last_updated_by);
4242: ELSE
4243: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

Line 4240: hz_utility_pub.last_update_date,

4236: 'Y',
4237: hz_utility_pub.created_by,
4238: hz_utility_pub.creation_Date,
4239: hz_utility_pub.last_update_login,
4240: hz_utility_pub.last_update_date,
4241: hz_utility_pub.last_updated_by);
4242: ELSE
4243: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4244: p_batch_party_id,

Line 4241: hz_utility_pub.last_updated_by);

4237: hz_utility_pub.created_by,
4238: hz_utility_pub.creation_Date,
4239: hz_utility_pub.last_update_login,
4240: hz_utility_pub.last_update_date,
4241: hz_utility_pub.last_updated_by);
4242: ELSE
4243: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4244: p_batch_party_id,
4245: 'HZ_PARTY_SITES',

Line 4249: hz_utility_pub.created_by,

4245: 'HZ_PARTY_SITES',
4246: l_ps_id,
4247: l_ps_id,
4248: 'Y',
4249: hz_utility_pub.created_by,
4250: hz_utility_pub.creation_Date,
4251: hz_utility_pub.last_update_login,
4252: hz_utility_pub.last_update_date,
4253: hz_utility_pub.last_updated_by);

Line 4250: hz_utility_pub.creation_Date,

4246: l_ps_id,
4247: l_ps_id,
4248: 'Y',
4249: hz_utility_pub.created_by,
4250: hz_utility_pub.creation_Date,
4251: hz_utility_pub.last_update_login,
4252: hz_utility_pub.last_update_date,
4253: hz_utility_pub.last_updated_by);
4254: END IF;

Line 4251: hz_utility_pub.last_update_login,

4247: l_ps_id,
4248: 'Y',
4249: hz_utility_pub.created_by,
4250: hz_utility_pub.creation_Date,
4251: hz_utility_pub.last_update_login,
4252: hz_utility_pub.last_update_date,
4253: hz_utility_pub.last_updated_by);
4254: END IF;
4255: CLOSE c_dup_to_ps;

Line 4252: hz_utility_pub.last_update_date,

4248: 'Y',
4249: hz_utility_pub.created_by,
4250: hz_utility_pub.creation_Date,
4251: hz_utility_pub.last_update_login,
4252: hz_utility_pub.last_update_date,
4253: hz_utility_pub.last_updated_by);
4254: END IF;
4255: CLOSE c_dup_to_ps;
4256: END IF;

Line 4253: hz_utility_pub.last_updated_by);

4249: hz_utility_pub.created_by,
4250: hz_utility_pub.creation_Date,
4251: hz_utility_pub.last_update_login,
4252: hz_utility_pub.last_update_date,
4253: hz_utility_pub.last_updated_by);
4254: END IF;
4255: CLOSE c_dup_to_ps;
4256: END IF;
4257: END LOOP;