APPS.IBE_MERGE_PVT dependencies on HZ_UTILITY_PUB

Line 175: PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, ORG_ID, 'D',hz_utility_pub.CREATED_BY,

171: LAST_UPDATED_BY,LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, ENABLED_FLAG, FREIGHT_CODE, PAYMENT_ID,
172: BILL_TO_PTY_SITE_ID, SHIP_TO_PTY_SITE_ID,ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
173: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11,
174: ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, SECURITY_GROUP_ID, REQUEST_ID, PROGRAM_ID,
175: PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, ORG_ID, 'D',hz_utility_pub.CREATED_BY,
176: hz_utility_pub.CREATION_DATE, hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,
177: hz_utility_pub.LAST_UPDATED_BY
178: from IBE_ORD_ONECLICK_ALL where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);
179: end if;

Line 176: hz_utility_pub.CREATION_DATE, hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,

172: BILL_TO_PTY_SITE_ID, SHIP_TO_PTY_SITE_ID,ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
173: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11,
174: ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, SECURITY_GROUP_ID, REQUEST_ID, PROGRAM_ID,
175: PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, ORG_ID, 'D',hz_utility_pub.CREATED_BY,
176: hz_utility_pub.CREATION_DATE, hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,
177: hz_utility_pub.LAST_UPDATED_BY
178: from IBE_ORD_ONECLICK_ALL where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);
179: end if;
180: delete IBE_ORD_ONECLICK_ALL

Line 177: hz_utility_pub.LAST_UPDATED_BY

173: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11,
174: ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, SECURITY_GROUP_ID, REQUEST_ID, PROGRAM_ID,
175: PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, ORG_ID, 'D',hz_utility_pub.CREATED_BY,
176: hz_utility_pub.CREATION_DATE, hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,
177: hz_utility_pub.LAST_UPDATED_BY
178: from IBE_ORD_ONECLICK_ALL where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);
179: end if;
180: delete IBE_ORD_ONECLICK_ALL
181: where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);

Line 331: hz_utility_pub.CREATED_BY,

327: NUM_COL2_ORIG_LIST(I),
328: NUM_COL2_NEW_LIST(I),
329: 'U',
330: req_id,
331: hz_utility_pub.CREATED_BY,
332: hz_utility_pub.CREATION_DATE,
333: hz_utility_pub.LAST_UPDATE_LOGIN,
334: hz_utility_pub.LAST_UPDATE_DATE,
335: hz_utility_pub.LAST_UPDATED_BY

Line 332: hz_utility_pub.CREATION_DATE,

328: NUM_COL2_NEW_LIST(I),
329: 'U',
330: req_id,
331: hz_utility_pub.CREATED_BY,
332: hz_utility_pub.CREATION_DATE,
333: hz_utility_pub.LAST_UPDATE_LOGIN,
334: hz_utility_pub.LAST_UPDATE_DATE,
335: hz_utility_pub.LAST_UPDATED_BY
336: );

Line 333: hz_utility_pub.LAST_UPDATE_LOGIN,

329: 'U',
330: req_id,
331: hz_utility_pub.CREATED_BY,
332: hz_utility_pub.CREATION_DATE,
333: hz_utility_pub.LAST_UPDATE_LOGIN,
334: hz_utility_pub.LAST_UPDATE_DATE,
335: hz_utility_pub.LAST_UPDATED_BY
336: );
337:

Line 334: hz_utility_pub.LAST_UPDATE_DATE,

330: req_id,
331: hz_utility_pub.CREATED_BY,
332: hz_utility_pub.CREATION_DATE,
333: hz_utility_pub.LAST_UPDATE_LOGIN,
334: hz_utility_pub.LAST_UPDATE_DATE,
335: hz_utility_pub.LAST_UPDATED_BY
336: );
337:
338:

Line 335: hz_utility_pub.LAST_UPDATED_BY

331: hz_utility_pub.CREATED_BY,
332: hz_utility_pub.CREATION_DATE,
333: hz_utility_pub.LAST_UPDATE_LOGIN,
334: hz_utility_pub.LAST_UPDATE_DATE,
335: hz_utility_pub.LAST_UPDATED_BY
336: );
337:
338:
339: END IF;

Line 449: 'U',req_id,hz_utility_pub.CREATED_BY,

