APPS.IBE_MERGE_PVT dependencies on HZ_UTILITY_PUB

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

186: LAST_UPDATED_BY,LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, ENABLED_FLAG, FREIGHT_CODE, PAYMENT_ID,
187: BILL_TO_PTY_SITE_ID, SHIP_TO_PTY_SITE_ID,ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
188: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11,
189: ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, SECURITY_GROUP_ID, REQUEST_ID, PROGRAM_ID,
190: PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, ORG_ID, 'D',hz_utility_pub.CREATED_BY,
191: hz_utility_pub.CREATION_DATE, hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,
192: hz_utility_pub.LAST_UPDATED_BY
193: from IBE_ORD_ONECLICK_ALL where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);
194: end if;

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

187: BILL_TO_PTY_SITE_ID, SHIP_TO_PTY_SITE_ID,ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
188: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11,
189: ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, SECURITY_GROUP_ID, REQUEST_ID, PROGRAM_ID,
190: PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, ORG_ID, 'D',hz_utility_pub.CREATED_BY,
191: hz_utility_pub.CREATION_DATE, hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,
192: hz_utility_pub.LAST_UPDATED_BY
193: from IBE_ORD_ONECLICK_ALL where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);
194: end if;
195: delete IBE_ORD_ONECLICK_ALL

Line 192: hz_utility_pub.LAST_UPDATED_BY

188: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11,
189: ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, SECURITY_GROUP_ID, REQUEST_ID, PROGRAM_ID,
190: PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, ORG_ID, 'D',hz_utility_pub.CREATED_BY,
191: hz_utility_pub.CREATION_DATE, hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,
192: hz_utility_pub.LAST_UPDATED_BY
193: from IBE_ORD_ONECLICK_ALL where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);
194: end if;
195: delete IBE_ORD_ONECLICK_ALL
196: where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);

Line 345: hz_utility_pub.CREATED_BY,

341: NUM_COL2_ORIG_LIST(I),
342: NUM_COL2_NEW_LIST(I),
343: 'U',
344: req_id,
345: hz_utility_pub.CREATED_BY,
346: hz_utility_pub.CREATION_DATE,
347: hz_utility_pub.LAST_UPDATE_LOGIN,
348: hz_utility_pub.LAST_UPDATE_DATE,
349: hz_utility_pub.LAST_UPDATED_BY

Line 346: hz_utility_pub.CREATION_DATE,

342: NUM_COL2_NEW_LIST(I),
343: 'U',
344: req_id,
345: hz_utility_pub.CREATED_BY,
346: hz_utility_pub.CREATION_DATE,
347: hz_utility_pub.LAST_UPDATE_LOGIN,
348: hz_utility_pub.LAST_UPDATE_DATE,
349: hz_utility_pub.LAST_UPDATED_BY
350: );

Line 347: hz_utility_pub.LAST_UPDATE_LOGIN,

343: 'U',
344: req_id,
345: hz_utility_pub.CREATED_BY,
346: hz_utility_pub.CREATION_DATE,
347: hz_utility_pub.LAST_UPDATE_LOGIN,
348: hz_utility_pub.LAST_UPDATE_DATE,
349: hz_utility_pub.LAST_UPDATED_BY
350: );
351:

Line 348: hz_utility_pub.LAST_UPDATE_DATE,

344: req_id,
345: hz_utility_pub.CREATED_BY,
346: hz_utility_pub.CREATION_DATE,
347: hz_utility_pub.LAST_UPDATE_LOGIN,
348: hz_utility_pub.LAST_UPDATE_DATE,
349: hz_utility_pub.LAST_UPDATED_BY
350: );
351:
352:

Line 349: hz_utility_pub.LAST_UPDATED_BY

345: hz_utility_pub.CREATED_BY,
346: hz_utility_pub.CREATION_DATE,
347: hz_utility_pub.LAST_UPDATE_LOGIN,
348: hz_utility_pub.LAST_UPDATE_DATE,
349: hz_utility_pub.LAST_UPDATED_BY
350: );
351:
352:
353: END IF;

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

