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;
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;
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:
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||'#');
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||'#');
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)||'#');
625:
626:
627: -- Stamp concurrent request id to batch
628: UPDATE HZ_MERGE_BATCH
629: SET REQUEST_ID = hz_utility_pub.request_id
630: WHERE batch_id = p_batch_id;
631:
632: -- If not preview mode update batch status to COMPLETE
633: IF p_preview <> 'Y' then
1108:
1109:
1110: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED','BO_EVENTS_ENABLED')) THEN
1111:
1112: HZ_BES_BO_UTIL_PKG.upd_entity_ids(hz_utility_pub.request_id);
1113:
1114: END IF;
1115:
1116: -- Check if the whole batch was successfully executed
2203: SELECT h.from_entity_id, d.entity_name, d.pk_column_name
2204: FROM HZ_MERGE_PARTY_HISTORY h, HZ_MERGE_DICTIONARY d
2205: WHERE h.merge_dict_id = d.merge_dict_id
2206: AND h.batch_party_id = p_batch_party_id
2207: AND h.request_id = hz_utility_pub.request_id
2208: AND h.operation_type = 'Merge'
2209: ORDER BY h.merge_dict_id desc;
2210:
2211: l_record_id HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_ID%TYPE;
2614: last_update_date,
2615: last_updated_by)
2616: VALUES (
2617: H_batch_party_id(I),
2618: g_request_id, -- Bug No : 2998004 hz_utility_pub.request_id,
2619: H_from_id(I),
2620: H_to_id(I),
2621: H_from_fk_id(I),
2622: H_to_fk_id(I),
2623: H_from_desc(I),
2624: H_to_desc(I),
2625: H_merge_dict_id(I),
2626: H_op_type(I),
2627: g_created_by, -- hz_utility_pub.created_by,
2628: g_creation_date, -- hz_utility_pub.creation_date,
2629: g_last_update_login, -- hz_utility_pub.last_update_login,
2630: g_last_update_date, -- hz_utility_pub.last_update_date,
2631: g_user_id -- hz_utility_pub.user_id
2624: H_to_desc(I),
2625: H_merge_dict_id(I),
2626: H_op_type(I),
2627: g_created_by, -- hz_utility_pub.created_by,
2628: g_creation_date, -- hz_utility_pub.creation_date,
2629: g_last_update_login, -- hz_utility_pub.last_update_login,
2630: g_last_update_date, -- hz_utility_pub.last_update_date,
2631: g_user_id -- hz_utility_pub.user_id
2632: );
2625: H_merge_dict_id(I),
2626: H_op_type(I),
2627: g_created_by, -- hz_utility_pub.created_by,
2628: g_creation_date, -- hz_utility_pub.creation_date,
2629: g_last_update_login, -- hz_utility_pub.last_update_login,
2630: g_last_update_date, -- hz_utility_pub.last_update_date,
2631: g_user_id -- hz_utility_pub.user_id
2632: );
2633: H_Counter := 0;
2626: H_op_type(I),
2627: g_created_by, -- hz_utility_pub.created_by,
2628: g_creation_date, -- hz_utility_pub.creation_date,
2629: g_last_update_login, -- hz_utility_pub.last_update_login,
2630: g_last_update_date, -- hz_utility_pub.last_update_date,
2631: g_user_id -- hz_utility_pub.user_id
2632: );
2633: H_Counter := 0;
2634: END IF;
2627: g_created_by, -- hz_utility_pub.created_by,
2628: g_creation_date, -- hz_utility_pub.creation_date,
2629: g_last_update_login, -- hz_utility_pub.last_update_login,
2630: g_last_update_date, -- hz_utility_pub.last_update_date,
2631: g_user_id -- hz_utility_pub.user_id
2632: );
2633: H_Counter := 0;
2634: END IF;
2635: IF p_flush = 'Y' THEN
2714: last_update_date,
2715: last_updated_by)
2716: VALUES (
2717: I_batch_party_id(I),
2718: g_request_id, -- Bug No : 2998004 hz_utility_pub.request_id,
2719: I_from_id(I),
2720: I_to_id(I),
2721: I_from_fk_id(I),
2722: I_to_fk_id(I),
2724: I_to_desc(I),
2725: I_merge_dict_id(I),
2726: I_error(I),
2727: I_op_type(I),
2728: g_created_by, -- hz_utility_pub.created_by,
2729: g_creation_date, -- hz_utility_pub.creation_date,
2730: g_last_update_login, -- hz_utility_pub.last_update_login,
2731: g_last_update_date, -- hz_utility_pub.last_update_date,
2732: g_user_id -- hz_utility_pub.user_id
2725: I_merge_dict_id(I),
2726: I_error(I),
2727: I_op_type(I),
2728: g_created_by, -- hz_utility_pub.created_by,
2729: g_creation_date, -- hz_utility_pub.creation_date,
2730: g_last_update_login, -- hz_utility_pub.last_update_login,
2731: g_last_update_date, -- hz_utility_pub.last_update_date,
2732: g_user_id -- hz_utility_pub.user_id
2733: );
2726: I_error(I),
2727: I_op_type(I),
2728: g_created_by, -- hz_utility_pub.created_by,
2729: g_creation_date, -- hz_utility_pub.creation_date,
2730: g_last_update_login, -- hz_utility_pub.last_update_login,
2731: g_last_update_date, -- hz_utility_pub.last_update_date,
2732: g_user_id -- hz_utility_pub.user_id
2733: );
2734:
2727: I_op_type(I),
2728: g_created_by, -- hz_utility_pub.created_by,
2729: g_creation_date, -- hz_utility_pub.creation_date,
2730: g_last_update_login, -- hz_utility_pub.last_update_login,
2731: g_last_update_date, -- hz_utility_pub.last_update_date,
2732: g_user_id -- hz_utility_pub.user_id
2733: );
2734:
2735: I_Counter := 0;
2728: g_created_by, -- hz_utility_pub.created_by,
2729: g_creation_date, -- hz_utility_pub.creation_date,
2730: g_last_update_login, -- hz_utility_pub.last_update_login,
2731: g_last_update_date, -- hz_utility_pub.last_update_date,
2732: g_user_id -- hz_utility_pub.user_id
2733: );
2734:
2735: I_Counter := 0;
2736: -- Commit the log entry
2983: --the hz_merge_pkg.do_party_site_merge sets it to 'M' in pre-merge
2984: UPDATE HZ_PARTY_SITES
2985: SET
2986: STATUS = 'A',
2987: last_update_date = hz_utility_pub.last_update_date,
2988: last_updated_by = hz_utility_pub.user_id,
2989: last_update_login = hz_utility_pub.last_update_login,
2990: request_id = hz_utility_pub.request_id,
2991: program_application_id = hz_utility_pub.program_application_id,
2984: UPDATE HZ_PARTY_SITES
2985: SET
2986: STATUS = 'A',
2987: last_update_date = hz_utility_pub.last_update_date,
2988: last_updated_by = hz_utility_pub.user_id,
2989: last_update_login = hz_utility_pub.last_update_login,
2990: request_id = hz_utility_pub.request_id,
2991: program_application_id = hz_utility_pub.program_application_id,
2992: program_id = hz_utility_pub.program_id,
2985: SET
2986: STATUS = 'A',
2987: last_update_date = hz_utility_pub.last_update_date,
2988: last_updated_by = hz_utility_pub.user_id,
2989: last_update_login = hz_utility_pub.last_update_login,
2990: request_id = hz_utility_pub.request_id,
2991: program_application_id = hz_utility_pub.program_application_id,
2992: program_id = hz_utility_pub.program_id,
2993: program_update_date = sysdate
2986: STATUS = 'A',
2987: last_update_date = hz_utility_pub.last_update_date,
2988: last_updated_by = hz_utility_pub.user_id,
2989: last_update_login = hz_utility_pub.last_update_login,
2990: request_id = hz_utility_pub.request_id,
2991: program_application_id = hz_utility_pub.program_application_id,
2992: program_id = hz_utility_pub.program_id,
2993: program_update_date = sysdate
2994: WHERE party_site_id = l_merge_to_entity_id;
2987: last_update_date = hz_utility_pub.last_update_date,
2988: last_updated_by = hz_utility_pub.user_id,
2989: last_update_login = hz_utility_pub.last_update_login,
2990: request_id = hz_utility_pub.request_id,
2991: program_application_id = hz_utility_pub.program_application_id,
2992: program_id = hz_utility_pub.program_id,
2993: program_update_date = sysdate
2994: WHERE party_site_id = l_merge_to_entity_id;
2995:
2988: last_updated_by = hz_utility_pub.user_id,
2989: last_update_login = hz_utility_pub.last_update_login,
2990: request_id = hz_utility_pub.request_id,
2991: program_application_id = hz_utility_pub.program_application_id,
2992: program_id = hz_utility_pub.program_id,
2993: program_update_date = sysdate
2994: WHERE party_site_id = l_merge_to_entity_id;
2995:
2996:
3562: 'HZ_ORGANIZATION_PROFILES',
3563: l_from_profile_id,
3564: l_to_profile_id,
3565: 'Y',
3566: hz_utility_pub.created_by,
3567: hz_utility_pub.creation_Date,
3568: hz_utility_pub.last_update_login,
3569: hz_utility_pub.last_update_date,
3570: hz_utility_pub.last_updated_by);
3563: l_from_profile_id,
3564: l_to_profile_id,
3565: 'Y',
3566: hz_utility_pub.created_by,
3567: hz_utility_pub.creation_Date,
3568: hz_utility_pub.last_update_login,
3569: hz_utility_pub.last_update_date,
3570: hz_utility_pub.last_updated_by);
3571:
3564: l_to_profile_id,
3565: 'Y',
3566: hz_utility_pub.created_by,
3567: hz_utility_pub.creation_Date,
3568: hz_utility_pub.last_update_login,
3569: hz_utility_pub.last_update_date,
3570: hz_utility_pub.last_updated_by);
3571:
3572:
3565: 'Y',
3566: hz_utility_pub.created_by,
3567: hz_utility_pub.creation_Date,
3568: hz_utility_pub.last_update_login,
3569: hz_utility_pub.last_update_date,
3570: hz_utility_pub.last_updated_by);
3571:
3572:
3573:
3566: hz_utility_pub.created_by,
3567: hz_utility_pub.creation_Date,
3568: hz_utility_pub.last_update_login,
3569: hz_utility_pub.last_update_date,
3570: hz_utility_pub.last_updated_by);
3571:
3572:
3573:
3574: -- *******************************************
3579: IF case2 OR (case3 and l_to_is_branch<>'Y') THEN
3580: UPDATE HZ_PARTY_SITES ps
3581: SET STATUS = 'I',
3582: end_date_active = trunc(SYSDATE-1),
3583: last_update_date = hz_utility_pub.last_update_date,
3584: last_updated_by = hz_utility_pub.user_id,
3585: last_update_login = hz_utility_pub.last_update_login,
3586: request_id = hz_utility_pub.request_id,
3587: program_application_id = hz_utility_pub.program_application_id,
3580: UPDATE HZ_PARTY_SITES ps
3581: SET STATUS = 'I',
3582: end_date_active = trunc(SYSDATE-1),
3583: last_update_date = hz_utility_pub.last_update_date,
3584: last_updated_by = hz_utility_pub.user_id,
3585: last_update_login = hz_utility_pub.last_update_login,
3586: request_id = hz_utility_pub.request_id,
3587: program_application_id = hz_utility_pub.program_application_id,
3588: program_id = hz_utility_pub.program_id,
3581: SET STATUS = 'I',
3582: end_date_active = trunc(SYSDATE-1),
3583: last_update_date = hz_utility_pub.last_update_date,
3584: last_updated_by = hz_utility_pub.user_id,
3585: last_update_login = hz_utility_pub.last_update_login,
3586: request_id = hz_utility_pub.request_id,
3587: program_application_id = hz_utility_pub.program_application_id,
3588: program_id = hz_utility_pub.program_id,
3589: program_update_date = sysdate
3582: end_date_active = trunc(SYSDATE-1),
3583: last_update_date = hz_utility_pub.last_update_date,
3584: last_updated_by = hz_utility_pub.user_id,
3585: last_update_login = hz_utility_pub.last_update_login,
3586: request_id = hz_utility_pub.request_id,
3587: program_application_id = hz_utility_pub.program_application_id,
3588: program_id = hz_utility_pub.program_id,
3589: program_update_date = sysdate
3590: WHERE party_id= p_from_id
3583: last_update_date = hz_utility_pub.last_update_date,
3584: last_updated_by = hz_utility_pub.user_id,
3585: last_update_login = hz_utility_pub.last_update_login,
3586: request_id = hz_utility_pub.request_id,
3587: program_application_id = hz_utility_pub.program_application_id,
3588: program_id = hz_utility_pub.program_id,
3589: program_update_date = sysdate
3590: WHERE party_id= p_from_id
3591: AND actual_content_source = 'DNB'
3584: last_updated_by = hz_utility_pub.user_id,
3585: last_update_login = hz_utility_pub.last_update_login,
3586: request_id = hz_utility_pub.request_id,
3587: program_application_id = hz_utility_pub.program_application_id,
3588: program_id = hz_utility_pub.program_id,
3589: program_update_date = sysdate
3590: WHERE party_id= p_from_id
3591: AND actual_content_source = 'DNB'
3592: AND nvl(status,'A') = 'A';
3616: 'HZ_PARTY_SITES',
3617: l_to,
3618: FROM_PS.party_site_id,
3619: 'T',
3620: hz_utility_pub.created_by,
3621: hz_utility_pub.creation_Date,
3622: hz_utility_pub.last_update_login,
3623: hz_utility_pub.last_update_date,
3624: hz_utility_pub.last_updated_by);
3617: l_to,
3618: FROM_PS.party_site_id,
3619: 'T',
3620: hz_utility_pub.created_by,
3621: hz_utility_pub.creation_Date,
3622: hz_utility_pub.last_update_login,
3623: hz_utility_pub.last_update_date,
3624: hz_utility_pub.last_updated_by);
3625: ELSE
3618: FROM_PS.party_site_id,
3619: 'T',
3620: hz_utility_pub.created_by,
3621: hz_utility_pub.creation_Date,
3622: hz_utility_pub.last_update_login,
3623: hz_utility_pub.last_update_date,
3624: hz_utility_pub.last_updated_by);
3625: ELSE
3626: -- Do the exact comparison betn the from_dnb_ps and to_dnb ps.
3619: 'T',
3620: hz_utility_pub.created_by,
3621: hz_utility_pub.creation_Date,
3622: hz_utility_pub.last_update_login,
3623: hz_utility_pub.last_update_date,
3624: hz_utility_pub.last_updated_by);
3625: ELSE
3626: -- Do the exact comparison betn the from_dnb_ps and to_dnb ps.
3627: -- If exactly same: merge to into from
3620: hz_utility_pub.created_by,
3621: hz_utility_pub.creation_Date,
3622: hz_utility_pub.last_update_login,
3623: hz_utility_pub.last_update_date,
3624: hz_utility_pub.last_updated_by);
3625: ELSE
3626: -- Do the exact comparison betn the from_dnb_ps and to_dnb ps.
3627: -- If exactly same: merge to into from
3628: BEGIN
3665: 'HZ_PARTY_SITES',
3666: l_to,
3667: FROM_PS.party_site_id,
3668: 'T',
3669: hz_utility_pub.created_by,
3670: hz_utility_pub.creation_Date,
3671: hz_utility_pub.last_update_login,
3672: hz_utility_pub.last_update_date,
3673: hz_utility_pub.last_updated_by);
3666: l_to,
3667: FROM_PS.party_site_id,
3668: 'T',
3669: hz_utility_pub.created_by,
3670: hz_utility_pub.creation_Date,
3671: hz_utility_pub.last_update_login,
3672: hz_utility_pub.last_update_date,
3673: hz_utility_pub.last_updated_by);
3674: ELSE
3667: FROM_PS.party_site_id,
3668: 'T',
3669: hz_utility_pub.created_by,
3670: hz_utility_pub.creation_Date,
3671: hz_utility_pub.last_update_login,
3672: hz_utility_pub.last_update_date,
3673: hz_utility_pub.last_updated_by);
3674: ELSE
3675: UPDATE HZ_PARTY_SITES
3668: 'T',
3669: hz_utility_pub.created_by,
3670: hz_utility_pub.creation_Date,
3671: hz_utility_pub.last_update_login,
3672: hz_utility_pub.last_update_date,
3673: hz_utility_pub.last_updated_by);
3674: ELSE
3675: UPDATE HZ_PARTY_SITES
3676: SET actual_content_source = 'USER_ENTERED',
3669: hz_utility_pub.created_by,
3670: hz_utility_pub.creation_Date,
3671: hz_utility_pub.last_update_login,
3672: hz_utility_pub.last_update_date,
3673: hz_utility_pub.last_updated_by);
3674: ELSE
3675: UPDATE HZ_PARTY_SITES
3676: SET actual_content_source = 'USER_ENTERED',
3677: last_update_date = hz_utility_pub.last_update_date,
3673: hz_utility_pub.last_updated_by);
3674: ELSE
3675: UPDATE HZ_PARTY_SITES
3676: SET actual_content_source = 'USER_ENTERED',
3677: last_update_date = hz_utility_pub.last_update_date,
3678: last_updated_by = hz_utility_pub.user_id,
3679: last_update_login = hz_utility_pub.last_update_login,
3680: request_id = hz_utility_pub.request_id,
3681: program_application_id = hz_utility_pub.program_application_id,
3674: ELSE
3675: UPDATE HZ_PARTY_SITES
3676: SET actual_content_source = 'USER_ENTERED',
3677: last_update_date = hz_utility_pub.last_update_date,
3678: last_updated_by = hz_utility_pub.user_id,
3679: last_update_login = hz_utility_pub.last_update_login,
3680: request_id = hz_utility_pub.request_id,
3681: program_application_id = hz_utility_pub.program_application_id,
3682: program_id = hz_utility_pub.program_id,
3675: UPDATE HZ_PARTY_SITES
3676: SET actual_content_source = 'USER_ENTERED',
3677: last_update_date = hz_utility_pub.last_update_date,
3678: last_updated_by = hz_utility_pub.user_id,
3679: last_update_login = hz_utility_pub.last_update_login,
3680: request_id = hz_utility_pub.request_id,
3681: program_application_id = hz_utility_pub.program_application_id,
3682: program_id = hz_utility_pub.program_id,
3683: program_update_date = sysdate
3676: SET actual_content_source = 'USER_ENTERED',
3677: last_update_date = hz_utility_pub.last_update_date,
3678: last_updated_by = hz_utility_pub.user_id,
3679: last_update_login = hz_utility_pub.last_update_login,
3680: request_id = hz_utility_pub.request_id,
3681: program_application_id = hz_utility_pub.program_application_id,
3682: program_id = hz_utility_pub.program_id,
3683: program_update_date = sysdate
3684: WHERE party_site_id = l_to;
3677: last_update_date = hz_utility_pub.last_update_date,
3678: last_updated_by = hz_utility_pub.user_id,
3679: last_update_login = hz_utility_pub.last_update_login,
3680: request_id = hz_utility_pub.request_id,
3681: program_application_id = hz_utility_pub.program_application_id,
3682: program_id = hz_utility_pub.program_id,
3683: program_update_date = sysdate
3684: WHERE party_site_id = l_to;
3685: ----Inactivating SSM Record
3678: last_updated_by = hz_utility_pub.user_id,
3679: last_update_login = hz_utility_pub.last_update_login,
3680: request_id = hz_utility_pub.request_id,
3681: program_application_id = hz_utility_pub.program_application_id,
3682: program_id = hz_utility_pub.program_id,
3683: program_update_date = sysdate
3684: WHERE party_site_id = l_to;
3685: ----Inactivating SSM Record
3686: UPDATE HZ_ORIG_SYS_REFERENCES
3685: ----Inactivating SSM Record
3686: UPDATE HZ_ORIG_SYS_REFERENCES
3687: SET STATUS = 'I',
3688: END_DATE_ACTIVE =trunc(SYSDATE-1),
3689: last_update_date = hz_utility_pub.last_update_date,
3690: last_updated_by = hz_utility_pub.user_id,
3691: last_update_login = hz_utility_pub.last_update_login,
3692: request_id = hz_utility_pub.request_id,
3693: program_application_id = hz_utility_pub.program_application_id,
3686: UPDATE HZ_ORIG_SYS_REFERENCES
3687: SET STATUS = 'I',
3688: END_DATE_ACTIVE =trunc(SYSDATE-1),
3689: last_update_date = hz_utility_pub.last_update_date,
3690: last_updated_by = hz_utility_pub.user_id,
3691: last_update_login = hz_utility_pub.last_update_login,
3692: request_id = hz_utility_pub.request_id,
3693: program_application_id = hz_utility_pub.program_application_id,
3694: program_id = hz_utility_pub.program_id,
3687: SET STATUS = 'I',
3688: END_DATE_ACTIVE =trunc(SYSDATE-1),
3689: last_update_date = hz_utility_pub.last_update_date,
3690: last_updated_by = hz_utility_pub.user_id,
3691: last_update_login = hz_utility_pub.last_update_login,
3692: request_id = hz_utility_pub.request_id,
3693: program_application_id = hz_utility_pub.program_application_id,
3694: program_id = hz_utility_pub.program_id,
3695: program_update_date = sysdate
3688: END_DATE_ACTIVE =trunc(SYSDATE-1),
3689: last_update_date = hz_utility_pub.last_update_date,
3690: last_updated_by = hz_utility_pub.user_id,
3691: last_update_login = hz_utility_pub.last_update_login,
3692: request_id = hz_utility_pub.request_id,
3693: program_application_id = hz_utility_pub.program_application_id,
3694: program_id = hz_utility_pub.program_id,
3695: program_update_date = sysdate
3696: WHERE OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
3689: last_update_date = hz_utility_pub.last_update_date,
3690: last_updated_by = hz_utility_pub.user_id,
3691: last_update_login = hz_utility_pub.last_update_login,
3692: request_id = hz_utility_pub.request_id,
3693: program_application_id = hz_utility_pub.program_application_id,
3694: program_id = hz_utility_pub.program_id,
3695: program_update_date = sysdate
3696: WHERE OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
3697: AND OWNER_TABLE_ID = l_to
3690: last_updated_by = hz_utility_pub.user_id,
3691: last_update_login = hz_utility_pub.last_update_login,
3692: request_id = hz_utility_pub.request_id,
3693: program_application_id = hz_utility_pub.program_application_id,
3694: program_id = hz_utility_pub.program_id,
3695: program_update_date = sysdate
3696: WHERE OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
3697: AND OWNER_TABLE_ID = l_to
3698: AND ORIG_SYSTEM = 'DNB'
3704: -- Inactivate to_ps
3705: /*UPDATE HZ_PARTY_SITES
3706: SET status = 'I',
3707: end_date_active=trunc(SYSDATE-1),
3708: last_update_date = hz_utility_pub.last_update_date,
3709: last_updated_by = hz_utility_pub.user_id,
3710: last_update_login = hz_utility_pub.last_update_login,
3711: request_id = hz_utility_pub.request_id,
3712: program_application_id = hz_utility_pub.program_application_id,
3705: /*UPDATE HZ_PARTY_SITES
3706: SET status = 'I',
3707: end_date_active=trunc(SYSDATE-1),
3708: last_update_date = hz_utility_pub.last_update_date,
3709: last_updated_by = hz_utility_pub.user_id,
3710: last_update_login = hz_utility_pub.last_update_login,
3711: request_id = hz_utility_pub.request_id,
3712: program_application_id = hz_utility_pub.program_application_id,
3713: program_id = hz_utility_pub.program_id,
3706: SET status = 'I',
3707: end_date_active=trunc(SYSDATE-1),
3708: last_update_date = hz_utility_pub.last_update_date,
3709: last_updated_by = hz_utility_pub.user_id,
3710: last_update_login = hz_utility_pub.last_update_login,
3711: request_id = hz_utility_pub.request_id,
3712: program_application_id = hz_utility_pub.program_application_id,
3713: program_id = hz_utility_pub.program_id,
3714: program_update_date = sysdate
3707: end_date_active=trunc(SYSDATE-1),
3708: last_update_date = hz_utility_pub.last_update_date,
3709: last_updated_by = hz_utility_pub.user_id,
3710: last_update_login = hz_utility_pub.last_update_login,
3711: request_id = hz_utility_pub.request_id,
3712: program_application_id = hz_utility_pub.program_application_id,
3713: program_id = hz_utility_pub.program_id,
3714: program_update_date = sysdate
3715: WHERE party_site_id = l_to;*/
3708: last_update_date = hz_utility_pub.last_update_date,
3709: last_updated_by = hz_utility_pub.user_id,
3710: last_update_login = hz_utility_pub.last_update_login,
3711: request_id = hz_utility_pub.request_id,
3712: program_application_id = hz_utility_pub.program_application_id,
3713: program_id = hz_utility_pub.program_id,
3714: program_update_date = sysdate
3715: WHERE party_site_id = l_to;*/
3716:
3709: last_updated_by = hz_utility_pub.user_id,
3710: last_update_login = hz_utility_pub.last_update_login,
3711: request_id = hz_utility_pub.request_id,
3712: program_application_id = hz_utility_pub.program_application_id,
3713: program_id = hz_utility_pub.program_id,
3714: program_update_date = sysdate
3715: WHERE party_site_id = l_to;*/
3716:
3717: -- Transfer From_ps
3770: 'HZ_PARTY_SITES',
3771: FROM_PS.party_site_id,
3772: l_to,
3773: 'Y',
3774: hz_utility_pub.created_by,
3775: hz_utility_pub.creation_Date,
3776: hz_utility_pub.last_update_login,
3777: hz_utility_pub.last_update_date,
3778: hz_utility_pub.last_updated_by);
3771: FROM_PS.party_site_id,
3772: l_to,
3773: 'Y',
3774: hz_utility_pub.created_by,
3775: hz_utility_pub.creation_Date,
3776: hz_utility_pub.last_update_login,
3777: hz_utility_pub.last_update_date,
3778: hz_utility_pub.last_updated_by);
3779: ELSE
3772: l_to,
3773: 'Y',
3774: hz_utility_pub.created_by,
3775: hz_utility_pub.creation_Date,
3776: hz_utility_pub.last_update_login,
3777: hz_utility_pub.last_update_date,
3778: hz_utility_pub.last_updated_by);
3779: ELSE
3780: ---Activate the from party site(which we previously inactivated) and change the content source to USER_ENTERED.
3773: 'Y',
3774: hz_utility_pub.created_by,
3775: hz_utility_pub.creation_Date,
3776: hz_utility_pub.last_update_login,
3777: hz_utility_pub.last_update_date,
3778: hz_utility_pub.last_updated_by);
3779: ELSE
3780: ---Activate the from party site(which we previously inactivated) and change the content source to USER_ENTERED.
3781: UPDATE HZ_PARTY_SITES
3774: hz_utility_pub.created_by,
3775: hz_utility_pub.creation_Date,
3776: hz_utility_pub.last_update_login,
3777: hz_utility_pub.last_update_date,
3778: hz_utility_pub.last_updated_by);
3779: ELSE
3780: ---Activate the from party site(which we previously inactivated) and change the content source to USER_ENTERED.
3781: UPDATE HZ_PARTY_SITES
3782: SET status = 'A',
3780: ---Activate the from party site(which we previously inactivated) and change the content source to USER_ENTERED.
3781: UPDATE HZ_PARTY_SITES
3782: SET status = 'A',
3783: end_date_active = NULL,
3784: last_update_date = hz_utility_pub.last_update_date,
3785: last_updated_by = hz_utility_pub.user_id,
3786: last_update_login = hz_utility_pub.last_update_login,
3787: request_id = hz_utility_pub.request_id,
3788: program_application_id = hz_utility_pub.program_application_id,
3781: UPDATE HZ_PARTY_SITES
3782: SET status = 'A',
3783: end_date_active = NULL,
3784: last_update_date = hz_utility_pub.last_update_date,
3785: last_updated_by = hz_utility_pub.user_id,
3786: last_update_login = hz_utility_pub.last_update_login,
3787: request_id = hz_utility_pub.request_id,
3788: program_application_id = hz_utility_pub.program_application_id,
3789: program_id = hz_utility_pub.program_id,
3782: SET status = 'A',
3783: end_date_active = NULL,
3784: last_update_date = hz_utility_pub.last_update_date,
3785: last_updated_by = hz_utility_pub.user_id,
3786: last_update_login = hz_utility_pub.last_update_login,
3787: request_id = hz_utility_pub.request_id,
3788: program_application_id = hz_utility_pub.program_application_id,
3789: program_id = hz_utility_pub.program_id,
3790: program_update_date = sysdate
3783: end_date_active = NULL,
3784: last_update_date = hz_utility_pub.last_update_date,
3785: last_updated_by = hz_utility_pub.user_id,
3786: last_update_login = hz_utility_pub.last_update_login,
3787: request_id = hz_utility_pub.request_id,
3788: program_application_id = hz_utility_pub.program_application_id,
3789: program_id = hz_utility_pub.program_id,
3790: program_update_date = sysdate
3791: WHERE request_id = hz_utility_pub.request_id;
3784: last_update_date = hz_utility_pub.last_update_date,
3785: last_updated_by = hz_utility_pub.user_id,
3786: last_update_login = hz_utility_pub.last_update_login,
3787: request_id = hz_utility_pub.request_id,
3788: program_application_id = hz_utility_pub.program_application_id,
3789: program_id = hz_utility_pub.program_id,
3790: program_update_date = sysdate
3791: WHERE request_id = hz_utility_pub.request_id;
3792:
3785: last_updated_by = hz_utility_pub.user_id,
3786: last_update_login = hz_utility_pub.last_update_login,
3787: request_id = hz_utility_pub.request_id,
3788: program_application_id = hz_utility_pub.program_application_id,
3789: program_id = hz_utility_pub.program_id,
3790: program_update_date = sysdate
3791: WHERE request_id = hz_utility_pub.request_id;
3792:
3793: UPDATE HZ_PARTY_SITES
3787: request_id = hz_utility_pub.request_id,
3788: program_application_id = hz_utility_pub.program_application_id,
3789: program_id = hz_utility_pub.program_id,
3790: program_update_date = sysdate
3791: WHERE request_id = hz_utility_pub.request_id;
3792:
3793: UPDATE HZ_PARTY_SITES
3794: SET actual_content_source = 'USER_ENTERED',
3795: last_update_date = hz_utility_pub.last_update_date,
3791: WHERE request_id = hz_utility_pub.request_id;
3792:
3793: UPDATE HZ_PARTY_SITES
3794: SET actual_content_source = 'USER_ENTERED',
3795: last_update_date = hz_utility_pub.last_update_date,
3796: last_updated_by = hz_utility_pub.user_id,
3797: last_update_login = hz_utility_pub.last_update_login,
3798: request_id = hz_utility_pub.request_id,
3799: program_application_id = hz_utility_pub.program_application_id,
3792:
3793: UPDATE HZ_PARTY_SITES
3794: SET actual_content_source = 'USER_ENTERED',
3795: last_update_date = hz_utility_pub.last_update_date,
3796: last_updated_by = hz_utility_pub.user_id,
3797: last_update_login = hz_utility_pub.last_update_login,
3798: request_id = hz_utility_pub.request_id,
3799: program_application_id = hz_utility_pub.program_application_id,
3800: program_id = hz_utility_pub.program_id,
3793: UPDATE HZ_PARTY_SITES
3794: SET actual_content_source = 'USER_ENTERED',
3795: last_update_date = hz_utility_pub.last_update_date,
3796: last_updated_by = hz_utility_pub.user_id,
3797: last_update_login = hz_utility_pub.last_update_login,
3798: request_id = hz_utility_pub.request_id,
3799: program_application_id = hz_utility_pub.program_application_id,
3800: program_id = hz_utility_pub.program_id,
3801: program_update_date = sysdate
3794: SET actual_content_source = 'USER_ENTERED',
3795: last_update_date = hz_utility_pub.last_update_date,
3796: last_updated_by = hz_utility_pub.user_id,
3797: last_update_login = hz_utility_pub.last_update_login,
3798: request_id = hz_utility_pub.request_id,
3799: program_application_id = hz_utility_pub.program_application_id,
3800: program_id = hz_utility_pub.program_id,
3801: program_update_date = sysdate
3802: WHERE party_site_id =FROM_PS.party_site_id ;
3795: last_update_date = hz_utility_pub.last_update_date,
3796: last_updated_by = hz_utility_pub.user_id,
3797: last_update_login = hz_utility_pub.last_update_login,
3798: request_id = hz_utility_pub.request_id,
3799: program_application_id = hz_utility_pub.program_application_id,
3800: program_id = hz_utility_pub.program_id,
3801: program_update_date = sysdate
3802: WHERE party_site_id =FROM_PS.party_site_id ;
3803:
3796: last_updated_by = hz_utility_pub.user_id,
3797: last_update_login = hz_utility_pub.last_update_login,
3798: request_id = hz_utility_pub.request_id,
3799: program_application_id = hz_utility_pub.program_application_id,
3800: program_id = hz_utility_pub.program_id,
3801: program_update_date = sysdate
3802: WHERE party_site_id =FROM_PS.party_site_id ;
3803:
3804: ----Inactivating SSM Record
3804: ----Inactivating SSM Record
3805: UPDATE HZ_ORIG_SYS_REFERENCES
3806: SET STATUS = 'I',
3807: END_DATE_ACTIVE =trunc(SYSDATE-1),
3808: last_update_date = hz_utility_pub.last_update_date,
3809: last_updated_by = hz_utility_pub.user_id,
3810: last_update_login = hz_utility_pub.last_update_login,
3811: request_id = hz_utility_pub.request_id,
3812: program_application_id = hz_utility_pub.program_application_id,
3805: UPDATE HZ_ORIG_SYS_REFERENCES
3806: SET STATUS = 'I',
3807: END_DATE_ACTIVE =trunc(SYSDATE-1),
3808: last_update_date = hz_utility_pub.last_update_date,
3809: last_updated_by = hz_utility_pub.user_id,
3810: last_update_login = hz_utility_pub.last_update_login,
3811: request_id = hz_utility_pub.request_id,
3812: program_application_id = hz_utility_pub.program_application_id,
3813: program_id = hz_utility_pub.program_id,
3806: SET STATUS = 'I',
3807: END_DATE_ACTIVE =trunc(SYSDATE-1),
3808: last_update_date = hz_utility_pub.last_update_date,
3809: last_updated_by = hz_utility_pub.user_id,
3810: last_update_login = hz_utility_pub.last_update_login,
3811: request_id = hz_utility_pub.request_id,
3812: program_application_id = hz_utility_pub.program_application_id,
3813: program_id = hz_utility_pub.program_id,
3814: program_update_date = sysdate
3807: END_DATE_ACTIVE =trunc(SYSDATE-1),
3808: last_update_date = hz_utility_pub.last_update_date,
3809: last_updated_by = hz_utility_pub.user_id,
3810: last_update_login = hz_utility_pub.last_update_login,
3811: request_id = hz_utility_pub.request_id,
3812: program_application_id = hz_utility_pub.program_application_id,
3813: program_id = hz_utility_pub.program_id,
3814: program_update_date = sysdate
3815: WHERE OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
3808: last_update_date = hz_utility_pub.last_update_date,
3809: last_updated_by = hz_utility_pub.user_id,
3810: last_update_login = hz_utility_pub.last_update_login,
3811: request_id = hz_utility_pub.request_id,
3812: program_application_id = hz_utility_pub.program_application_id,
3813: program_id = hz_utility_pub.program_id,
3814: program_update_date = sysdate
3815: WHERE OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
3816: AND OWNER_TABLE_ID =FROM_PS.party_site_id
3809: last_updated_by = hz_utility_pub.user_id,
3810: last_update_login = hz_utility_pub.last_update_login,
3811: request_id = hz_utility_pub.request_id,
3812: program_application_id = hz_utility_pub.program_application_id,
3813: program_id = hz_utility_pub.program_id,
3814: program_update_date = sysdate
3815: WHERE OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
3816: AND OWNER_TABLE_ID =FROM_PS.party_site_id
3817: AND ORIG_SYSTEM = 'DNB'
3871: l_rel_to_party_id,
3872: FROM_REL.PARTY_ID,
3873: 'DUPLICATE_RELN_PARTY',
3874: 'PENDING',
3875: HZ_UTILITY_PUB.CREATED_BY,
3876: HZ_UTILITY_PUB.CREATION_DATE,
3877: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
3878: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
3879: HZ_UTILITY_PUB.LAST_UPDATED_BY);
3872: FROM_REL.PARTY_ID,
3873: 'DUPLICATE_RELN_PARTY',
3874: 'PENDING',
3875: HZ_UTILITY_PUB.CREATED_BY,
3876: HZ_UTILITY_PUB.CREATION_DATE,
3877: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
3878: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
3879: HZ_UTILITY_PUB.LAST_UPDATED_BY);
3880:
3873: 'DUPLICATE_RELN_PARTY',
3874: 'PENDING',
3875: HZ_UTILITY_PUB.CREATED_BY,
3876: HZ_UTILITY_PUB.CREATION_DATE,
3877: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
3878: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
3879: HZ_UTILITY_PUB.LAST_UPDATED_BY);
3880:
3881: insert_party_site_details(l_rel_to_party_id,FROM_REL.PARTY_ID,
3874: 'PENDING',
3875: HZ_UTILITY_PUB.CREATED_BY,
3876: HZ_UTILITY_PUB.CREATION_DATE,
3877: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
3878: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
3879: HZ_UTILITY_PUB.LAST_UPDATED_BY);
3880:
3881: insert_party_site_details(l_rel_to_party_id,FROM_REL.PARTY_ID,
3882: l_batch_party_id);
3875: HZ_UTILITY_PUB.CREATED_BY,
3876: HZ_UTILITY_PUB.CREATION_DATE,
3877: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
3878: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
3879: HZ_UTILITY_PUB.LAST_UPDATED_BY);
3880:
3881: insert_party_site_details(l_rel_to_party_id,FROM_REL.PARTY_ID,
3882: l_batch_party_id);
3883: ---Bug No. 5349866
3886: 'HZ_PARTY_RELATIONSHIPS',
3887: l_to,
3888: FROM_REL.relationship_id,
3889: 'T',
3890: hz_utility_pub.created_by,
3891: hz_utility_pub.creation_Date,
3892: hz_utility_pub.last_update_login,
3893: hz_utility_pub.last_update_date,
3894: hz_utility_pub.last_updated_by);
3887: l_to,
3888: FROM_REL.relationship_id,
3889: 'T',
3890: hz_utility_pub.created_by,
3891: hz_utility_pub.creation_Date,
3892: hz_utility_pub.last_update_login,
3893: hz_utility_pub.last_update_date,
3894: hz_utility_pub.last_updated_by);
3895: --Bug No. 5349866
3888: FROM_REL.relationship_id,
3889: 'T',
3890: hz_utility_pub.created_by,
3891: hz_utility_pub.creation_Date,
3892: hz_utility_pub.last_update_login,
3893: hz_utility_pub.last_update_date,
3894: hz_utility_pub.last_updated_by);
3895: --Bug No. 5349866
3896: ELSE
3889: 'T',
3890: hz_utility_pub.created_by,
3891: hz_utility_pub.creation_Date,
3892: hz_utility_pub.last_update_login,
3893: hz_utility_pub.last_update_date,
3894: hz_utility_pub.last_updated_by);
3895: --Bug No. 5349866
3896: ELSE
3897: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3890: hz_utility_pub.created_by,
3891: hz_utility_pub.creation_Date,
3892: hz_utility_pub.last_update_login,
3893: hz_utility_pub.last_update_date,
3894: hz_utility_pub.last_updated_by);
3895: --Bug No. 5349866
3896: ELSE
3897: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3898: p_batch_party_id,
3899: 'HZ_PARTY_RELATIONSHIPS',
3900: l_to,
3901: FROM_REL.relationship_id,
3902: 'T',
3903: hz_utility_pub.created_by,
3904: hz_utility_pub.creation_Date,
3905: hz_utility_pub.last_update_login,
3906: hz_utility_pub.last_update_date,
3907: hz_utility_pub.last_updated_by);
3900: l_to,
3901: FROM_REL.relationship_id,
3902: 'T',
3903: hz_utility_pub.created_by,
3904: hz_utility_pub.creation_Date,
3905: hz_utility_pub.last_update_login,
3906: hz_utility_pub.last_update_date,
3907: hz_utility_pub.last_updated_by);
3908: END IF;
3901: FROM_REL.relationship_id,
3902: 'T',
3903: hz_utility_pub.created_by,
3904: hz_utility_pub.creation_Date,
3905: hz_utility_pub.last_update_login,
3906: hz_utility_pub.last_update_date,
3907: hz_utility_pub.last_updated_by);
3908: END IF;
3909:
3902: 'T',
3903: hz_utility_pub.created_by,
3904: hz_utility_pub.creation_Date,
3905: hz_utility_pub.last_update_login,
3906: hz_utility_pub.last_update_date,
3907: hz_utility_pub.last_updated_by);
3908: END IF;
3909:
3910: ELSE -- To Newer
3903: hz_utility_pub.created_by,
3904: hz_utility_pub.creation_Date,
3905: hz_utility_pub.last_update_login,
3906: hz_utility_pub.last_update_date,
3907: hz_utility_pub.last_updated_by);
3908: END IF;
3909:
3910: ELSE -- To Newer
3911: -- Merge from into to
3927: FROM_REL.PARTY_ID,
3928: l_rel_to_party_id,
3929: 'DUPLICATE_RELN_PARTY',
3930: 'PENDING',
3931: HZ_UTILITY_PUB.CREATED_BY,
3932: HZ_UTILITY_PUB.CREATION_DATE,
3933: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
3934: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
3935: HZ_UTILITY_PUB.LAST_UPDATED_BY);
3928: l_rel_to_party_id,
3929: 'DUPLICATE_RELN_PARTY',
3930: 'PENDING',
3931: HZ_UTILITY_PUB.CREATED_BY,
3932: HZ_UTILITY_PUB.CREATION_DATE,
3933: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
3934: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
3935: HZ_UTILITY_PUB.LAST_UPDATED_BY);
3936:
3929: 'DUPLICATE_RELN_PARTY',
3930: 'PENDING',
3931: HZ_UTILITY_PUB.CREATED_BY,
3932: HZ_UTILITY_PUB.CREATION_DATE,
3933: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
3934: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
3935: HZ_UTILITY_PUB.LAST_UPDATED_BY);
3936:
3937: insert_party_site_details(FROM_REL.PARTY_ID,
3930: 'PENDING',
3931: HZ_UTILITY_PUB.CREATED_BY,
3932: HZ_UTILITY_PUB.CREATION_DATE,
3933: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
3934: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
3935: HZ_UTILITY_PUB.LAST_UPDATED_BY);
3936:
3937: insert_party_site_details(FROM_REL.PARTY_ID,
3938: l_rel_to_party_id,
3931: HZ_UTILITY_PUB.CREATED_BY,
3932: HZ_UTILITY_PUB.CREATION_DATE,
3933: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
3934: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
3935: HZ_UTILITY_PUB.LAST_UPDATED_BY);
3936:
3937: insert_party_site_details(FROM_REL.PARTY_ID,
3938: l_rel_to_party_id,
3939: l_batch_party_id);
3943: 'HZ_PARTY_RELATIONSHIPS',
3944: FROM_REL.relationship_id,
3945: l_to,
3946: 'Y',
3947: hz_utility_pub.created_by,
3948: hz_utility_pub.creation_Date,
3949: hz_utility_pub.last_update_login,
3950: hz_utility_pub.last_update_date,
3951: hz_utility_pub.last_updated_by);
3944: FROM_REL.relationship_id,
3945: l_to,
3946: 'Y',
3947: hz_utility_pub.created_by,
3948: hz_utility_pub.creation_Date,
3949: hz_utility_pub.last_update_login,
3950: hz_utility_pub.last_update_date,
3951: hz_utility_pub.last_updated_by);
3952: --bug 5349866
3945: l_to,
3946: 'Y',
3947: hz_utility_pub.created_by,
3948: hz_utility_pub.creation_Date,
3949: hz_utility_pub.last_update_login,
3950: hz_utility_pub.last_update_date,
3951: hz_utility_pub.last_updated_by);
3952: --bug 5349866
3953: ELSE
3946: 'Y',
3947: hz_utility_pub.created_by,
3948: hz_utility_pub.creation_Date,
3949: hz_utility_pub.last_update_login,
3950: hz_utility_pub.last_update_date,
3951: hz_utility_pub.last_updated_by);
3952: --bug 5349866
3953: ELSE
3954:
3947: hz_utility_pub.created_by,
3948: hz_utility_pub.creation_Date,
3949: hz_utility_pub.last_update_login,
3950: hz_utility_pub.last_update_date,
3951: hz_utility_pub.last_updated_by);
3952: --bug 5349866
3953: ELSE
3954:
3955: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3957: 'HZ_PARTY_RELATIONSHIPS',
3958: FROM_REL.relationship_id,
3959: l_to,
3960: 'Y',
3961: hz_utility_pub.created_by,
3962: hz_utility_pub.creation_Date,
3963: hz_utility_pub.last_update_login,
3964: hz_utility_pub.last_update_date,
3965: hz_utility_pub.last_updated_by);
3958: FROM_REL.relationship_id,
3959: l_to,
3960: 'Y',
3961: hz_utility_pub.created_by,
3962: hz_utility_pub.creation_Date,
3963: hz_utility_pub.last_update_login,
3964: hz_utility_pub.last_update_date,
3965: hz_utility_pub.last_updated_by);
3966: END IF;
3959: l_to,
3960: 'Y',
3961: hz_utility_pub.created_by,
3962: hz_utility_pub.creation_Date,
3963: hz_utility_pub.last_update_login,
3964: hz_utility_pub.last_update_date,
3965: hz_utility_pub.last_updated_by);
3966: END IF;
3967: END IF;
3960: 'Y',
3961: hz_utility_pub.created_by,
3962: hz_utility_pub.creation_Date,
3963: hz_utility_pub.last_update_login,
3964: hz_utility_pub.last_update_date,
3965: hz_utility_pub.last_updated_by);
3966: END IF;
3967: END IF;
3968:
3961: hz_utility_pub.created_by,
3962: hz_utility_pub.creation_Date,
3963: hz_utility_pub.last_update_login,
3964: hz_utility_pub.last_update_date,
3965: hz_utility_pub.last_updated_by);
3966: END IF;
3967: END IF;
3968:
3969: ELSE
3973: --Instead of updating the status to 'I'and end_date to SYSDATE
3974: -- Updating the Actual content source to UE.
3975: UPDATE HZ_RELATIONSHIPS
3976: SET actual_content_source = 'USER_ENTERED',
3977: last_update_date = hz_utility_pub.last_update_date,
3978: last_updated_by = hz_utility_pub.user_id,
3979: last_update_login = hz_utility_pub.last_update_login,
3980: request_id = hz_utility_pub.request_id,
3981: program_application_id = hz_utility_pub.program_application_id,
3974: -- Updating the Actual content source to UE.
3975: UPDATE HZ_RELATIONSHIPS
3976: SET actual_content_source = 'USER_ENTERED',
3977: last_update_date = hz_utility_pub.last_update_date,
3978: last_updated_by = hz_utility_pub.user_id,
3979: last_update_login = hz_utility_pub.last_update_login,
3980: request_id = hz_utility_pub.request_id,
3981: program_application_id = hz_utility_pub.program_application_id,
3982: program_id = hz_utility_pub.program_id,
3975: UPDATE HZ_RELATIONSHIPS
3976: SET actual_content_source = 'USER_ENTERED',
3977: last_update_date = hz_utility_pub.last_update_date,
3978: last_updated_by = hz_utility_pub.user_id,
3979: last_update_login = hz_utility_pub.last_update_login,
3980: request_id = hz_utility_pub.request_id,
3981: program_application_id = hz_utility_pub.program_application_id,
3982: program_id = hz_utility_pub.program_id,
3983: program_update_date = sysdate
3976: SET actual_content_source = 'USER_ENTERED',
3977: last_update_date = hz_utility_pub.last_update_date,
3978: last_updated_by = hz_utility_pub.user_id,
3979: last_update_login = hz_utility_pub.last_update_login,
3980: request_id = hz_utility_pub.request_id,
3981: program_application_id = hz_utility_pub.program_application_id,
3982: program_id = hz_utility_pub.program_id,
3983: program_update_date = sysdate
3984: WHERE relationship_id = l_to;
3977: last_update_date = hz_utility_pub.last_update_date,
3978: last_updated_by = hz_utility_pub.user_id,
3979: last_update_login = hz_utility_pub.last_update_login,
3980: request_id = hz_utility_pub.request_id,
3981: program_application_id = hz_utility_pub.program_application_id,
3982: program_id = hz_utility_pub.program_id,
3983: program_update_date = sysdate
3984: WHERE relationship_id = l_to;
3985: ----Inactivating SSM Record
3978: last_updated_by = hz_utility_pub.user_id,
3979: last_update_login = hz_utility_pub.last_update_login,
3980: request_id = hz_utility_pub.request_id,
3981: program_application_id = hz_utility_pub.program_application_id,
3982: program_id = hz_utility_pub.program_id,
3983: program_update_date = sysdate
3984: WHERE relationship_id = l_to;
3985: ----Inactivating SSM Record
3986: UPDATE HZ_ORIG_SYS_REFERENCES
3985: ----Inactivating SSM Record
3986: UPDATE HZ_ORIG_SYS_REFERENCES
3987: SET STATUS = 'I',
3988: END_DATE_ACTIVE =trunc(SYSDATE-1),
3989: last_update_date = hz_utility_pub.last_update_date,
3990: last_updated_by = hz_utility_pub.user_id,
3991: last_update_login = hz_utility_pub.last_update_login,
3992: request_id = hz_utility_pub.request_id,
3993: program_application_id = hz_utility_pub.program_application_id,
3986: UPDATE HZ_ORIG_SYS_REFERENCES
3987: SET STATUS = 'I',
3988: END_DATE_ACTIVE =trunc(SYSDATE-1),
3989: last_update_date = hz_utility_pub.last_update_date,
3990: last_updated_by = hz_utility_pub.user_id,
3991: last_update_login = hz_utility_pub.last_update_login,
3992: request_id = hz_utility_pub.request_id,
3993: program_application_id = hz_utility_pub.program_application_id,
3994: program_id = hz_utility_pub.program_id,
3987: SET STATUS = 'I',
3988: END_DATE_ACTIVE =trunc(SYSDATE-1),
3989: last_update_date = hz_utility_pub.last_update_date,
3990: last_updated_by = hz_utility_pub.user_id,
3991: last_update_login = hz_utility_pub.last_update_login,
3992: request_id = hz_utility_pub.request_id,
3993: program_application_id = hz_utility_pub.program_application_id,
3994: program_id = hz_utility_pub.program_id,
3995: program_update_date = sysdate
3988: END_DATE_ACTIVE =trunc(SYSDATE-1),
3989: last_update_date = hz_utility_pub.last_update_date,
3990: last_updated_by = hz_utility_pub.user_id,
3991: last_update_login = hz_utility_pub.last_update_login,
3992: request_id = hz_utility_pub.request_id,
3993: program_application_id = hz_utility_pub.program_application_id,
3994: program_id = hz_utility_pub.program_id,
3995: program_update_date = sysdate
3996: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
3989: last_update_date = hz_utility_pub.last_update_date,
3990: last_updated_by = hz_utility_pub.user_id,
3991: last_update_login = hz_utility_pub.last_update_login,
3992: request_id = hz_utility_pub.request_id,
3993: program_application_id = hz_utility_pub.program_application_id,
3994: program_id = hz_utility_pub.program_id,
3995: program_update_date = sysdate
3996: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
3997: AND OWNER_TABLE_ID =l_rel_to_party_id
3990: last_updated_by = hz_utility_pub.user_id,
3991: last_update_login = hz_utility_pub.last_update_login,
3992: request_id = hz_utility_pub.request_id,
3993: program_application_id = hz_utility_pub.program_application_id,
3994: program_id = hz_utility_pub.program_id,
3995: program_update_date = sysdate
3996: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
3997: AND OWNER_TABLE_ID =l_rel_to_party_id
3998: AND ORIG_SYSTEM = 'DNB'
4001:
4002: /*--Bug 4114254 UPDATE HZ_RELATIONSHIPS
4003: SET end_date = TRUNC(SYSDATE-1),
4004: status = 'I',
4005: last_update_date = hz_utility_pub.last_update_date,
4006: last_updated_by = hz_utility_pub.user_id,
4007: last_update_login = hz_utility_pub.last_update_login,
4008: request_id = hz_utility_pub.request_id,
4009: program_application_id = hz_utility_pub.program_application_id,
4002: /*--Bug 4114254 UPDATE HZ_RELATIONSHIPS
4003: SET end_date = TRUNC(SYSDATE-1),
4004: status = 'I',
4005: last_update_date = hz_utility_pub.last_update_date,
4006: last_updated_by = hz_utility_pub.user_id,
4007: last_update_login = hz_utility_pub.last_update_login,
4008: request_id = hz_utility_pub.request_id,
4009: program_application_id = hz_utility_pub.program_application_id,
4010: program_id = hz_utility_pub.program_id,
4003: SET end_date = TRUNC(SYSDATE-1),
4004: status = 'I',
4005: last_update_date = hz_utility_pub.last_update_date,
4006: last_updated_by = hz_utility_pub.user_id,
4007: last_update_login = hz_utility_pub.last_update_login,
4008: request_id = hz_utility_pub.request_id,
4009: program_application_id = hz_utility_pub.program_application_id,
4010: program_id = hz_utility_pub.program_id,
4011: program_update_date = sysdate
4004: status = 'I',
4005: last_update_date = hz_utility_pub.last_update_date,
4006: last_updated_by = hz_utility_pub.user_id,
4007: last_update_login = hz_utility_pub.last_update_login,
4008: request_id = hz_utility_pub.request_id,
4009: program_application_id = hz_utility_pub.program_application_id,
4010: program_id = hz_utility_pub.program_id,
4011: program_update_date = sysdate
4012: WHERE relationship_id = l_to;*/
4005: last_update_date = hz_utility_pub.last_update_date,
4006: last_updated_by = hz_utility_pub.user_id,
4007: last_update_login = hz_utility_pub.last_update_login,
4008: request_id = hz_utility_pub.request_id,
4009: program_application_id = hz_utility_pub.program_application_id,
4010: program_id = hz_utility_pub.program_id,
4011: program_update_date = sysdate
4012: WHERE relationship_id = l_to;*/
4013: ELSE -- To Newer
4006: last_updated_by = hz_utility_pub.user_id,
4007: last_update_login = hz_utility_pub.last_update_login,
4008: request_id = hz_utility_pub.request_id,
4009: program_application_id = hz_utility_pub.program_application_id,
4010: program_id = hz_utility_pub.program_id,
4011: program_update_date = sysdate
4012: WHERE relationship_id = l_to;*/
4013: ELSE -- To Newer
4014: -- End Date the from-relationship
4014: -- End Date the from-relationship
4015:
4016: UPDATE HZ_RELATIONSHIPS
4017: SET actual_content_source = 'USER_ENTERED',
4018: last_update_date = hz_utility_pub.last_update_date,
4019: last_updated_by = hz_utility_pub.user_id,
4020: last_update_login = hz_utility_pub.last_update_login,
4021: request_id = hz_utility_pub.request_id,
4022: program_application_id = hz_utility_pub.program_application_id,
4015:
4016: UPDATE HZ_RELATIONSHIPS
4017: SET actual_content_source = 'USER_ENTERED',
4018: last_update_date = hz_utility_pub.last_update_date,
4019: last_updated_by = hz_utility_pub.user_id,
4020: last_update_login = hz_utility_pub.last_update_login,
4021: request_id = hz_utility_pub.request_id,
4022: program_application_id = hz_utility_pub.program_application_id,
4023: program_id = hz_utility_pub.program_id,
4016: UPDATE HZ_RELATIONSHIPS
4017: SET actual_content_source = 'USER_ENTERED',
4018: last_update_date = hz_utility_pub.last_update_date,
4019: last_updated_by = hz_utility_pub.user_id,
4020: last_update_login = hz_utility_pub.last_update_login,
4021: request_id = hz_utility_pub.request_id,
4022: program_application_id = hz_utility_pub.program_application_id,
4023: program_id = hz_utility_pub.program_id,
4024: program_update_date = sysdate
4017: SET actual_content_source = 'USER_ENTERED',
4018: last_update_date = hz_utility_pub.last_update_date,
4019: last_updated_by = hz_utility_pub.user_id,
4020: last_update_login = hz_utility_pub.last_update_login,
4021: request_id = hz_utility_pub.request_id,
4022: program_application_id = hz_utility_pub.program_application_id,
4023: program_id = hz_utility_pub.program_id,
4024: program_update_date = sysdate
4025: WHERE relationship_id =FROM_REL.RELATIONSHIP_ID;
4018: last_update_date = hz_utility_pub.last_update_date,
4019: last_updated_by = hz_utility_pub.user_id,
4020: last_update_login = hz_utility_pub.last_update_login,
4021: request_id = hz_utility_pub.request_id,
4022: program_application_id = hz_utility_pub.program_application_id,
4023: program_id = hz_utility_pub.program_id,
4024: program_update_date = sysdate
4025: WHERE relationship_id =FROM_REL.RELATIONSHIP_ID;
4026:
4019: last_updated_by = hz_utility_pub.user_id,
4020: last_update_login = hz_utility_pub.last_update_login,
4021: request_id = hz_utility_pub.request_id,
4022: program_application_id = hz_utility_pub.program_application_id,
4023: program_id = hz_utility_pub.program_id,
4024: program_update_date = sysdate
4025: WHERE relationship_id =FROM_REL.RELATIONSHIP_ID;
4026:
4027: ----Inactivating SSM Record
4027: ----Inactivating SSM Record
4028: UPDATE HZ_ORIG_SYS_REFERENCES
4029: SET STATUS = 'I',
4030: END_DATE_ACTIVE =trunc(SYSDATE-1),
4031: last_update_date = hz_utility_pub.last_update_date,
4032: last_updated_by = hz_utility_pub.user_id,
4033: last_update_login = hz_utility_pub.last_update_login,
4034: request_id = hz_utility_pub.request_id,
4035: program_application_id = hz_utility_pub.program_application_id,
4028: UPDATE HZ_ORIG_SYS_REFERENCES
4029: SET STATUS = 'I',
4030: END_DATE_ACTIVE =trunc(SYSDATE-1),
4031: last_update_date = hz_utility_pub.last_update_date,
4032: last_updated_by = hz_utility_pub.user_id,
4033: last_update_login = hz_utility_pub.last_update_login,
4034: request_id = hz_utility_pub.request_id,
4035: program_application_id = hz_utility_pub.program_application_id,
4036: program_id = hz_utility_pub.program_id,
4029: SET STATUS = 'I',
4030: END_DATE_ACTIVE =trunc(SYSDATE-1),
4031: last_update_date = hz_utility_pub.last_update_date,
4032: last_updated_by = hz_utility_pub.user_id,
4033: last_update_login = hz_utility_pub.last_update_login,
4034: request_id = hz_utility_pub.request_id,
4035: program_application_id = hz_utility_pub.program_application_id,
4036: program_id = hz_utility_pub.program_id,
4037: program_update_date = sysdate
4030: END_DATE_ACTIVE =trunc(SYSDATE-1),
4031: last_update_date = hz_utility_pub.last_update_date,
4032: last_updated_by = hz_utility_pub.user_id,
4033: last_update_login = hz_utility_pub.last_update_login,
4034: request_id = hz_utility_pub.request_id,
4035: program_application_id = hz_utility_pub.program_application_id,
4036: program_id = hz_utility_pub.program_id,
4037: program_update_date = sysdate
4038: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
4031: last_update_date = hz_utility_pub.last_update_date,
4032: last_updated_by = hz_utility_pub.user_id,
4033: last_update_login = hz_utility_pub.last_update_login,
4034: request_id = hz_utility_pub.request_id,
4035: program_application_id = hz_utility_pub.program_application_id,
4036: program_id = hz_utility_pub.program_id,
4037: program_update_date = sysdate
4038: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
4039: AND OWNER_TABLE_ID = FROM_REL.PARTY_ID
4032: last_updated_by = hz_utility_pub.user_id,
4033: last_update_login = hz_utility_pub.last_update_login,
4034: request_id = hz_utility_pub.request_id,
4035: program_application_id = hz_utility_pub.program_application_id,
4036: program_id = hz_utility_pub.program_id,
4037: program_update_date = sysdate
4038: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
4039: AND OWNER_TABLE_ID = FROM_REL.PARTY_ID
4040: AND ORIG_SYSTEM = 'DNB'
4041: AND STATUS = 'A';
4042: /* --Bug 4114254 UPDATE HZ_RELATIONSHIPS
4043: SET status = 'I',
4044: end_date = TRUNC(SYSDATE-1),
4045: last_update_date = hz_utility_pub.last_update_date,
4046: last_updated_by = hz_utility_pub.user_id,
4047: last_update_login = hz_utility_pub.last_update_login,
4048: request_id = hz_utility_pub.request_id,
4049: program_application_id = hz_utility_pub.program_application_id,
4042: /* --Bug 4114254 UPDATE HZ_RELATIONSHIPS
4043: SET status = 'I',
4044: end_date = TRUNC(SYSDATE-1),
4045: last_update_date = hz_utility_pub.last_update_date,
4046: last_updated_by = hz_utility_pub.user_id,
4047: last_update_login = hz_utility_pub.last_update_login,
4048: request_id = hz_utility_pub.request_id,
4049: program_application_id = hz_utility_pub.program_application_id,
4050: program_id = hz_utility_pub.program_id,
4043: SET status = 'I',
4044: end_date = TRUNC(SYSDATE-1),
4045: last_update_date = hz_utility_pub.last_update_date,
4046: last_updated_by = hz_utility_pub.user_id,
4047: last_update_login = hz_utility_pub.last_update_login,
4048: request_id = hz_utility_pub.request_id,
4049: program_application_id = hz_utility_pub.program_application_id,
4050: program_id = hz_utility_pub.program_id,
4051: program_update_date = sysdate
4044: end_date = TRUNC(SYSDATE-1),
4045: last_update_date = hz_utility_pub.last_update_date,
4046: last_updated_by = hz_utility_pub.user_id,
4047: last_update_login = hz_utility_pub.last_update_login,
4048: request_id = hz_utility_pub.request_id,
4049: program_application_id = hz_utility_pub.program_application_id,
4050: program_id = hz_utility_pub.program_id,
4051: program_update_date = sysdate
4052: WHERE relationship_id = FROM_REL.RELATIONSHIP_ID;*/
4045: last_update_date = hz_utility_pub.last_update_date,
4046: last_updated_by = hz_utility_pub.user_id,
4047: last_update_login = hz_utility_pub.last_update_login,
4048: request_id = hz_utility_pub.request_id,
4049: program_application_id = hz_utility_pub.program_application_id,
4050: program_id = hz_utility_pub.program_id,
4051: program_update_date = sysdate
4052: WHERE relationship_id = FROM_REL.RELATIONSHIP_ID;*/
4053: --5404244
4046: last_updated_by = hz_utility_pub.user_id,
4047: last_update_login = hz_utility_pub.last_update_login,
4048: request_id = hz_utility_pub.request_id,
4049: program_application_id = hz_utility_pub.program_application_id,
4050: program_id = hz_utility_pub.program_id,
4051: program_update_date = sysdate
4052: WHERE relationship_id = FROM_REL.RELATIONSHIP_ID;*/
4053: --5404244
4054: OPEN c_check_duplicates (FROM_REL.subject_id, FROM_REL.start_date, FROM_REL.end_date, FROM_REL.relationship_code, FROM_REL.directional_flag);
4066: FROM_REL.PARTY_ID,
4067: l_rel_to_party_id,
4068: 'DUPLICATE_RELN_PARTY',
4069: 'PENDING',
4070: HZ_UTILITY_PUB.CREATED_BY,
4071: HZ_UTILITY_PUB.CREATION_DATE,
4072: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
4073: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
4074: HZ_UTILITY_PUB.LAST_UPDATED_BY);
4067: l_rel_to_party_id,
4068: 'DUPLICATE_RELN_PARTY',
4069: 'PENDING',
4070: HZ_UTILITY_PUB.CREATED_BY,
4071: HZ_UTILITY_PUB.CREATION_DATE,
4072: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
4073: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
4074: HZ_UTILITY_PUB.LAST_UPDATED_BY);
4075:
4068: 'DUPLICATE_RELN_PARTY',
4069: 'PENDING',
4070: HZ_UTILITY_PUB.CREATED_BY,
4071: HZ_UTILITY_PUB.CREATION_DATE,
4072: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
4073: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
4074: HZ_UTILITY_PUB.LAST_UPDATED_BY);
4075:
4076: insert_party_site_details(FROM_REL.PARTY_ID,
4069: 'PENDING',
4070: HZ_UTILITY_PUB.CREATED_BY,
4071: HZ_UTILITY_PUB.CREATION_DATE,
4072: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
4073: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
4074: HZ_UTILITY_PUB.LAST_UPDATED_BY);
4075:
4076: insert_party_site_details(FROM_REL.PARTY_ID,
4077: l_rel_to_party_id,
4070: HZ_UTILITY_PUB.CREATED_BY,
4071: HZ_UTILITY_PUB.CREATION_DATE,
4072: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
4073: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
4074: HZ_UTILITY_PUB.LAST_UPDATED_BY);
4075:
4076: insert_party_site_details(FROM_REL.PARTY_ID,
4077: l_rel_to_party_id,
4078: l_batch_party_id);
4082: 'HZ_PARTY_RELATIONSHIPS',
4083: FROM_REL.relationship_id,
4084: l_to,
4085: 'Y',
4086: hz_utility_pub.created_by,
4087: hz_utility_pub.creation_Date,
4088: hz_utility_pub.last_update_login,
4089: hz_utility_pub.last_update_date,
4090: hz_utility_pub.last_updated_by);
4083: FROM_REL.relationship_id,
4084: l_to,
4085: 'Y',
4086: hz_utility_pub.created_by,
4087: hz_utility_pub.creation_Date,
4088: hz_utility_pub.last_update_login,
4089: hz_utility_pub.last_update_date,
4090: hz_utility_pub.last_updated_by);
4091:
4084: l_to,
4085: 'Y',
4086: hz_utility_pub.created_by,
4087: hz_utility_pub.creation_Date,
4088: hz_utility_pub.last_update_login,
4089: hz_utility_pub.last_update_date,
4090: hz_utility_pub.last_updated_by);
4091:
4092: END IF; --c_check_duplicates
4085: 'Y',
4086: hz_utility_pub.created_by,
4087: hz_utility_pub.creation_Date,
4088: hz_utility_pub.last_update_login,
4089: hz_utility_pub.last_update_date,
4090: hz_utility_pub.last_updated_by);
4091:
4092: END IF; --c_check_duplicates
4093: CLOSE c_check_duplicates;
4086: hz_utility_pub.created_by,
4087: hz_utility_pub.creation_Date,
4088: hz_utility_pub.last_update_login,
4089: hz_utility_pub.last_update_date,
4090: hz_utility_pub.last_updated_by);
4091:
4092: END IF; --c_check_duplicates
4093: CLOSE c_check_duplicates;
4094: --5404244
4217: 'HZ_CONTACT_POINTS',
4218: l_to,
4219: FROM_CP.contact_point_id,
4220: 'T',
4221: hz_utility_pub.created_by,
4222: hz_utility_pub.creation_Date,
4223: hz_utility_pub.last_update_login,
4224: hz_utility_pub.last_update_date,
4225: hz_utility_pub.last_updated_by);
4218: l_to,
4219: FROM_CP.contact_point_id,
4220: 'T',
4221: hz_utility_pub.created_by,
4222: hz_utility_pub.creation_Date,
4223: hz_utility_pub.last_update_login,
4224: hz_utility_pub.last_update_date,
4225: hz_utility_pub.last_updated_by);
4226: ELSE
4219: FROM_CP.contact_point_id,
4220: 'T',
4221: hz_utility_pub.created_by,
4222: hz_utility_pub.creation_Date,
4223: hz_utility_pub.last_update_login,
4224: hz_utility_pub.last_update_date,
4225: hz_utility_pub.last_updated_by);
4226: ELSE
4227: UPDATE HZ_CONTACT_POINTS
4220: 'T',
4221: hz_utility_pub.created_by,
4222: hz_utility_pub.creation_Date,
4223: hz_utility_pub.last_update_login,
4224: hz_utility_pub.last_update_date,
4225: hz_utility_pub.last_updated_by);
4226: ELSE
4227: UPDATE HZ_CONTACT_POINTS
4228: SET actual_content_source = 'USER_ENTERED',
4221: hz_utility_pub.created_by,
4222: hz_utility_pub.creation_Date,
4223: hz_utility_pub.last_update_login,
4224: hz_utility_pub.last_update_date,
4225: hz_utility_pub.last_updated_by);
4226: ELSE
4227: UPDATE HZ_CONTACT_POINTS
4228: SET actual_content_source = 'USER_ENTERED',
4229: last_update_date =hz_utility_pub.last_update_date,
4225: hz_utility_pub.last_updated_by);
4226: ELSE
4227: UPDATE HZ_CONTACT_POINTS
4228: SET actual_content_source = 'USER_ENTERED',
4229: last_update_date =hz_utility_pub.last_update_date,
4230: last_updated_by = hz_utility_pub.last_updated_by,
4231: last_update_login=hz_utility_pub.last_update_login,
4232: request_id = hz_utility_pub.request_id,
4233: program_application_id = hz_utility_pub.program_application_id,
4226: ELSE
4227: UPDATE HZ_CONTACT_POINTS
4228: SET actual_content_source = 'USER_ENTERED',
4229: last_update_date =hz_utility_pub.last_update_date,
4230: last_updated_by = hz_utility_pub.last_updated_by,
4231: last_update_login=hz_utility_pub.last_update_login,
4232: request_id = hz_utility_pub.request_id,
4233: program_application_id = hz_utility_pub.program_application_id,
4234: program_id = hz_utility_pub.program_id,
4227: UPDATE HZ_CONTACT_POINTS
4228: SET actual_content_source = 'USER_ENTERED',
4229: last_update_date =hz_utility_pub.last_update_date,
4230: last_updated_by = hz_utility_pub.last_updated_by,
4231: last_update_login=hz_utility_pub.last_update_login,
4232: request_id = hz_utility_pub.request_id,
4233: program_application_id = hz_utility_pub.program_application_id,
4234: program_id = hz_utility_pub.program_id,
4235: program_update_date = sysdate
4228: SET actual_content_source = 'USER_ENTERED',
4229: last_update_date =hz_utility_pub.last_update_date,
4230: last_updated_by = hz_utility_pub.last_updated_by,
4231: last_update_login=hz_utility_pub.last_update_login,
4232: request_id = hz_utility_pub.request_id,
4233: program_application_id = hz_utility_pub.program_application_id,
4234: program_id = hz_utility_pub.program_id,
4235: program_update_date = sysdate
4236: WHERE contact_point_id = l_to;
4229: last_update_date =hz_utility_pub.last_update_date,
4230: last_updated_by = hz_utility_pub.last_updated_by,
4231: last_update_login=hz_utility_pub.last_update_login,
4232: request_id = hz_utility_pub.request_id,
4233: program_application_id = hz_utility_pub.program_application_id,
4234: program_id = hz_utility_pub.program_id,
4235: program_update_date = sysdate
4236: WHERE contact_point_id = l_to;
4237: ----Inactivating SSM Record
4230: last_updated_by = hz_utility_pub.last_updated_by,
4231: last_update_login=hz_utility_pub.last_update_login,
4232: request_id = hz_utility_pub.request_id,
4233: program_application_id = hz_utility_pub.program_application_id,
4234: program_id = hz_utility_pub.program_id,
4235: program_update_date = sysdate
4236: WHERE contact_point_id = l_to;
4237: ----Inactivating SSM Record
4238: UPDATE HZ_ORIG_SYS_REFERENCES
4237: ----Inactivating SSM Record
4238: UPDATE HZ_ORIG_SYS_REFERENCES
4239: SET STATUS = 'I',
4240: END_DATE_ACTIVE =trunc(SYSDATE-1),
4241: last_update_date = hz_utility_pub.last_update_date,
4242: last_updated_by = hz_utility_pub.user_id,
4243: last_update_login = hz_utility_pub.last_update_login,
4244: request_id = hz_utility_pub.request_id,
4245: program_application_id = hz_utility_pub.program_application_id,
4238: UPDATE HZ_ORIG_SYS_REFERENCES
4239: SET STATUS = 'I',
4240: END_DATE_ACTIVE =trunc(SYSDATE-1),
4241: last_update_date = hz_utility_pub.last_update_date,
4242: last_updated_by = hz_utility_pub.user_id,
4243: last_update_login = hz_utility_pub.last_update_login,
4244: request_id = hz_utility_pub.request_id,
4245: program_application_id = hz_utility_pub.program_application_id,
4246: program_id = hz_utility_pub.program_id,
4239: SET STATUS = 'I',
4240: END_DATE_ACTIVE =trunc(SYSDATE-1),
4241: last_update_date = hz_utility_pub.last_update_date,
4242: last_updated_by = hz_utility_pub.user_id,
4243: last_update_login = hz_utility_pub.last_update_login,
4244: request_id = hz_utility_pub.request_id,
4245: program_application_id = hz_utility_pub.program_application_id,
4246: program_id = hz_utility_pub.program_id,
4247: program_update_date = sysdate
4240: END_DATE_ACTIVE =trunc(SYSDATE-1),
4241: last_update_date = hz_utility_pub.last_update_date,
4242: last_updated_by = hz_utility_pub.user_id,
4243: last_update_login = hz_utility_pub.last_update_login,
4244: request_id = hz_utility_pub.request_id,
4245: program_application_id = hz_utility_pub.program_application_id,
4246: program_id = hz_utility_pub.program_id,
4247: program_update_date = sysdate
4248: WHERE OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
4241: last_update_date = hz_utility_pub.last_update_date,
4242: last_updated_by = hz_utility_pub.user_id,
4243: last_update_login = hz_utility_pub.last_update_login,
4244: request_id = hz_utility_pub.request_id,
4245: program_application_id = hz_utility_pub.program_application_id,
4246: program_id = hz_utility_pub.program_id,
4247: program_update_date = sysdate
4248: WHERE OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
4249: AND OWNER_TABLE_ID = l_to
4242: last_updated_by = hz_utility_pub.user_id,
4243: last_update_login = hz_utility_pub.last_update_login,
4244: request_id = hz_utility_pub.request_id,
4245: program_application_id = hz_utility_pub.program_application_id,
4246: program_id = hz_utility_pub.program_id,
4247: program_update_date = sysdate
4248: WHERE OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
4249: AND OWNER_TABLE_ID = l_to
4250: AND ORIG_SYSTEM = 'DNB'
4334: 'HZ_CONTACT_POINTS',
4335: FROM_CP.contact_point_id,
4336: l_to,
4337: 'Y',
4338: hz_utility_pub.created_by,
4339: hz_utility_pub.creation_Date,
4340: hz_utility_pub.last_update_login,
4341: hz_utility_pub.last_update_date,
4342: hz_utility_pub.last_updated_by);
4335: FROM_CP.contact_point_id,
4336: l_to,
4337: 'Y',
4338: hz_utility_pub.created_by,
4339: hz_utility_pub.creation_Date,
4340: hz_utility_pub.last_update_login,
4341: hz_utility_pub.last_update_date,
4342: hz_utility_pub.last_updated_by);
4343: ELSE
4336: l_to,
4337: 'Y',
4338: hz_utility_pub.created_by,
4339: hz_utility_pub.creation_Date,
4340: hz_utility_pub.last_update_login,
4341: hz_utility_pub.last_update_date,
4342: hz_utility_pub.last_updated_by);
4343: ELSE
4344: UPDATE HZ_CONTACT_POINTS
4337: 'Y',
4338: hz_utility_pub.created_by,
4339: hz_utility_pub.creation_Date,
4340: hz_utility_pub.last_update_login,
4341: hz_utility_pub.last_update_date,
4342: hz_utility_pub.last_updated_by);
4343: ELSE
4344: UPDATE HZ_CONTACT_POINTS
4345: SET actual_content_source = 'USER_ENTERED',
4338: hz_utility_pub.created_by,
4339: hz_utility_pub.creation_Date,
4340: hz_utility_pub.last_update_login,
4341: hz_utility_pub.last_update_date,
4342: hz_utility_pub.last_updated_by);
4343: ELSE
4344: UPDATE HZ_CONTACT_POINTS
4345: SET actual_content_source = 'USER_ENTERED',
4346: last_update_date =hz_utility_pub.last_update_date,
4342: hz_utility_pub.last_updated_by);
4343: ELSE
4344: UPDATE HZ_CONTACT_POINTS
4345: SET actual_content_source = 'USER_ENTERED',
4346: last_update_date =hz_utility_pub.last_update_date,
4347: last_updated_by = hz_utility_pub.last_updated_by,
4348: last_update_login=hz_utility_pub.last_update_login,
4349: request_id = hz_utility_pub.request_id,
4350: program_application_id = hz_utility_pub.program_application_id,
4343: ELSE
4344: UPDATE HZ_CONTACT_POINTS
4345: SET actual_content_source = 'USER_ENTERED',
4346: last_update_date =hz_utility_pub.last_update_date,
4347: last_updated_by = hz_utility_pub.last_updated_by,
4348: last_update_login=hz_utility_pub.last_update_login,
4349: request_id = hz_utility_pub.request_id,
4350: program_application_id = hz_utility_pub.program_application_id,
4351: program_id = hz_utility_pub.program_id,
4344: UPDATE HZ_CONTACT_POINTS
4345: SET actual_content_source = 'USER_ENTERED',
4346: last_update_date =hz_utility_pub.last_update_date,
4347: last_updated_by = hz_utility_pub.last_updated_by,
4348: last_update_login=hz_utility_pub.last_update_login,
4349: request_id = hz_utility_pub.request_id,
4350: program_application_id = hz_utility_pub.program_application_id,
4351: program_id = hz_utility_pub.program_id,
4352: program_update_date = sysdate
4345: SET actual_content_source = 'USER_ENTERED',
4346: last_update_date =hz_utility_pub.last_update_date,
4347: last_updated_by = hz_utility_pub.last_updated_by,
4348: last_update_login=hz_utility_pub.last_update_login,
4349: request_id = hz_utility_pub.request_id,
4350: program_application_id = hz_utility_pub.program_application_id,
4351: program_id = hz_utility_pub.program_id,
4352: program_update_date = sysdate
4353: WHERE contact_point_id = FROM_CP.contact_point_id;
4346: last_update_date =hz_utility_pub.last_update_date,
4347: last_updated_by = hz_utility_pub.last_updated_by,
4348: last_update_login=hz_utility_pub.last_update_login,
4349: request_id = hz_utility_pub.request_id,
4350: program_application_id = hz_utility_pub.program_application_id,
4351: program_id = hz_utility_pub.program_id,
4352: program_update_date = sysdate
4353: WHERE contact_point_id = FROM_CP.contact_point_id;
4354: ----Inactivating SSM Record
4347: last_updated_by = hz_utility_pub.last_updated_by,
4348: last_update_login=hz_utility_pub.last_update_login,
4349: request_id = hz_utility_pub.request_id,
4350: program_application_id = hz_utility_pub.program_application_id,
4351: program_id = hz_utility_pub.program_id,
4352: program_update_date = sysdate
4353: WHERE contact_point_id = FROM_CP.contact_point_id;
4354: ----Inactivating SSM Record
4355: UPDATE HZ_ORIG_SYS_REFERENCES
4354: ----Inactivating SSM Record
4355: UPDATE HZ_ORIG_SYS_REFERENCES
4356: SET STATUS = 'I',
4357: END_DATE_ACTIVE =trunc(SYSDATE-1),
4358: last_update_date = hz_utility_pub.last_update_date,
4359: last_updated_by = hz_utility_pub.user_id,
4360: last_update_login = hz_utility_pub.last_update_login,
4361: request_id = hz_utility_pub.request_id,
4362: program_application_id = hz_utility_pub.program_application_id,
4355: UPDATE HZ_ORIG_SYS_REFERENCES
4356: SET STATUS = 'I',
4357: END_DATE_ACTIVE =trunc(SYSDATE-1),
4358: last_update_date = hz_utility_pub.last_update_date,
4359: last_updated_by = hz_utility_pub.user_id,
4360: last_update_login = hz_utility_pub.last_update_login,
4361: request_id = hz_utility_pub.request_id,
4362: program_application_id = hz_utility_pub.program_application_id,
4363: program_id = hz_utility_pub.program_id,
4356: SET STATUS = 'I',
4357: END_DATE_ACTIVE =trunc(SYSDATE-1),
4358: last_update_date = hz_utility_pub.last_update_date,
4359: last_updated_by = hz_utility_pub.user_id,
4360: last_update_login = hz_utility_pub.last_update_login,
4361: request_id = hz_utility_pub.request_id,
4362: program_application_id = hz_utility_pub.program_application_id,
4363: program_id = hz_utility_pub.program_id,
4364: program_update_date = sysdate
4357: END_DATE_ACTIVE =trunc(SYSDATE-1),
4358: last_update_date = hz_utility_pub.last_update_date,
4359: last_updated_by = hz_utility_pub.user_id,
4360: last_update_login = hz_utility_pub.last_update_login,
4361: request_id = hz_utility_pub.request_id,
4362: program_application_id = hz_utility_pub.program_application_id,
4363: program_id = hz_utility_pub.program_id,
4364: program_update_date = sysdate
4365: WHERE OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
4358: last_update_date = hz_utility_pub.last_update_date,
4359: last_updated_by = hz_utility_pub.user_id,
4360: last_update_login = hz_utility_pub.last_update_login,
4361: request_id = hz_utility_pub.request_id,
4362: program_application_id = hz_utility_pub.program_application_id,
4363: program_id = hz_utility_pub.program_id,
4364: program_update_date = sysdate
4365: WHERE OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
4366: AND OWNER_TABLE_ID =FROM_CP.contact_point_id
4359: last_updated_by = hz_utility_pub.user_id,
4360: last_update_login = hz_utility_pub.last_update_login,
4361: request_id = hz_utility_pub.request_id,
4362: program_application_id = hz_utility_pub.program_application_id,
4363: program_id = hz_utility_pub.program_id,
4364: program_update_date = sysdate
4365: WHERE OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
4366: AND OWNER_TABLE_ID =FROM_CP.contact_point_id
4367: AND ORIG_SYSTEM = 'DNB'
4403: 'HZ_CREDIT_RATINGS',
4404: l_to,
4405: FROM_CR.credit_rating_id,
4406: 'T',
4407: hz_utility_pub.created_by,
4408: hz_utility_pub.creation_Date,
4409: hz_utility_pub.last_update_login,
4410: hz_utility_pub.last_update_date,
4411: hz_utility_pub.last_updated_by);
4404: l_to,
4405: FROM_CR.credit_rating_id,
4406: 'T',
4407: hz_utility_pub.created_by,
4408: hz_utility_pub.creation_Date,
4409: hz_utility_pub.last_update_login,
4410: hz_utility_pub.last_update_date,
4411: hz_utility_pub.last_updated_by);
4412: */
4405: FROM_CR.credit_rating_id,
4406: 'T',
4407: hz_utility_pub.created_by,
4408: hz_utility_pub.creation_Date,
4409: hz_utility_pub.last_update_login,
4410: hz_utility_pub.last_update_date,
4411: hz_utility_pub.last_updated_by);
4412: */
4413: ELSE -- To Newer
4406: 'T',
4407: hz_utility_pub.created_by,
4408: hz_utility_pub.creation_Date,
4409: hz_utility_pub.last_update_login,
4410: hz_utility_pub.last_update_date,
4411: hz_utility_pub.last_updated_by);
4412: */
4413: ELSE -- To Newer
4414: -- Merge from into to
4407: hz_utility_pub.created_by,
4408: hz_utility_pub.creation_Date,
4409: hz_utility_pub.last_update_login,
4410: hz_utility_pub.last_update_date,
4411: hz_utility_pub.last_updated_by);
4412: */
4413: ELSE -- To Newer
4414: -- Merge from into to
4415: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4417: 'HZ_CREDIT_RATINGS',
4418: FROM_CR.credit_rating_id,
4419: l_to,
4420: 'Y',
4421: hz_utility_pub.created_by,
4422: hz_utility_pub.creation_Date,
4423: hz_utility_pub.last_update_login,
4424: hz_utility_pub.last_update_date,
4425: hz_utility_pub.last_updated_by);
4418: FROM_CR.credit_rating_id,
4419: l_to,
4420: 'Y',
4421: hz_utility_pub.created_by,
4422: hz_utility_pub.creation_Date,
4423: hz_utility_pub.last_update_login,
4424: hz_utility_pub.last_update_date,
4425: hz_utility_pub.last_updated_by);
4426: END IF;
4419: l_to,
4420: 'Y',
4421: hz_utility_pub.created_by,
4422: hz_utility_pub.creation_Date,
4423: hz_utility_pub.last_update_login,
4424: hz_utility_pub.last_update_date,
4425: hz_utility_pub.last_updated_by);
4426: END IF;
4427: EXCEPTION
4420: 'Y',
4421: hz_utility_pub.created_by,
4422: hz_utility_pub.creation_Date,
4423: hz_utility_pub.last_update_login,
4424: hz_utility_pub.last_update_date,
4425: hz_utility_pub.last_updated_by);
4426: END IF;
4427: EXCEPTION
4428: WHEN NO_DATA_FOUND THEN
4421: hz_utility_pub.created_by,
4422: hz_utility_pub.creation_Date,
4423: hz_utility_pub.last_update_login,
4424: hz_utility_pub.last_update_date,
4425: hz_utility_pub.last_updated_by);
4426: END IF;
4427: EXCEPTION
4428: WHEN NO_DATA_FOUND THEN
4429: -- Transfer
4460: 'HZ_CODE_ASSIGNMENTS',
4461: FROM_CA.code_assignment_id,
4462: l_to,
4463: 'Y',
4464: hz_utility_pub.created_by,
4465: hz_utility_pub.creation_Date,
4466: hz_utility_pub.last_update_login,
4467: hz_utility_pub.last_update_date,
4468: hz_utility_pub.last_updated_by);
4461: FROM_CA.code_assignment_id,
4462: l_to,
4463: 'Y',
4464: hz_utility_pub.created_by,
4465: hz_utility_pub.creation_Date,
4466: hz_utility_pub.last_update_login,
4467: hz_utility_pub.last_update_date,
4468: hz_utility_pub.last_updated_by);
4469: ELSE -- To Newer
4462: l_to,
4463: 'Y',
4464: hz_utility_pub.created_by,
4465: hz_utility_pub.creation_Date,
4466: hz_utility_pub.last_update_login,
4467: hz_utility_pub.last_update_date,
4468: hz_utility_pub.last_updated_by);
4469: ELSE -- To Newer
4470: -- Merge from into to
4463: 'Y',
4464: hz_utility_pub.created_by,
4465: hz_utility_pub.creation_Date,
4466: hz_utility_pub.last_update_login,
4467: hz_utility_pub.last_update_date,
4468: hz_utility_pub.last_updated_by);
4469: ELSE -- To Newer
4470: -- Merge from into to
4471: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4464: hz_utility_pub.created_by,
4465: hz_utility_pub.creation_Date,
4466: hz_utility_pub.last_update_login,
4467: hz_utility_pub.last_update_date,
4468: hz_utility_pub.last_updated_by);
4469: ELSE -- To Newer
4470: -- Merge from into to
4471: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4472: p_batch_party_id,
4473: 'HZ_CODE_ASSIGNMENTS',
4474: FROM_CA.code_assignment_id,
4475: l_to,
4476: 'Y',
4477: hz_utility_pub.created_by,
4478: hz_utility_pub.creation_Date,
4479: hz_utility_pub.last_update_login,
4480: hz_utility_pub.last_update_date,
4481: hz_utility_pub.last_updated_by);
4474: FROM_CA.code_assignment_id,
4475: l_to,
4476: 'Y',
4477: hz_utility_pub.created_by,
4478: hz_utility_pub.creation_Date,
4479: hz_utility_pub.last_update_login,
4480: hz_utility_pub.last_update_date,
4481: hz_utility_pub.last_updated_by);
4482: END IF;
4475: l_to,
4476: 'Y',
4477: hz_utility_pub.created_by,
4478: hz_utility_pub.creation_Date,
4479: hz_utility_pub.last_update_login,
4480: hz_utility_pub.last_update_date,
4481: hz_utility_pub.last_updated_by);
4482: END IF;
4483: EXCEPTION
4476: 'Y',
4477: hz_utility_pub.created_by,
4478: hz_utility_pub.creation_Date,
4479: hz_utility_pub.last_update_login,
4480: hz_utility_pub.last_update_date,
4481: hz_utility_pub.last_updated_by);
4482: END IF;
4483: EXCEPTION
4484: WHEN NO_DATA_FOUND THEN
4477: hz_utility_pub.created_by,
4478: hz_utility_pub.creation_Date,
4479: hz_utility_pub.last_update_login,
4480: hz_utility_pub.last_update_date,
4481: hz_utility_pub.last_updated_by);
4482: END IF;
4483: EXCEPTION
4484: WHEN NO_DATA_FOUND THEN
4485: -- Transfer
4528:
4529: /*
4530: UPDATE HZ_FINANCIAL_REPORTS
4531: SET status = 'I',
4532: last_update_date = hz_utility_pub.last_update_date,
4533: last_updated_by = hz_utility_pub.user_id,
4534: last_update_login = hz_utility_pub.last_update_login,
4535: request_id = hz_utility_pub.request_id,
4536: program_application_id = hz_utility_pub.program_application_id,
4529: /*
4530: UPDATE HZ_FINANCIAL_REPORTS
4531: SET status = 'I',
4532: last_update_date = hz_utility_pub.last_update_date,
4533: last_updated_by = hz_utility_pub.user_id,
4534: last_update_login = hz_utility_pub.last_update_login,
4535: request_id = hz_utility_pub.request_id,
4536: program_application_id = hz_utility_pub.program_application_id,
4537: program_id = hz_utility_pub.program_id,
4530: UPDATE HZ_FINANCIAL_REPORTS
4531: SET status = 'I',
4532: last_update_date = hz_utility_pub.last_update_date,
4533: last_updated_by = hz_utility_pub.user_id,
4534: last_update_login = hz_utility_pub.last_update_login,
4535: request_id = hz_utility_pub.request_id,
4536: program_application_id = hz_utility_pub.program_application_id,
4537: program_id = hz_utility_pub.program_id,
4538: program_update_date = sysdate
4531: SET status = 'I',
4532: last_update_date = hz_utility_pub.last_update_date,
4533: last_updated_by = hz_utility_pub.user_id,
4534: last_update_login = hz_utility_pub.last_update_login,
4535: request_id = hz_utility_pub.request_id,
4536: program_application_id = hz_utility_pub.program_application_id,
4537: program_id = hz_utility_pub.program_id,
4538: program_update_date = sysdate
4539: WHERE financial_report_id = l_to;
4532: last_update_date = hz_utility_pub.last_update_date,
4533: last_updated_by = hz_utility_pub.user_id,
4534: last_update_login = hz_utility_pub.last_update_login,
4535: request_id = hz_utility_pub.request_id,
4536: program_application_id = hz_utility_pub.program_application_id,
4537: program_id = hz_utility_pub.program_id,
4538: program_update_date = sysdate
4539: WHERE financial_report_id = l_to;
4540:
4533: last_updated_by = hz_utility_pub.user_id,
4534: last_update_login = hz_utility_pub.last_update_login,
4535: request_id = hz_utility_pub.request_id,
4536: program_application_id = hz_utility_pub.program_application_id,
4537: program_id = hz_utility_pub.program_id,
4538: program_update_date = sysdate
4539: WHERE financial_report_id = l_to;
4540:
4541: UPDATE HZ_FINANCIAL_NUMBERS
4539: WHERE financial_report_id = l_to;
4540:
4541: UPDATE HZ_FINANCIAL_NUMBERS
4542: SET status='I',
4543: last_update_date = hz_utility_pub.last_update_date,
4544: last_updated_by = hz_utility_pub.user_id,
4545: last_update_login = hz_utility_pub.last_update_login,
4546: request_id = hz_utility_pub.request_id,
4547: program_application_id = hz_utility_pub.program_application_id,
4540:
4541: UPDATE HZ_FINANCIAL_NUMBERS
4542: SET status='I',
4543: last_update_date = hz_utility_pub.last_update_date,
4544: last_updated_by = hz_utility_pub.user_id,
4545: last_update_login = hz_utility_pub.last_update_login,
4546: request_id = hz_utility_pub.request_id,
4547: program_application_id = hz_utility_pub.program_application_id,
4548: program_id = hz_utility_pub.program_id,
4541: UPDATE HZ_FINANCIAL_NUMBERS
4542: SET status='I',
4543: last_update_date = hz_utility_pub.last_update_date,
4544: last_updated_by = hz_utility_pub.user_id,
4545: last_update_login = hz_utility_pub.last_update_login,
4546: request_id = hz_utility_pub.request_id,
4547: program_application_id = hz_utility_pub.program_application_id,
4548: program_id = hz_utility_pub.program_id,
4549: program_update_date = sysdate
4542: SET status='I',
4543: last_update_date = hz_utility_pub.last_update_date,
4544: last_updated_by = hz_utility_pub.user_id,
4545: last_update_login = hz_utility_pub.last_update_login,
4546: request_id = hz_utility_pub.request_id,
4547: program_application_id = hz_utility_pub.program_application_id,
4548: program_id = hz_utility_pub.program_id,
4549: program_update_date = sysdate
4550: WHERE financial_report_id = l_to;
4543: last_update_date = hz_utility_pub.last_update_date,
4544: last_updated_by = hz_utility_pub.user_id,
4545: last_update_login = hz_utility_pub.last_update_login,
4546: request_id = hz_utility_pub.request_id,
4547: program_application_id = hz_utility_pub.program_application_id,
4548: program_id = hz_utility_pub.program_id,
4549: program_update_date = sysdate
4550: WHERE financial_report_id = l_to;
4551: */
4544: last_updated_by = hz_utility_pub.user_id,
4545: last_update_login = hz_utility_pub.last_update_login,
4546: request_id = hz_utility_pub.request_id,
4547: program_application_id = hz_utility_pub.program_application_id,
4548: program_id = hz_utility_pub.program_id,
4549: program_update_date = sysdate
4550: WHERE financial_report_id = l_to;
4551: */
4552: ELSE
4551: */
4552: ELSE
4553: UPDATE HZ_FINANCIAL_REPORTS
4554: SET status = 'M',
4555: last_update_date = hz_utility_pub.last_update_date,
4556: last_updated_by = hz_utility_pub.user_id,
4557: last_update_login = hz_utility_pub.last_update_login,
4558: request_id = hz_utility_pub.request_id,
4559: program_application_id = hz_utility_pub.program_application_id,
4552: ELSE
4553: UPDATE HZ_FINANCIAL_REPORTS
4554: SET status = 'M',
4555: last_update_date = hz_utility_pub.last_update_date,
4556: last_updated_by = hz_utility_pub.user_id,
4557: last_update_login = hz_utility_pub.last_update_login,
4558: request_id = hz_utility_pub.request_id,
4559: program_application_id = hz_utility_pub.program_application_id,
4560: program_id = hz_utility_pub.program_id,
4553: UPDATE HZ_FINANCIAL_REPORTS
4554: SET status = 'M',
4555: last_update_date = hz_utility_pub.last_update_date,
4556: last_updated_by = hz_utility_pub.user_id,
4557: last_update_login = hz_utility_pub.last_update_login,
4558: request_id = hz_utility_pub.request_id,
4559: program_application_id = hz_utility_pub.program_application_id,
4560: program_id = hz_utility_pub.program_id,
4561: program_update_date = sysdate
4554: SET status = 'M',
4555: last_update_date = hz_utility_pub.last_update_date,
4556: last_updated_by = hz_utility_pub.user_id,
4557: last_update_login = hz_utility_pub.last_update_login,
4558: request_id = hz_utility_pub.request_id,
4559: program_application_id = hz_utility_pub.program_application_id,
4560: program_id = hz_utility_pub.program_id,
4561: program_update_date = sysdate
4562: WHERE financial_report_id = FROM_FR.financial_report_id;
4555: last_update_date = hz_utility_pub.last_update_date,
4556: last_updated_by = hz_utility_pub.user_id,
4557: last_update_login = hz_utility_pub.last_update_login,
4558: request_id = hz_utility_pub.request_id,
4559: program_application_id = hz_utility_pub.program_application_id,
4560: program_id = hz_utility_pub.program_id,
4561: program_update_date = sysdate
4562: WHERE financial_report_id = FROM_FR.financial_report_id;
4563:
4556: last_updated_by = hz_utility_pub.user_id,
4557: last_update_login = hz_utility_pub.last_update_login,
4558: request_id = hz_utility_pub.request_id,
4559: program_application_id = hz_utility_pub.program_application_id,
4560: program_id = hz_utility_pub.program_id,
4561: program_update_date = sysdate
4562: WHERE financial_report_id = FROM_FR.financial_report_id;
4563:
4564: UPDATE HZ_FINANCIAL_NUMBERS
4562: WHERE financial_report_id = FROM_FR.financial_report_id;
4563:
4564: UPDATE HZ_FINANCIAL_NUMBERS
4565: SET status='M',
4566: last_update_date = hz_utility_pub.last_update_date,
4567: last_updated_by = hz_utility_pub.user_id,
4568: last_update_login = hz_utility_pub.last_update_login,
4569: request_id = hz_utility_pub.request_id,
4570: program_application_id = hz_utility_pub.program_application_id,
4563:
4564: UPDATE HZ_FINANCIAL_NUMBERS
4565: SET status='M',
4566: last_update_date = hz_utility_pub.last_update_date,
4567: last_updated_by = hz_utility_pub.user_id,
4568: last_update_login = hz_utility_pub.last_update_login,
4569: request_id = hz_utility_pub.request_id,
4570: program_application_id = hz_utility_pub.program_application_id,
4571: program_id = hz_utility_pub.program_id,
4564: UPDATE HZ_FINANCIAL_NUMBERS
4565: SET status='M',
4566: last_update_date = hz_utility_pub.last_update_date,
4567: last_updated_by = hz_utility_pub.user_id,
4568: last_update_login = hz_utility_pub.last_update_login,
4569: request_id = hz_utility_pub.request_id,
4570: program_application_id = hz_utility_pub.program_application_id,
4571: program_id = hz_utility_pub.program_id,
4572: program_update_date = sysdate
4565: SET status='M',
4566: last_update_date = hz_utility_pub.last_update_date,
4567: last_updated_by = hz_utility_pub.user_id,
4568: last_update_login = hz_utility_pub.last_update_login,
4569: request_id = hz_utility_pub.request_id,
4570: program_application_id = hz_utility_pub.program_application_id,
4571: program_id = hz_utility_pub.program_id,
4572: program_update_date = sysdate
4573: WHERE financial_report_id = FROM_FR.financial_report_id; -- Bug 3313609
4566: last_update_date = hz_utility_pub.last_update_date,
4567: last_updated_by = hz_utility_pub.user_id,
4568: last_update_login = hz_utility_pub.last_update_login,
4569: request_id = hz_utility_pub.request_id,
4570: program_application_id = hz_utility_pub.program_application_id,
4571: program_id = hz_utility_pub.program_id,
4572: program_update_date = sysdate
4573: WHERE financial_report_id = FROM_FR.financial_report_id; -- Bug 3313609
4574:
4567: last_updated_by = hz_utility_pub.user_id,
4568: last_update_login = hz_utility_pub.last_update_login,
4569: request_id = hz_utility_pub.request_id,
4570: program_application_id = hz_utility_pub.program_application_id,
4571: program_id = hz_utility_pub.program_id,
4572: program_update_date = sysdate
4573: WHERE financial_report_id = FROM_FR.financial_report_id; -- Bug 3313609
4574:
4575: END IF;
4635: 'HZ_PARTY_SITES',
4636: l_ps_id,
4637: l_dup_ps_id,
4638: 'Y',
4639: hz_utility_pub.created_by,
4640: hz_utility_pub.creation_Date,
4641: hz_utility_pub.last_update_login,
4642: hz_utility_pub.last_update_date,
4643: hz_utility_pub.last_updated_by);
4636: l_ps_id,
4637: l_dup_ps_id,
4638: 'Y',
4639: hz_utility_pub.created_by,
4640: hz_utility_pub.creation_Date,
4641: hz_utility_pub.last_update_login,
4642: hz_utility_pub.last_update_date,
4643: hz_utility_pub.last_updated_by);
4644: ELSE
4637: l_dup_ps_id,
4638: 'Y',
4639: hz_utility_pub.created_by,
4640: hz_utility_pub.creation_Date,
4641: hz_utility_pub.last_update_login,
4642: hz_utility_pub.last_update_date,
4643: hz_utility_pub.last_updated_by);
4644: ELSE
4645: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4638: 'Y',
4639: hz_utility_pub.created_by,
4640: hz_utility_pub.creation_Date,
4641: hz_utility_pub.last_update_login,
4642: hz_utility_pub.last_update_date,
4643: hz_utility_pub.last_updated_by);
4644: ELSE
4645: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4646: p_batch_party_id,
4639: hz_utility_pub.created_by,
4640: hz_utility_pub.creation_Date,
4641: hz_utility_pub.last_update_login,
4642: hz_utility_pub.last_update_date,
4643: hz_utility_pub.last_updated_by);
4644: ELSE
4645: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4646: p_batch_party_id,
4647: 'HZ_PARTY_SITES',
4647: 'HZ_PARTY_SITES',
4648: l_ps_id,
4649: l_ps_id,
4650: 'Y',
4651: hz_utility_pub.created_by,
4652: hz_utility_pub.creation_Date,
4653: hz_utility_pub.last_update_login,
4654: hz_utility_pub.last_update_date,
4655: hz_utility_pub.last_updated_by);
4648: l_ps_id,
4649: l_ps_id,
4650: 'Y',
4651: hz_utility_pub.created_by,
4652: hz_utility_pub.creation_Date,
4653: hz_utility_pub.last_update_login,
4654: hz_utility_pub.last_update_date,
4655: hz_utility_pub.last_updated_by);
4656: END IF;
4649: l_ps_id,
4650: 'Y',
4651: hz_utility_pub.created_by,
4652: hz_utility_pub.creation_Date,
4653: hz_utility_pub.last_update_login,
4654: hz_utility_pub.last_update_date,
4655: hz_utility_pub.last_updated_by);
4656: END IF;
4657: CLOSE c_dup_to_ps;
4650: 'Y',
4651: hz_utility_pub.created_by,
4652: hz_utility_pub.creation_Date,
4653: hz_utility_pub.last_update_login,
4654: hz_utility_pub.last_update_date,
4655: hz_utility_pub.last_updated_by);
4656: END IF;
4657: CLOSE c_dup_to_ps;
4658: END IF;
4651: hz_utility_pub.created_by,
4652: hz_utility_pub.creation_Date,
4653: hz_utility_pub.last_update_login,
4654: hz_utility_pub.last_update_date,
4655: hz_utility_pub.last_updated_by);
4656: END IF;
4657: CLOSE c_dup_to_ps;
4658: END IF;
4659: END LOOP;