445: CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY
446: ) VALUES (
447: HZ_CUSTOMER_MERGE_LOG_s.nextval,'ASO_QUOTE_HEADERS_ALL',
448: l_customer_merge_id,l_from_quote_id,'IBE_PRMT_SC_UNNAMED','IBE_PRMT_SC_DEFAULTNAMED',
449: 'U',req_id,hz_utility_pub.CREATED_BY,
450: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,
451: hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY
452: );
453: end if;

Line 450: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,

446: ) VALUES (
447: HZ_CUSTOMER_MERGE_LOG_s.nextval,'ASO_QUOTE_HEADERS_ALL',
448: l_customer_merge_id,l_from_quote_id,'IBE_PRMT_SC_UNNAMED','IBE_PRMT_SC_DEFAULTNAMED',
449: 'U',req_id,hz_utility_pub.CREATED_BY,
450: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,
451: hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY
452: );
453: end if;
454:

Line 451: hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY

447: HZ_CUSTOMER_MERGE_LOG_s.nextval,'ASO_QUOTE_HEADERS_ALL',
448: l_customer_merge_id,l_from_quote_id,'IBE_PRMT_SC_UNNAMED','IBE_PRMT_SC_DEFAULTNAMED',
449: 'U',req_id,hz_utility_pub.CREATED_BY,
450: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,
451: hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY
452: );
453: end if;
454:
455: --log data when audit profile is On

Line 464: ,SECURITY_GROUP_ID,QUOTE_HEADER_ID,'D',hz_utility_pub.CREATED_BY,hz_utility_pub.CREATION_DATE,

460: CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY)
461: select HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_ACTIVE_QUOTES_ALL',l_customer_merge_id
462: ,req_id,ACTIVE_QUOTE_ID,PARTY_ID,CUST_ACCOUNT_ID,ORG_ID,CREATED_BY,CREATION_DATE
463: ,LAST_UPDATED_BY,LAST_UPDATE_DATE,OBJECT_VERSION_NUMBER,LAST_UPDATE_LOGIN
464: ,SECURITY_GROUP_ID,QUOTE_HEADER_ID,'D',hz_utility_pub.CREATED_BY,hz_utility_pub.CREATION_DATE,
465: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY
466: from ibe_active_quotes_all where quote_header_id=l_from_quote_id
467: and cust_account_id = l_from_acct_id and party_id=l_from_party_id;
468:

Line 465: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY

461: select HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_ACTIVE_QUOTES_ALL',l_customer_merge_id
462: ,req_id,ACTIVE_QUOTE_ID,PARTY_ID,CUST_ACCOUNT_ID,ORG_ID,CREATED_BY,CREATION_DATE
463: ,LAST_UPDATED_BY,LAST_UPDATE_DATE,OBJECT_VERSION_NUMBER,LAST_UPDATE_LOGIN
464: ,SECURITY_GROUP_ID,QUOTE_HEADER_ID,'D',hz_utility_pub.CREATED_BY,hz_utility_pub.CREATION_DATE,
465: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY
466: from ibe_active_quotes_all where quote_header_id=l_from_quote_id
467: and cust_account_id = l_from_acct_id and party_id=l_from_party_id;
468:
469: end if;

Line 634: l_contact_point_id,'D',req_id,hz_utility_pub.CREATED_BY, hz_utility_pub.CREATION_DATE,

630: l_program_update_date,l_object_version_number,l_created_by,l_creation_date,
631: l_last_updated_by,l_last_update_date,l_last_update_login,l_quote_header_id,
632: l_quote_sharee_number,l_update_privilege_type_code,l_security_group_id,l_party_id,
633: l_cust_account_id,l_start_date_active,l_end_date_active,l_recipient_name,
634: l_contact_point_id,'D',req_id,hz_utility_pub.CREATED_BY, hz_utility_pub.CREATION_DATE,
635: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,
636: hz_utility_pub.LAST_UPDATED_BY );
637: end if;
638: else

Line 635: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,

631: l_last_updated_by,l_last_update_date,l_last_update_login,l_quote_header_id,
632: l_quote_sharee_number,l_update_privilege_type_code,l_security_group_id,l_party_id,
633: l_cust_account_id,l_start_date_active,l_end_date_active,l_recipient_name,
634: l_contact_point_id,'D',req_id,hz_utility_pub.CREATED_BY, hz_utility_pub.CREATION_DATE,
635: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,
636: hz_utility_pub.LAST_UPDATED_BY );
637: end if;
638: else
639: --if shared cart not a duplicate of , update party/account ID to merge to