458: CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY
459: ) VALUES (
460: HZ_CUSTOMER_MERGE_LOG_s.nextval,'ASO_QUOTE_HEADERS_ALL',
461: l_customer_merge_id,l_from_quote_id,'IBE_PRMT_SC_UNNAMED','IBE_PRMT_SC_DEFAULTNAMED',
462: 'U',req_id,hz_utility_pub.CREATED_BY,
463: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,
464: hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY
465: );
466: end if;

Line 463: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,

459: ) VALUES (
460: HZ_CUSTOMER_MERGE_LOG_s.nextval,'ASO_QUOTE_HEADERS_ALL',
461: l_customer_merge_id,l_from_quote_id,'IBE_PRMT_SC_UNNAMED','IBE_PRMT_SC_DEFAULTNAMED',
462: 'U',req_id,hz_utility_pub.CREATED_BY,
463: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,
464: hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY
465: );
466: end if;
467:

Line 464: hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY

460: HZ_CUSTOMER_MERGE_LOG_s.nextval,'ASO_QUOTE_HEADERS_ALL',
461: l_customer_merge_id,l_from_quote_id,'IBE_PRMT_SC_UNNAMED','IBE_PRMT_SC_DEFAULTNAMED',
462: 'U',req_id,hz_utility_pub.CREATED_BY,
463: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,
464: hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY
465: );
466: end if;
467:
468: --log data when audit profile is On

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

473: CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY)
474: select HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_ACTIVE_QUOTES_ALL',l_customer_merge_id
475: ,req_id,ACTIVE_QUOTE_ID,PARTY_ID,CUST_ACCOUNT_ID,ORG_ID,CREATED_BY,CREATION_DATE
476: ,LAST_UPDATED_BY,LAST_UPDATE_DATE,OBJECT_VERSION_NUMBER,LAST_UPDATE_LOGIN
477: ,SECURITY_GROUP_ID,QUOTE_HEADER_ID,'D',hz_utility_pub.CREATED_BY,hz_utility_pub.CREATION_DATE,
478: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY
479: from ibe_active_quotes_all where quote_header_id=l_from_quote_id
480: and cust_account_id = l_from_acct_id and party_id=l_from_party_id;
481:

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

474: select HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_ACTIVE_QUOTES_ALL',l_customer_merge_id
475: ,req_id,ACTIVE_QUOTE_ID,PARTY_ID,CUST_ACCOUNT_ID,ORG_ID,CREATED_BY,CREATION_DATE
476: ,LAST_UPDATED_BY,LAST_UPDATE_DATE,OBJECT_VERSION_NUMBER,LAST_UPDATE_LOGIN
477: ,SECURITY_GROUP_ID,QUOTE_HEADER_ID,'D',hz_utility_pub.CREATED_BY,hz_utility_pub.CREATION_DATE,
478: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY
479: from ibe_active_quotes_all where quote_header_id=l_from_quote_id
480: and cust_account_id = l_from_acct_id and party_id=l_from_party_id;
481:
482: end if;

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

642: l_program_update_date,l_object_version_number,l_created_by,l_creation_date,
643: l_last_updated_by,l_last_update_date,l_last_update_login,l_quote_header_id,
644: l_quote_sharee_number,l_update_privilege_type_code,l_security_group_id,l_party_id,
645: l_cust_account_id,l_start_date_active,l_end_date_active,l_recipient_name,
646: l_contact_point_id,'D',req_id,hz_utility_pub.CREATED_BY, hz_utility_pub.CREATION_DATE,
647: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,
648: hz_utility_pub.LAST_UPDATED_BY );
649: end if;
650: else

Line 647: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,

643: l_last_updated_by,l_last_update_date,l_last_update_login,l_quote_header_id,
644: l_quote_sharee_number,l_update_privilege_type_code,l_security_group_id,l_party_id,
645: l_cust_account_id,l_start_date_active,l_end_date_active,l_recipient_name,
646: l_contact_point_id,'D',req_id,hz_utility_pub.CREATED_BY, hz_utility_pub.CREATION_DATE,
647: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,
648: hz_utility_pub.LAST_UPDATED_BY );
649: end if;
650: else
651: --if shared cart not a duplicate of , update party/account ID to merge to

Line 648: hz_utility_pub.LAST_UPDATED_BY );