Line 636: hz_utility_pub.LAST_UPDATED_BY );

632: l_quote_sharee_number,l_update_privilege_type_code,l_security_group_id,l_party_id,
633: l_cust_account_id,l_start_date_active,l_end_date_active,l_recipient_name,
634: l_contact_point_id,'D',req_id,hz_utility_pub.CREATED_BY, hz_utility_pub.CREATION_DATE,
635: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,
636: hz_utility_pub.LAST_UPDATED_BY );
637: end if;
638: else
639: --if shared cart not a duplicate of , update party/account ID to merge to
640: arp_message.set_name('AR', 'AR_UPDATING_TABLE');

Line 660: l_to_acct_id, l_from_party_id, l_to_party_id,'U',req_id,hz_utility_pub.CREATED_BY,

656: LAST_UPDATE_DATE,LAST_UPDATED_BY
657: ) VALUES (
658: HZ_CUSTOMER_MERGE_LOG_s.nextval,
659: 'IBE_SH_QUOTE_ACCESS',l_customer_merge_header_id,l_from_quote_sharee_id,l_from_acct_id,
660: l_to_acct_id, l_from_party_id, l_to_party_id,'U',req_id,hz_utility_pub.CREATED_BY,
661: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,hz_utility_pub.LAST_UPDATE_DATE,
662: hz_utility_pub.LAST_UPDATED_BY
663: );
664: end if;

Line 661: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,hz_utility_pub.LAST_UPDATE_DATE,

657: ) VALUES (
658: HZ_CUSTOMER_MERGE_LOG_s.nextval,
659: 'IBE_SH_QUOTE_ACCESS',l_customer_merge_header_id,l_from_quote_sharee_id,l_from_acct_id,
660: l_to_acct_id, l_from_party_id, l_to_party_id,'U',req_id,hz_utility_pub.CREATED_BY,
661: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,hz_utility_pub.LAST_UPDATE_DATE,
662: hz_utility_pub.LAST_UPDATED_BY
663: );
664: end if;
665: --update shared cart

Line 662: hz_utility_pub.LAST_UPDATED_BY

658: HZ_CUSTOMER_MERGE_LOG_s.nextval,
659: 'IBE_SH_QUOTE_ACCESS',l_customer_merge_header_id,l_from_quote_sharee_id,l_from_acct_id,
660: l_to_acct_id, l_from_party_id, l_to_party_id,'U',req_id,hz_utility_pub.CREATED_BY,
661: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,hz_utility_pub.LAST_UPDATE_DATE,
662: hz_utility_pub.LAST_UPDATED_BY
663: );
664: end if;
665: --update shared cart
666:

Line 670: last_update_date = hz_utility_pub.last_update_date,

666:
667: UPDATE IBE_SH_QUOTE_ACCESS ISQ SET
668: party_id = l_to_party_id,
669: cust_account_id = l_to_acct_id,
670: last_update_date = hz_utility_pub.last_update_date,
671: last_updated_by = hz_utility_pub.user_id,
672: last_update_login = hz_utility_pub.last_update_login,
673: request_id = hz_utility_pub.request_id,
674: program_application_id = hz_utility_pub.program_application_id,

Line 671: last_updated_by = hz_utility_pub.user_id,

667: UPDATE IBE_SH_QUOTE_ACCESS ISQ SET
668: party_id = l_to_party_id,
669: cust_account_id = l_to_acct_id,
670: last_update_date = hz_utility_pub.last_update_date,
671: last_updated_by = hz_utility_pub.user_id,
672: last_update_login = hz_utility_pub.last_update_login,
673: request_id = hz_utility_pub.request_id,
674: program_application_id = hz_utility_pub.program_application_id,
675: program_id = hz_utility_pub.program_id,

Line 672: last_update_login = hz_utility_pub.last_update_login,

668: party_id = l_to_party_id,
669: cust_account_id = l_to_acct_id,
670: last_update_date = hz_utility_pub.last_update_date,
671: last_updated_by = hz_utility_pub.user_id,
672: last_update_login = hz_utility_pub.last_update_login,
673: request_id = hz_utility_pub.request_id,
674: program_application_id = hz_utility_pub.program_application_id,
675: program_id = hz_utility_pub.program_id,
676: program_update_date = sysdate

Line 673: request_id = hz_utility_pub.request_id,

669: cust_account_id = l_to_acct_id,
670: last_update_date = hz_utility_pub.last_update_date,
671: last_updated_by = hz_utility_pub.user_id,
672: last_update_login = hz_utility_pub.last_update_login,
673: request_id = hz_utility_pub.request_id,
674: program_application_id = hz_utility_pub.program_application_id,
675: program_id = hz_utility_pub.program_id,
676: program_update_date = sysdate
677: Where cust_account_id = l_from_acct_id

Line 674: program_application_id = hz_utility_pub.program_application_id,

670: last_update_date = hz_utility_pub.last_update_date,
671: last_updated_by = hz_utility_pub.user_id,
672: last_update_login = hz_utility_pub.last_update_login,
673: request_id = hz_utility_pub.request_id,
674: program_application_id = hz_utility_pub.program_application_id,
675: program_id = hz_utility_pub.program_id,
676: program_update_date = sysdate
677: Where cust_account_id = l_from_acct_id
678: And party_id = l_from_party_id

Line 675: program_id = hz_utility_pub.program_id,

671: last_updated_by = hz_utility_pub.user_id,
672: last_update_login = hz_utility_pub.last_update_login,
673: request_id = hz_utility_pub.request_id,
674: program_application_id = hz_utility_pub.program_application_id,
675: program_id = hz_utility_pub.program_id,
676: program_update_date = sysdate
677: Where cust_account_id = l_from_acct_id
678: And party_id = l_from_party_id
679: And quote_header_id = l_from_quote_id;

Line 949: last_update_date = hz_utility_pub.last_update_date,

945: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
946:
947: UPDATE IBE_SH_SHP_LISTS_ALL isl SET
948: party_id = p_to_fk_id,
949: last_update_date = hz_utility_pub.last_update_date,
950: last_updated_by = hz_utility_pub.user_id,
951: last_update_login = hz_utility_pub.last_update_login,
952: request_id = hz_utility_pub.request_id,
953: program_application_id = hz_utility_pub.program_application_id,

Line 950: last_updated_by = hz_utility_pub.user_id,

946:
947: UPDATE IBE_SH_SHP_LISTS_ALL isl SET
948: party_id = p_to_fk_id,
949: last_update_date = hz_utility_pub.last_update_date,
950: last_updated_by = hz_utility_pub.user_id,
951: last_update_login = hz_utility_pub.last_update_login,
952: request_id = hz_utility_pub.request_id,
953: program_application_id = hz_utility_pub.program_application_id,
954: program_id = hz_utility_pub.program_id,

Line 951: last_update_login = hz_utility_pub.last_update_login,

947: UPDATE IBE_SH_SHP_LISTS_ALL isl SET
948: party_id = p_to_fk_id,
949: last_update_date = hz_utility_pub.last_update_date,
950: last_updated_by = hz_utility_pub.user_id,
951: last_update_login = hz_utility_pub.last_update_login,
952: request_id = hz_utility_pub.request_id,
953: program_application_id = hz_utility_pub.program_application_id,
954: program_id = hz_utility_pub.program_id,
955: program_update_date = sysdate

Line 952: request_id = hz_utility_pub.request_id,

948: party_id = p_to_fk_id,
949: last_update_date = hz_utility_pub.last_update_date,
950: last_updated_by = hz_utility_pub.user_id,
951: last_update_login = hz_utility_pub.last_update_login,
952: request_id = hz_utility_pub.request_id,
953: program_application_id = hz_utility_pub.program_application_id,
954: program_id = hz_utility_pub.program_id,
955: program_update_date = sysdate
956: Where party_id = p_from_fk_id;

Line 953: program_application_id = hz_utility_pub.program_application_id,

949: last_update_date = hz_utility_pub.last_update_date,
950: last_updated_by = hz_utility_pub.user_id,
951: last_update_login = hz_utility_pub.last_update_login,
952: request_id = hz_utility_pub.request_id,
953: program_application_id = hz_utility_pub.program_application_id,
954: program_id = hz_utility_pub.program_id,
955: program_update_date = sysdate
956: Where party_id = p_from_fk_id;
957:

Line 954: program_id = hz_utility_pub.program_id,

950: last_updated_by = hz_utility_pub.user_id,
951: last_update_login = hz_utility_pub.last_update_login,
952: request_id = hz_utility_pub.request_id,
953: program_application_id = hz_utility_pub.program_application_id,
954: program_id = hz_utility_pub.program_id,
955: program_update_date = sysdate
956: Where party_id = p_from_fk_id;
957:
958:

Line 1134: last_update_date = hz_utility_pub.last_update_date,

1130:
1131: BEGIN
1132: UPDATE IBE_ORD_ONECLICK_ALL SET
1133: party_id = p_to_fk_id,
1134: last_update_date = hz_utility_pub.last_update_date,
1135: last_updated_by = hz_utility_pub.user_id,
1136: last_update_login = hz_utility_pub.last_update_login
1137: Where party_id = p_from_fk_id;
1138: EXCEPTION WHEN OTHERS THEN

Line 1135: last_updated_by = hz_utility_pub.user_id,

1131: BEGIN
1132: UPDATE IBE_ORD_ONECLICK_ALL SET
1133: party_id = p_to_fk_id,
1134: last_update_date = hz_utility_pub.last_update_date,
1135: last_updated_by = hz_utility_pub.user_id,
1136: last_update_login = hz_utility_pub.last_update_login
1137: Where party_id = p_from_fk_id;
1138: EXCEPTION WHEN OTHERS THEN
1139: NULL;

Line 1136: last_update_login = hz_utility_pub.last_update_login

1132: UPDATE IBE_ORD_ONECLICK_ALL SET
1133: party_id = p_to_fk_id,
1134: last_update_date = hz_utility_pub.last_update_date,
1135: last_updated_by = hz_utility_pub.user_id,
1136: last_update_login = hz_utility_pub.last_update_login
1137: Where party_id = p_from_fk_id;
1138: EXCEPTION WHEN OTHERS THEN
1139: NULL;
1140: END;

Line 1174: last_update_date = hz_utility_pub.last_update_date,

1170:
1171: UPDATE IBE_ORD_ONECLICK_ALL SET
1172: bill_to_pty_site_id = decode(bill_to_pty_site_id,p_from_fk_id,p_to_fk_id,bill_to_pty_site_id),
1173: ship_to_pty_site_id = decode(ship_to_pty_site_id,p_from_fk_id,p_to_fk_id,ship_to_pty_site_id),
1174: last_update_date = hz_utility_pub.last_update_date,
1175: last_updated_by = hz_utility_pub.user_id,
1176: last_update_login = hz_utility_pub.last_update_login
1177: Where bill_to_pty_site_id= p_from_fk_id
1178: Or ship_to_pty_site_id = p_from_fk_id;

Line 1175: last_updated_by = hz_utility_pub.user_id,

1171: UPDATE IBE_ORD_ONECLICK_ALL SET
1172: bill_to_pty_site_id = decode(bill_to_pty_site_id,p_from_fk_id,p_to_fk_id,bill_to_pty_site_id),
1173: ship_to_pty_site_id = decode(ship_to_pty_site_id,p_from_fk_id,p_to_fk_id,ship_to_pty_site_id),
1174: last_update_date = hz_utility_pub.last_update_date,
1175: last_updated_by = hz_utility_pub.user_id,
1176: last_update_login = hz_utility_pub.last_update_login
1177: Where bill_to_pty_site_id= p_from_fk_id
1178: Or ship_to_pty_site_id = p_from_fk_id;
1179:

Line 1176: last_update_login = hz_utility_pub.last_update_login

1172: bill_to_pty_site_id = decode(bill_to_pty_site_id,p_from_fk_id,p_to_fk_id,bill_to_pty_site_id),
1173: ship_to_pty_site_id = decode(ship_to_pty_site_id,p_from_fk_id,p_to_fk_id,ship_to_pty_site_id),
1174: last_update_date = hz_utility_pub.last_update_date,
1175: last_updated_by = hz_utility_pub.user_id,
1176: last_update_login = hz_utility_pub.last_update_login
1177: Where bill_to_pty_site_id= p_from_fk_id
1178: Or ship_to_pty_site_id = p_from_fk_id;
1179:
1180: l_count := sql%rowcount;

Line 1320: last_update_date = hz_utility_pub.last_update_date,