644: l_quote_sharee_number,l_update_privilege_type_code,l_security_group_id,l_party_id,
645: l_cust_account_id,l_start_date_active,l_end_date_active,l_recipient_name,
646: l_contact_point_id,'D',req_id,hz_utility_pub.CREATED_BY, hz_utility_pub.CREATION_DATE,
647: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,
648: hz_utility_pub.LAST_UPDATED_BY );
649: end if;
650: else
651: --if shared cart not a duplicate of , update party/account ID to merge to
652: arp_message.set_name('AR', 'AR_UPDATING_TABLE');

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

668: LAST_UPDATE_DATE,LAST_UPDATED_BY
669: ) VALUES (
670: HZ_CUSTOMER_MERGE_LOG_s.nextval,
671: 'IBE_SH_QUOTE_ACCESS',l_customer_merge_header_id,l_from_quote_sharee_id,l_from_acct_id,
672: l_to_acct_id, l_from_party_id, l_to_party_id,'U',req_id,hz_utility_pub.CREATED_BY,
673: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,hz_utility_pub.LAST_UPDATE_DATE,
674: hz_utility_pub.LAST_UPDATED_BY
675: );
676: end if;

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

669: ) VALUES (
670: HZ_CUSTOMER_MERGE_LOG_s.nextval,
671: 'IBE_SH_QUOTE_ACCESS',l_customer_merge_header_id,l_from_quote_sharee_id,l_from_acct_id,
672: l_to_acct_id, l_from_party_id, l_to_party_id,'U',req_id,hz_utility_pub.CREATED_BY,
673: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,hz_utility_pub.LAST_UPDATE_DATE,
674: hz_utility_pub.LAST_UPDATED_BY
675: );
676: end if;
677: --update shared cart

Line 674: hz_utility_pub.LAST_UPDATED_BY

670: HZ_CUSTOMER_MERGE_LOG_s.nextval,
671: 'IBE_SH_QUOTE_ACCESS',l_customer_merge_header_id,l_from_quote_sharee_id,l_from_acct_id,
672: l_to_acct_id, l_from_party_id, l_to_party_id,'U',req_id,hz_utility_pub.CREATED_BY,
673: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,hz_utility_pub.LAST_UPDATE_DATE,
674: hz_utility_pub.LAST_UPDATED_BY
675: );
676: end if;
677: --update shared cart
678:

Line 682: last_update_date = hz_utility_pub.last_update_date,

678:
679: UPDATE IBE_SH_QUOTE_ACCESS ISQ SET
680: party_id = l_to_party_id,
681: cust_account_id = l_to_acct_id,
682: last_update_date = hz_utility_pub.last_update_date,
683: last_updated_by = hz_utility_pub.user_id,
684: last_update_login = hz_utility_pub.last_update_login,
685: request_id = hz_utility_pub.request_id,
686: program_application_id = hz_utility_pub.program_application_id,

Line 683: last_updated_by = hz_utility_pub.user_id,

679: UPDATE IBE_SH_QUOTE_ACCESS ISQ SET
680: party_id = l_to_party_id,
681: cust_account_id = l_to_acct_id,
682: last_update_date = hz_utility_pub.last_update_date,
683: last_updated_by = hz_utility_pub.user_id,
684: last_update_login = hz_utility_pub.last_update_login,
685: request_id = hz_utility_pub.request_id,
686: program_application_id = hz_utility_pub.program_application_id,
687: program_id = hz_utility_pub.program_id,

Line 684: last_update_login = hz_utility_pub.last_update_login,

680: party_id = l_to_party_id,
681: cust_account_id = l_to_acct_id,
682: last_update_date = hz_utility_pub.last_update_date,
683: last_updated_by = hz_utility_pub.user_id,
684: last_update_login = hz_utility_pub.last_update_login,
685: request_id = hz_utility_pub.request_id,
686: program_application_id = hz_utility_pub.program_application_id,
687: program_id = hz_utility_pub.program_id,
688: program_update_date = sysdate

Line 685: request_id = hz_utility_pub.request_id,

681: cust_account_id = l_to_acct_id,
682: last_update_date = hz_utility_pub.last_update_date,
683: last_updated_by = hz_utility_pub.user_id,
684: last_update_login = hz_utility_pub.last_update_login,
685: request_id = hz_utility_pub.request_id,
686: program_application_id = hz_utility_pub.program_application_id,
687: program_id = hz_utility_pub.program_id,
688: program_update_date = sysdate
689: Where cust_account_id = l_from_acct_id