1316: -- only merge when both & are BOTH on
1317: -- and doesn't have restrictions on the minisite
1318: UPDATE IBE_MSITE_PRTY_ACCSS
1319: SET party_id = p_to_fk_id,
1320: last_update_date = hz_utility_pub.last_update_date,
1321: last_updated_by = hz_utility_pub.user_id,
1322: last_update_login = hz_utility_pub.last_update_login
1323: Where party_id = p_from_fk_id and exists (
1324: select 1 from IBE_MSITE_PRTY_ACCSS a, IBE_MSITES_B b

Line 1321: last_updated_by = hz_utility_pub.user_id,

1317: -- and doesn't have restrictions on the minisite
1318: UPDATE IBE_MSITE_PRTY_ACCSS
1319: SET party_id = p_to_fk_id,
1320: last_update_date = hz_utility_pub.last_update_date,
1321: last_updated_by = hz_utility_pub.user_id,
1322: last_update_login = hz_utility_pub.last_update_login
1323: Where party_id = p_from_fk_id and exists (
1324: select 1 from IBE_MSITE_PRTY_ACCSS a, IBE_MSITES_B b
1325: where party_id=p_to_fk_id and a.msite_id<>l_msite_id

Line 1322: last_update_login = hz_utility_pub.last_update_login

1318: UPDATE IBE_MSITE_PRTY_ACCSS
1319: SET party_id = p_to_fk_id,
1320: last_update_date = hz_utility_pub.last_update_date,
1321: last_updated_by = hz_utility_pub.user_id,
1322: last_update_login = hz_utility_pub.last_update_login
1323: Where party_id = p_from_fk_id and exists (
1324: select 1 from IBE_MSITE_PRTY_ACCSS a, IBE_MSITES_B b
1325: where party_id=p_to_fk_id and a.msite_id<>l_msite_id
1326: and a.msite_id = b.msite_id and b.party_access_code = l_party_access_code

Line 1484: last_update_date = hz_utility_pub.last_update_date,

1480: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1481:
1482: UPDATE IBE_SH_QUOTE_ACCESS SET
1483: party_id = p_to_fk_id,
1484: last_update_date = hz_utility_pub.last_update_date,
1485: last_updated_by = hz_utility_pub.user_id,
1486: last_update_login = hz_utility_pub.last_update_login,
1487: request_id = hz_utility_pub.request_id,
1488: program_application_id = hz_utility_pub.program_application_id,

Line 1485: last_updated_by = hz_utility_pub.user_id,

1481:
1482: UPDATE IBE_SH_QUOTE_ACCESS SET
1483: party_id = p_to_fk_id,
1484: last_update_date = hz_utility_pub.last_update_date,
1485: last_updated_by = hz_utility_pub.user_id,
1486: last_update_login = hz_utility_pub.last_update_login,
1487: request_id = hz_utility_pub.request_id,
1488: program_application_id = hz_utility_pub.program_application_id,
1489: program_id = hz_utility_pub.program_id,

Line 1486: last_update_login = hz_utility_pub.last_update_login,

1482: UPDATE IBE_SH_QUOTE_ACCESS SET
1483: party_id = p_to_fk_id,
1484: last_update_date = hz_utility_pub.last_update_date,
1485: last_updated_by = hz_utility_pub.user_id,
1486: last_update_login = hz_utility_pub.last_update_login,
1487: request_id = hz_utility_pub.request_id,
1488: program_application_id = hz_utility_pub.program_application_id,
1489: program_id = hz_utility_pub.program_id,
1490: program_update_date = sysdate

Line 1487: request_id = hz_utility_pub.request_id,

1483: party_id = p_to_fk_id,
1484: last_update_date = hz_utility_pub.last_update_date,
1485: last_updated_by = hz_utility_pub.user_id,
1486: last_update_login = hz_utility_pub.last_update_login,
1487: request_id = hz_utility_pub.request_id,
1488: program_application_id = hz_utility_pub.program_application_id,
1489: program_id = hz_utility_pub.program_id,
1490: program_update_date = sysdate
1491: Where party_id = p_from_fk_id

Line 1488: program_application_id = hz_utility_pub.program_application_id,

1484: last_update_date = hz_utility_pub.last_update_date,
1485: last_updated_by = hz_utility_pub.user_id,
1486: last_update_login = hz_utility_pub.last_update_login,
1487: request_id = hz_utility_pub.request_id,
1488: program_application_id = hz_utility_pub.program_application_id,
1489: program_id = hz_utility_pub.program_id,
1490: program_update_date = sysdate
1491: Where party_id = p_from_fk_id
1492: And cust_account_id = l_from_cust_account_id

Line 1489: program_id = hz_utility_pub.program_id,

1485: last_updated_by = hz_utility_pub.user_id,
1486: last_update_login = hz_utility_pub.last_update_login,
1487: request_id = hz_utility_pub.request_id,
1488: program_application_id = hz_utility_pub.program_application_id,
1489: program_id = hz_utility_pub.program_id,
1490: program_update_date = sysdate
1491: Where party_id = p_from_fk_id
1492: And cust_account_id = l_from_cust_account_id
1493: And quote_header_id = l_quote_header_id;

Line 1507: last_update_date = hz_utility_pub.last_update_date,

1503: from hz_contact_points
1504: where contact_point_id=p_from_fk_id and owner_table_name<>'IBE_SH_QUOTE_ACCESS';
1505: UPDATE IBE_SH_QUOTE_ACCESS SET
1506: contact_point_id = p_to_fk_id,
1507: last_update_date = hz_utility_pub.last_update_date,
1508: last_updated_by = hz_utility_pub.user_id,
1509: last_update_login = hz_utility_pub.last_update_login,
1510: request_id = hz_utility_pub.request_id,
1511: program_application_id = hz_utility_pub.program_application_id,

Line 1508: last_updated_by = hz_utility_pub.user_id,

1504: where contact_point_id=p_from_fk_id and owner_table_name<>'IBE_SH_QUOTE_ACCESS';
1505: UPDATE IBE_SH_QUOTE_ACCESS SET
1506: contact_point_id = p_to_fk_id,
1507: last_update_date = hz_utility_pub.last_update_date,
1508: last_updated_by = hz_utility_pub.user_id,
1509: last_update_login = hz_utility_pub.last_update_login,
1510: request_id = hz_utility_pub.request_id,
1511: program_application_id = hz_utility_pub.program_application_id,
1512: program_id = hz_utility_pub.program_id,

Line 1509: last_update_login = hz_utility_pub.last_update_login,

1505: UPDATE IBE_SH_QUOTE_ACCESS SET
1506: contact_point_id = p_to_fk_id,
1507: last_update_date = hz_utility_pub.last_update_date,
1508: last_updated_by = hz_utility_pub.user_id,
1509: last_update_login = hz_utility_pub.last_update_login,
1510: request_id = hz_utility_pub.request_id,
1511: program_application_id = hz_utility_pub.program_application_id,
1512: program_id = hz_utility_pub.program_id,
1513: program_update_date = sysdate

Line 1510: request_id = hz_utility_pub.request_id,

1506: contact_point_id = p_to_fk_id,
1507: last_update_date = hz_utility_pub.last_update_date,
1508: last_updated_by = hz_utility_pub.user_id,
1509: last_update_login = hz_utility_pub.last_update_login,
1510: request_id = hz_utility_pub.request_id,
1511: program_application_id = hz_utility_pub.program_application_id,
1512: program_id = hz_utility_pub.program_id,
1513: program_update_date = sysdate
1514: Where contact_point_id = p_from_fk_id;

Line 1511: program_application_id = hz_utility_pub.program_application_id,

1507: last_update_date = hz_utility_pub.last_update_date,
1508: last_updated_by = hz_utility_pub.user_id,
1509: last_update_login = hz_utility_pub.last_update_login,
1510: request_id = hz_utility_pub.request_id,
1511: program_application_id = hz_utility_pub.program_application_id,
1512: program_id = hz_utility_pub.program_id,
1513: program_update_date = sysdate
1514: Where contact_point_id = p_from_fk_id;
1515:

Line 1512: program_id = hz_utility_pub.program_id,

1508: last_updated_by = hz_utility_pub.user_id,
1509: last_update_login = hz_utility_pub.last_update_login,
1510: request_id = hz_utility_pub.request_id,
1511: program_application_id = hz_utility_pub.program_application_id,
1512: program_id = hz_utility_pub.program_id,
1513: program_update_date = sysdate
1514: Where contact_point_id = p_from_fk_id;
1515:
1516: EXCEPTION