Line 686: program_application_id = hz_utility_pub.program_application_id,

682: last_update_date = hz_utility_pub.last_update_date,
683: last_updated_by = hz_utility_pub.user_id,
684: last_update_login = hz_utility_pub.last_update_login,
685: request_id = hz_utility_pub.request_id,
686: program_application_id = hz_utility_pub.program_application_id,
687: program_id = hz_utility_pub.program_id,
688: program_update_date = sysdate
689: Where cust_account_id = l_from_acct_id
690: And party_id = l_from_party_id

Line 687: program_id = hz_utility_pub.program_id,

683: last_updated_by = hz_utility_pub.user_id,
684: last_update_login = hz_utility_pub.last_update_login,
685: request_id = hz_utility_pub.request_id,
686: program_application_id = hz_utility_pub.program_application_id,
687: program_id = hz_utility_pub.program_id,
688: program_update_date = sysdate
689: Where cust_account_id = l_from_acct_id
690: And party_id = l_from_party_id
691: And quote_header_id = l_from_quote_id;

Line 996: last_update_date = hz_utility_pub.last_update_date,

992: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
993:
994: UPDATE IBE_SH_SHP_LISTS_ALL isl SET
995: party_id = p_to_fk_id,
996: last_update_date = hz_utility_pub.last_update_date,
997: last_updated_by = hz_utility_pub.user_id,
998: last_update_login = hz_utility_pub.last_update_login,
999: request_id = hz_utility_pub.request_id,
1000: program_application_id = hz_utility_pub.program_application_id,

Line 997: last_updated_by = hz_utility_pub.user_id,

993:
994: UPDATE IBE_SH_SHP_LISTS_ALL isl SET
995: party_id = p_to_fk_id,
996: last_update_date = hz_utility_pub.last_update_date,
997: last_updated_by = hz_utility_pub.user_id,
998: last_update_login = hz_utility_pub.last_update_login,
999: request_id = hz_utility_pub.request_id,
1000: program_application_id = hz_utility_pub.program_application_id,
1001: program_id = hz_utility_pub.program_id,

Line 998: last_update_login = hz_utility_pub.last_update_login,

994: UPDATE IBE_SH_SHP_LISTS_ALL isl SET
995: party_id = p_to_fk_id,
996: last_update_date = hz_utility_pub.last_update_date,
997: last_updated_by = hz_utility_pub.user_id,
998: last_update_login = hz_utility_pub.last_update_login,
999: request_id = hz_utility_pub.request_id,
1000: program_application_id = hz_utility_pub.program_application_id,
1001: program_id = hz_utility_pub.program_id,
1002: program_update_date = sysdate

Line 999: request_id = hz_utility_pub.request_id,

995: party_id = p_to_fk_id,
996: last_update_date = hz_utility_pub.last_update_date,
997: last_updated_by = hz_utility_pub.user_id,
998: last_update_login = hz_utility_pub.last_update_login,
999: request_id = hz_utility_pub.request_id,
1000: program_application_id = hz_utility_pub.program_application_id,
1001: program_id = hz_utility_pub.program_id,
1002: program_update_date = sysdate
1003: Where party_id = p_from_fk_id;

Line 1000: program_application_id = hz_utility_pub.program_application_id,

996: last_update_date = hz_utility_pub.last_update_date,
997: last_updated_by = hz_utility_pub.user_id,
998: last_update_login = hz_utility_pub.last_update_login,
999: request_id = hz_utility_pub.request_id,
1000: program_application_id = hz_utility_pub.program_application_id,
1001: program_id = hz_utility_pub.program_id,
1002: program_update_date = sysdate
1003: Where party_id = p_from_fk_id;
1004:

Line 1001: program_id = hz_utility_pub.program_id,

997: last_updated_by = hz_utility_pub.user_id,
998: last_update_login = hz_utility_pub.last_update_login,
999: request_id = hz_utility_pub.request_id,
1000: program_application_id = hz_utility_pub.program_application_id,
1001: program_id = hz_utility_pub.program_id,
1002: program_update_date = sysdate
1003: Where party_id = p_from_fk_id;
1004:
1005:

Line 1179: last_update_date = hz_utility_pub.last_update_date,

1175:
1176: BEGIN
1177: UPDATE IBE_ORD_ONECLICK_ALL SET
1178: party_id = p_to_fk_id,
1179: last_update_date = hz_utility_pub.last_update_date,
1180: last_updated_by = hz_utility_pub.user_id,
1181: last_update_login = hz_utility_pub.last_update_login
1182: Where party_id = p_from_fk_id;
1183: EXCEPTION WHEN OTHERS THEN

Line 1180: last_updated_by = hz_utility_pub.user_id,

1176: BEGIN
1177: UPDATE IBE_ORD_ONECLICK_ALL SET
1178: party_id = p_to_fk_id,
1179: last_update_date = hz_utility_pub.last_update_date,
1180: last_updated_by = hz_utility_pub.user_id,
1181: last_update_login = hz_utility_pub.last_update_login
1182: Where party_id = p_from_fk_id;
1183: EXCEPTION WHEN OTHERS THEN
1184: NULL;

Line 1181: last_update_login = hz_utility_pub.last_update_login

1177: UPDATE IBE_ORD_ONECLICK_ALL SET
1178: party_id = p_to_fk_id,
1179: last_update_date = hz_utility_pub.last_update_date,
1180: last_updated_by = hz_utility_pub.user_id,
1181: last_update_login = hz_utility_pub.last_update_login
1182: Where party_id = p_from_fk_id;
1183: EXCEPTION WHEN OTHERS THEN
1184: NULL;
1185: END;

Line 1219: last_update_date = hz_utility_pub.last_update_date,

1215:
1216: UPDATE IBE_ORD_ONECLICK_ALL SET
1217: bill_to_pty_site_id = decode(bill_to_pty_site_id,p_from_fk_id,p_to_fk_id,bill_to_pty_site_id),
1218: ship_to_pty_site_id = decode(ship_to_pty_site_id,p_from_fk_id,p_to_fk_id,ship_to_pty_site_id),
1219: last_update_date = hz_utility_pub.last_update_date,
1220: last_updated_by = hz_utility_pub.user_id,
1221: last_update_login = hz_utility_pub.last_update_login
1222: Where bill_to_pty_site_id= p_from_fk_id
1223: Or ship_to_pty_site_id = p_from_fk_id;

Line 1220: last_updated_by = hz_utility_pub.user_id,

1216: UPDATE IBE_ORD_ONECLICK_ALL SET
1217: bill_to_pty_site_id = decode(bill_to_pty_site_id,p_from_fk_id,p_to_fk_id,bill_to_pty_site_id),
1218: ship_to_pty_site_id = decode(ship_to_pty_site_id,p_from_fk_id,p_to_fk_id,ship_to_pty_site_id),
1219: last_update_date = hz_utility_pub.last_update_date,
1220: last_updated_by = hz_utility_pub.user_id,
1221: last_update_login = hz_utility_pub.last_update_login
1222: Where bill_to_pty_site_id= p_from_fk_id
1223: Or ship_to_pty_site_id = p_from_fk_id;
1224:

Line 1221: last_update_login = hz_utility_pub.last_update_login

1217: bill_to_pty_site_id = decode(bill_to_pty_site_id,p_from_fk_id,p_to_fk_id,bill_to_pty_site_id),
1218: ship_to_pty_site_id = decode(ship_to_pty_site_id,p_from_fk_id,p_to_fk_id,ship_to_pty_site_id),
1219: last_update_date = hz_utility_pub.last_update_date,
1220: last_updated_by = hz_utility_pub.user_id,
1221: last_update_login = hz_utility_pub.last_update_login
1222: Where bill_to_pty_site_id= p_from_fk_id
1223: Or ship_to_pty_site_id = p_from_fk_id;
1224:
1225: l_count := sql%rowcount;

Line 1359: last_update_date = hz_utility_pub.last_update_date,

1355: -- only merge when both & are BOTH on
1356: -- and doesn't have restrictions on the minisite
1357: UPDATE IBE_MSITE_PRTY_ACCSS
1358: SET party_id = p_to_fk_id,
1359: last_update_date = hz_utility_pub.last_update_date,
1360: last_updated_by = hz_utility_pub.user_id,
1361: last_update_login = hz_utility_pub.last_update_login
1362: Where party_id = p_from_fk_id and exists (
1363: select 1 from IBE_MSITE_PRTY_ACCSS a, IBE_MSITES_B b

Line 1360: last_updated_by = hz_utility_pub.user_id,

1356: -- and doesn't have restrictions on the minisite
1357: UPDATE IBE_MSITE_PRTY_ACCSS
1358: SET party_id = p_to_fk_id,
1359: last_update_date = hz_utility_pub.last_update_date,
1360: last_updated_by = hz_utility_pub.user_id,
1361: last_update_login = hz_utility_pub.last_update_login
1362: Where party_id = p_from_fk_id and exists (
1363: select 1 from IBE_MSITE_PRTY_ACCSS a, IBE_MSITES_B b
1364: where party_id=p_to_fk_id and a.msite_id<>l_msite_id

Line 1361: last_update_login = hz_utility_pub.last_update_login

1357: UPDATE IBE_MSITE_PRTY_ACCSS
1358: SET party_id = p_to_fk_id,
1359: last_update_date = hz_utility_pub.last_update_date,
1360: last_updated_by = hz_utility_pub.user_id,
1361: last_update_login = hz_utility_pub.last_update_login
1362: Where party_id = p_from_fk_id and exists (
1363: select 1 from IBE_MSITE_PRTY_ACCSS a, IBE_MSITES_B b
1364: where party_id=p_to_fk_id and a.msite_id<>l_msite_id
1365: and a.msite_id = b.msite_id and b.party_access_code = l_party_access_code

Line 1518: last_update_date = hz_utility_pub.last_update_date,

1514: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1515:
1516: UPDATE IBE_SH_QUOTE_ACCESS SET
1517: party_id = p_to_fk_id,
1518: last_update_date = hz_utility_pub.last_update_date,
1519: last_updated_by = hz_utility_pub.user_id,
1520: last_update_login = hz_utility_pub.last_update_login,
1521: request_id = hz_utility_pub.request_id,
1522: program_application_id = hz_utility_pub.program_application_id,

Line 1519: last_updated_by = hz_utility_pub.user_id,

1515:
1516: UPDATE IBE_SH_QUOTE_ACCESS SET
1517: party_id = p_to_fk_id,
1518: last_update_date = hz_utility_pub.last_update_date,
1519: last_updated_by = hz_utility_pub.user_id,
1520: last_update_login = hz_utility_pub.last_update_login,
1521: request_id = hz_utility_pub.request_id,
1522: program_application_id = hz_utility_pub.program_application_id,
1523: program_id = hz_utility_pub.program_id,

Line 1520: last_update_login = hz_utility_pub.last_update_login,

1516: UPDATE IBE_SH_QUOTE_ACCESS SET
1517: party_id = p_to_fk_id,
1518: last_update_date = hz_utility_pub.last_update_date,
1519: last_updated_by = hz_utility_pub.user_id,
1520: last_update_login = hz_utility_pub.last_update_login,
1521: request_id = hz_utility_pub.request_id,
1522: program_application_id = hz_utility_pub.program_application_id,
1523: program_id = hz_utility_pub.program_id,
1524: program_update_date = sysdate

Line 1521: request_id = hz_utility_pub.request_id,

1517: party_id = p_to_fk_id,
1518: last_update_date = hz_utility_pub.last_update_date,
1519: last_updated_by = hz_utility_pub.user_id,
1520: last_update_login = hz_utility_pub.last_update_login,
1521: request_id = hz_utility_pub.request_id,
1522: program_application_id = hz_utility_pub.program_application_id,
1523: program_id = hz_utility_pub.program_id,
1524: program_update_date = sysdate
1525: Where party_id = p_from_fk_id

Line 1522: program_application_id = hz_utility_pub.program_application_id,

1518: last_update_date = hz_utility_pub.last_update_date,
1519: last_updated_by = hz_utility_pub.user_id,
1520: last_update_login = hz_utility_pub.last_update_login,
1521: request_id = hz_utility_pub.request_id,
1522: program_application_id = hz_utility_pub.program_application_id,
1523: program_id = hz_utility_pub.program_id,
1524: program_update_date = sysdate
1525: Where party_id = p_from_fk_id
1526: And cust_account_id = l_from_cust_account_id

Line 1523: program_id = hz_utility_pub.program_id,

1519: last_updated_by = hz_utility_pub.user_id,
1520: last_update_login = hz_utility_pub.last_update_login,
1521: request_id = hz_utility_pub.request_id,
1522: program_application_id = hz_utility_pub.program_application_id,
1523: program_id = hz_utility_pub.program_id,
1524: program_update_date = sysdate
1525: Where party_id = p_from_fk_id
1526: And cust_account_id = l_from_cust_account_id
1527: And quote_header_id = l_quote_header_id;

Line 1541: last_update_date = hz_utility_pub.last_update_date,

1537: from hz_contact_points
1538: where contact_point_id=p_from_fk_id and owner_table_name<>'IBE_SH_QUOTE_ACCESS';
1539: UPDATE IBE_SH_QUOTE_ACCESS SET
1540: contact_point_id = p_to_fk_id,
1541: last_update_date = hz_utility_pub.last_update_date,
1542: last_updated_by = hz_utility_pub.user_id,
1543: last_update_login = hz_utility_pub.last_update_login,
1544: request_id = hz_utility_pub.request_id,
1545: program_application_id = hz_utility_pub.program_application_id,

Line 1542: last_updated_by = hz_utility_pub.user_id,

1538: where contact_point_id=p_from_fk_id and owner_table_name<>'IBE_SH_QUOTE_ACCESS';
1539: UPDATE IBE_SH_QUOTE_ACCESS SET
1540: contact_point_id = p_to_fk_id,
1541: last_update_date = hz_utility_pub.last_update_date,
1542: last_updated_by = hz_utility_pub.user_id,
1543: last_update_login = hz_utility_pub.last_update_login,
1544: request_id = hz_utility_pub.request_id,
1545: program_application_id = hz_utility_pub.program_application_id,
1546: program_id = hz_utility_pub.program_id,

Line 1543: last_update_login = hz_utility_pub.last_update_login,

1539: UPDATE IBE_SH_QUOTE_ACCESS SET
1540: contact_point_id = p_to_fk_id,
1541: last_update_date = hz_utility_pub.last_update_date,
1542: last_updated_by = hz_utility_pub.user_id,
1543: last_update_login = hz_utility_pub.last_update_login,
1544: request_id = hz_utility_pub.request_id,
1545: program_application_id = hz_utility_pub.program_application_id,
1546: program_id = hz_utility_pub.program_id,
1547: program_update_date = sysdate

Line 1544: request_id = hz_utility_pub.request_id,

1540: contact_point_id = p_to_fk_id,
1541: last_update_date = hz_utility_pub.last_update_date,
1542: last_updated_by = hz_utility_pub.user_id,
1543: last_update_login = hz_utility_pub.last_update_login,
1544: request_id = hz_utility_pub.request_id,
1545: program_application_id = hz_utility_pub.program_application_id,
1546: program_id = hz_utility_pub.program_id,
1547: program_update_date = sysdate
1548: Where contact_point_id = p_from_fk_id;

Line 1545: program_application_id = hz_utility_pub.program_application_id,

1541: last_update_date = hz_utility_pub.last_update_date,
1542: last_updated_by = hz_utility_pub.user_id,
1543: last_update_login = hz_utility_pub.last_update_login,
1544: request_id = hz_utility_pub.request_id,
1545: program_application_id = hz_utility_pub.program_application_id,
1546: program_id = hz_utility_pub.program_id,
1547: program_update_date = sysdate
1548: Where contact_point_id = p_from_fk_id;
1549:

Line 1546: program_id = hz_utility_pub.program_id,

1542: last_updated_by = hz_utility_pub.user_id,
1543: last_update_login = hz_utility_pub.last_update_login,
1544: request_id = hz_utility_pub.request_id,
1545: program_application_id = hz_utility_pub.program_application_id,
1546: program_id = hz_utility_pub.program_id,
1547: program_update_date = sysdate
1548: Where contact_point_id = p_from_fk_id;
1549:
1550: EXCEPTION