eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_MERGE_PVT dependencies on HZ_UTILITY_PUB

Line 175: hz_utility_pub.CREATED_BY,

171: NUM_COL3_ORIG_LIST(I),
172: NUM_COL3_NEW_LIST(I),
173: 'U',
174: req_id,
175: hz_utility_pub.CREATED_BY,
176: hz_utility_pub.CREATION_DATE,
177: hz_utility_pub.LAST_UPDATE_LOGIN,
178: hz_utility_pub.LAST_UPDATE_DATE,
179: hz_utility_pub.LAST_UPDATED_BY

Line 176: hz_utility_pub.CREATION_DATE,

172: NUM_COL3_NEW_LIST(I),
173: 'U',
174: req_id,
175: hz_utility_pub.CREATED_BY,
176: hz_utility_pub.CREATION_DATE,
177: hz_utility_pub.LAST_UPDATE_LOGIN,
178: hz_utility_pub.LAST_UPDATE_DATE,
179: hz_utility_pub.LAST_UPDATED_BY
180: );

Line 177: hz_utility_pub.LAST_UPDATE_LOGIN,

173: 'U',
174: req_id,
175: hz_utility_pub.CREATED_BY,
176: hz_utility_pub.CREATION_DATE,
177: hz_utility_pub.LAST_UPDATE_LOGIN,
178: hz_utility_pub.LAST_UPDATE_DATE,
179: hz_utility_pub.LAST_UPDATED_BY
180: );
181:

Line 178: hz_utility_pub.LAST_UPDATE_DATE,

174: req_id,
175: hz_utility_pub.CREATED_BY,
176: hz_utility_pub.CREATION_DATE,
177: hz_utility_pub.LAST_UPDATE_LOGIN,
178: hz_utility_pub.LAST_UPDATE_DATE,
179: hz_utility_pub.LAST_UPDATED_BY
180: );
181:
182: END IF;

Line 179: hz_utility_pub.LAST_UPDATED_BY

175: hz_utility_pub.CREATED_BY,
176: hz_utility_pub.CREATION_DATE,
177: hz_utility_pub.LAST_UPDATE_LOGIN,
178: hz_utility_pub.LAST_UPDATE_DATE,
179: hz_utility_pub.LAST_UPDATED_BY
180: );
181:
182: END IF;
183:

Line 366: hz_utility_pub.CREATED_BY,

362: NUM_COL2_ORIG_LIST(I),
363: NUM_COL2_NEW_LIST(I),
364: 'U',
365: req_id,
366: hz_utility_pub.CREATED_BY,
367: hz_utility_pub.CREATION_DATE,
368: hz_utility_pub.LAST_UPDATE_LOGIN,
369: hz_utility_pub.LAST_UPDATE_DATE,
370: hz_utility_pub.LAST_UPDATED_BY

Line 367: hz_utility_pub.CREATION_DATE,

363: NUM_COL2_NEW_LIST(I),
364: 'U',
365: req_id,
366: hz_utility_pub.CREATED_BY,
367: hz_utility_pub.CREATION_DATE,
368: hz_utility_pub.LAST_UPDATE_LOGIN,
369: hz_utility_pub.LAST_UPDATE_DATE,
370: hz_utility_pub.LAST_UPDATED_BY
371: );

Line 368: hz_utility_pub.LAST_UPDATE_LOGIN,

364: 'U',
365: req_id,
366: hz_utility_pub.CREATED_BY,
367: hz_utility_pub.CREATION_DATE,
368: hz_utility_pub.LAST_UPDATE_LOGIN,
369: hz_utility_pub.LAST_UPDATE_DATE,
370: hz_utility_pub.LAST_UPDATED_BY
371: );
372:

Line 369: hz_utility_pub.LAST_UPDATE_DATE,

365: req_id,
366: hz_utility_pub.CREATED_BY,
367: hz_utility_pub.CREATION_DATE,
368: hz_utility_pub.LAST_UPDATE_LOGIN,
369: hz_utility_pub.LAST_UPDATE_DATE,
370: hz_utility_pub.LAST_UPDATED_BY
371: );
372:
373: END IF;

Line 370: hz_utility_pub.LAST_UPDATED_BY

366: hz_utility_pub.CREATED_BY,
367: hz_utility_pub.CREATION_DATE,
368: hz_utility_pub.LAST_UPDATE_LOGIN,
369: hz_utility_pub.LAST_UPDATE_DATE,
370: hz_utility_pub.LAST_UPDATED_BY
371: );
372:
373: END IF;
374:

Line 527: hz_utility_pub.CREATED_BY,

523: NUM_COL1_ORIG_LIST(I),
524: NUM_COL1_NEW_LIST(I),
525: 'U',
526: req_id,
527: hz_utility_pub.CREATED_BY,
528: hz_utility_pub.CREATION_DATE,
529: hz_utility_pub.LAST_UPDATE_LOGIN,
530: hz_utility_pub.LAST_UPDATE_DATE,
531: hz_utility_pub.LAST_UPDATED_BY

Line 528: hz_utility_pub.CREATION_DATE,

524: NUM_COL1_NEW_LIST(I),
525: 'U',
526: req_id,
527: hz_utility_pub.CREATED_BY,
528: hz_utility_pub.CREATION_DATE,
529: hz_utility_pub.LAST_UPDATE_LOGIN,
530: hz_utility_pub.LAST_UPDATE_DATE,
531: hz_utility_pub.LAST_UPDATED_BY
532: );

Line 529: hz_utility_pub.LAST_UPDATE_LOGIN,

525: 'U',
526: req_id,
527: hz_utility_pub.CREATED_BY,
528: hz_utility_pub.CREATION_DATE,
529: hz_utility_pub.LAST_UPDATE_LOGIN,
530: hz_utility_pub.LAST_UPDATE_DATE,
531: hz_utility_pub.LAST_UPDATED_BY
532: );
533:

Line 530: hz_utility_pub.LAST_UPDATE_DATE,

526: req_id,
527: hz_utility_pub.CREATED_BY,
528: hz_utility_pub.CREATION_DATE,
529: hz_utility_pub.LAST_UPDATE_LOGIN,
530: hz_utility_pub.LAST_UPDATE_DATE,
531: hz_utility_pub.LAST_UPDATED_BY
532: );
533:
534:

Line 531: hz_utility_pub.LAST_UPDATED_BY

527: hz_utility_pub.CREATED_BY,
528: hz_utility_pub.CREATION_DATE,
529: hz_utility_pub.LAST_UPDATE_LOGIN,
530: hz_utility_pub.LAST_UPDATE_DATE,
531: hz_utility_pub.LAST_UPDATED_BY
532: );
533:
534:
535: END IF;

Line 647: last_update_date = hz_utility_pub.last_update_date,

643: cust_party_id = DECODE(cust_party_id,p_from_fk_id,p_to_fk_id,cust_party_id),
644: invoice_to_cust_party_id = DECODE(invoice_to_cust_party_id,p_from_fk_id,p_to_fk_id,invoice_to_cust_party_id),
645: End_Customer_party_id = DECODE(End_Customer_party_id,p_from_fk_id,p_to_fk_id,End_Customer_party_id),
646: End_Customer_cust_party_id = DECODE(End_Customer_cust_party_id,p_from_fk_id,p_to_fk_id,End_Customer_cust_party_id),
647: last_update_date = hz_utility_pub.last_update_date,
648: last_updated_by = hz_utility_pub.user_id,
649: last_update_login = hz_utility_pub.last_update_login,
650: request_id = hz_utility_pub.request_id,
651: program_application_id = hz_utility_pub.program_application_id,

Line 648: last_updated_by = hz_utility_pub.user_id,

644: invoice_to_cust_party_id = DECODE(invoice_to_cust_party_id,p_from_fk_id,p_to_fk_id,invoice_to_cust_party_id),
645: End_Customer_party_id = DECODE(End_Customer_party_id,p_from_fk_id,p_to_fk_id,End_Customer_party_id),
646: End_Customer_cust_party_id = DECODE(End_Customer_cust_party_id,p_from_fk_id,p_to_fk_id,End_Customer_cust_party_id),
647: last_update_date = hz_utility_pub.last_update_date,
648: last_updated_by = hz_utility_pub.user_id,
649: last_update_login = hz_utility_pub.last_update_login,
650: request_id = hz_utility_pub.request_id,
651: program_application_id = hz_utility_pub.program_application_id,
652: program_id = hz_utility_pub.program_id,

Line 649: last_update_login = hz_utility_pub.last_update_login,

645: End_Customer_party_id = DECODE(End_Customer_party_id,p_from_fk_id,p_to_fk_id,End_Customer_party_id),
646: End_Customer_cust_party_id = DECODE(End_Customer_cust_party_id,p_from_fk_id,p_to_fk_id,End_Customer_cust_party_id),
647: last_update_date = hz_utility_pub.last_update_date,
648: last_updated_by = hz_utility_pub.user_id,
649: last_update_login = hz_utility_pub.last_update_login,
650: request_id = hz_utility_pub.request_id,
651: program_application_id = hz_utility_pub.program_application_id,
652: program_id = hz_utility_pub.program_id,
653: program_update_date = sysdate

Line 650: request_id = hz_utility_pub.request_id,

646: End_Customer_cust_party_id = DECODE(End_Customer_cust_party_id,p_from_fk_id,p_to_fk_id,End_Customer_cust_party_id),
647: last_update_date = hz_utility_pub.last_update_date,
648: last_updated_by = hz_utility_pub.user_id,
649: last_update_login = hz_utility_pub.last_update_login,
650: request_id = hz_utility_pub.request_id,
651: program_application_id = hz_utility_pub.program_application_id,
652: program_id = hz_utility_pub.program_id,
653: program_update_date = sysdate
654: Where party_id = p_from_fk_id

Line 651: program_application_id = hz_utility_pub.program_application_id,

647: last_update_date = hz_utility_pub.last_update_date,
648: last_updated_by = hz_utility_pub.user_id,
649: last_update_login = hz_utility_pub.last_update_login,
650: request_id = hz_utility_pub.request_id,
651: program_application_id = hz_utility_pub.program_application_id,
652: program_id = hz_utility_pub.program_id,
653: program_update_date = sysdate
654: Where party_id = p_from_fk_id
655: OR invoice_to_party_id = p_from_fk_id

Line 652: program_id = hz_utility_pub.program_id,

648: last_updated_by = hz_utility_pub.user_id,
649: last_update_login = hz_utility_pub.last_update_login,
650: request_id = hz_utility_pub.request_id,
651: program_application_id = hz_utility_pub.program_application_id,
652: program_id = hz_utility_pub.program_id,
653: program_update_date = sysdate
654: Where party_id = p_from_fk_id
655: OR invoice_to_party_id = p_from_fk_id
656: OR cust_party_id = p_from_fk_id

Line 675: last_update_date = hz_utility_pub.last_update_date,

671: UPDATE ASO_QUOTE_HEADERS_ALL SET
672: invoice_to_party_site_id = DECODE(invoice_to_party_site_id,p_from_fk_id,p_to_fk_id,invoice_to_party_site_id),
673: End_Customer_party_site_id = DECODE(End_Customer_party_site_id,p_from_fk_id,p_to_fk_id,End_Customer_party_site_id),
674: sold_to_party_site_id = DECODE(sold_to_party_site_id,p_from_fk_id,p_to_fk_id,sold_to_party_site_id),
675: last_update_date = hz_utility_pub.last_update_date,
676: last_updated_by = hz_utility_pub.user_id,
677: last_update_login = hz_utility_pub.last_update_login,
678: request_id = hz_utility_pub.request_id,
679: program_application_id = hz_utility_pub.program_application_id,

Line 676: last_updated_by = hz_utility_pub.user_id,

672: invoice_to_party_site_id = DECODE(invoice_to_party_site_id,p_from_fk_id,p_to_fk_id,invoice_to_party_site_id),
673: End_Customer_party_site_id = DECODE(End_Customer_party_site_id,p_from_fk_id,p_to_fk_id,End_Customer_party_site_id),
674: sold_to_party_site_id = DECODE(sold_to_party_site_id,p_from_fk_id,p_to_fk_id,sold_to_party_site_id),
675: last_update_date = hz_utility_pub.last_update_date,
676: last_updated_by = hz_utility_pub.user_id,
677: last_update_login = hz_utility_pub.last_update_login,
678: request_id = hz_utility_pub.request_id,
679: program_application_id = hz_utility_pub.program_application_id,
680: program_id = hz_utility_pub.program_id,

Line 677: last_update_login = hz_utility_pub.last_update_login,

673: End_Customer_party_site_id = DECODE(End_Customer_party_site_id,p_from_fk_id,p_to_fk_id,End_Customer_party_site_id),
674: sold_to_party_site_id = DECODE(sold_to_party_site_id,p_from_fk_id,p_to_fk_id,sold_to_party_site_id),
675: last_update_date = hz_utility_pub.last_update_date,
676: last_updated_by = hz_utility_pub.user_id,
677: last_update_login = hz_utility_pub.last_update_login,
678: request_id = hz_utility_pub.request_id,
679: program_application_id = hz_utility_pub.program_application_id,
680: program_id = hz_utility_pub.program_id,
681: program_update_date = sysdate

Line 678: request_id = hz_utility_pub.request_id,

674: sold_to_party_site_id = DECODE(sold_to_party_site_id,p_from_fk_id,p_to_fk_id,sold_to_party_site_id),
675: last_update_date = hz_utility_pub.last_update_date,
676: last_updated_by = hz_utility_pub.user_id,
677: last_update_login = hz_utility_pub.last_update_login,
678: request_id = hz_utility_pub.request_id,
679: program_application_id = hz_utility_pub.program_application_id,
680: program_id = hz_utility_pub.program_id,
681: program_update_date = sysdate
682: Where invoice_to_party_site_id = p_from_fk_id

Line 679: program_application_id = hz_utility_pub.program_application_id,

675: last_update_date = hz_utility_pub.last_update_date,
676: last_updated_by = hz_utility_pub.user_id,
677: last_update_login = hz_utility_pub.last_update_login,
678: request_id = hz_utility_pub.request_id,
679: program_application_id = hz_utility_pub.program_application_id,
680: program_id = hz_utility_pub.program_id,
681: program_update_date = sysdate
682: Where invoice_to_party_site_id = p_from_fk_id
683: OR End_Customer_party_site_id = p_from_fk_id

Line 680: program_id = hz_utility_pub.program_id,

676: last_updated_by = hz_utility_pub.user_id,
677: last_update_login = hz_utility_pub.last_update_login,
678: request_id = hz_utility_pub.request_id,
679: program_application_id = hz_utility_pub.program_application_id,
680: program_id = hz_utility_pub.program_id,
681: program_update_date = sysdate
682: Where invoice_to_party_site_id = p_from_fk_id
683: OR End_Customer_party_site_id = p_from_fk_id
684: OR sold_to_party_site_id = p_from_fk_id;

Line 700: last_update_date = hz_utility_pub.last_update_date,

696: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
697:
698: UPDATE ASO_QUOTE_HEADERS_ALL SET
699: org_contact_id = p_to_fk_id,
700: last_update_date = hz_utility_pub.last_update_date,
701: last_updated_by = hz_utility_pub.user_id,
702: last_update_login = hz_utility_pub.last_update_login,
703: request_id = hz_utility_pub.request_id,
704: program_application_id = hz_utility_pub.program_application_id,

Line 701: last_updated_by = hz_utility_pub.user_id,

697:
698: UPDATE ASO_QUOTE_HEADERS_ALL SET
699: org_contact_id = p_to_fk_id,
700: last_update_date = hz_utility_pub.last_update_date,
701: last_updated_by = hz_utility_pub.user_id,
702: last_update_login = hz_utility_pub.last_update_login,
703: request_id = hz_utility_pub.request_id,
704: program_application_id = hz_utility_pub.program_application_id,
705: program_id = hz_utility_pub.program_id,

Line 702: last_update_login = hz_utility_pub.last_update_login,

698: UPDATE ASO_QUOTE_HEADERS_ALL SET
699: org_contact_id = p_to_fk_id,
700: last_update_date = hz_utility_pub.last_update_date,
701: last_updated_by = hz_utility_pub.user_id,
702: last_update_login = hz_utility_pub.last_update_login,
703: request_id = hz_utility_pub.request_id,
704: program_application_id = hz_utility_pub.program_application_id,
705: program_id = hz_utility_pub.program_id,
706: program_update_date = sysdate

Line 703: request_id = hz_utility_pub.request_id,

699: org_contact_id = p_to_fk_id,
700: last_update_date = hz_utility_pub.last_update_date,
701: last_updated_by = hz_utility_pub.user_id,
702: last_update_login = hz_utility_pub.last_update_login,
703: request_id = hz_utility_pub.request_id,
704: program_application_id = hz_utility_pub.program_application_id,
705: program_id = hz_utility_pub.program_id,
706: program_update_date = sysdate
707: Where org_contact_id = p_from_fk_id;

Line 704: program_application_id = hz_utility_pub.program_application_id,

700: last_update_date = hz_utility_pub.last_update_date,
701: last_updated_by = hz_utility_pub.user_id,
702: last_update_login = hz_utility_pub.last_update_login,
703: request_id = hz_utility_pub.request_id,
704: program_application_id = hz_utility_pub.program_application_id,
705: program_id = hz_utility_pub.program_id,
706: program_update_date = sysdate
707: Where org_contact_id = p_from_fk_id;
708:

Line 705: program_id = hz_utility_pub.program_id,

701: last_updated_by = hz_utility_pub.user_id,
702: last_update_login = hz_utility_pub.last_update_login,
703: request_id = hz_utility_pub.request_id,
704: program_application_id = hz_utility_pub.program_application_id,
705: program_id = hz_utility_pub.program_id,
706: program_update_date = sysdate
707: Where org_contact_id = p_from_fk_id;
708:
709: l_count := sql%rowcount;

Line 808: last_update_date = hz_utility_pub.last_update_date,

804: invoice_to_party_id = DECODE(invoice_to_party_id,p_from_fk_id,p_to_fk_id,invoice_to_party_id),
805: invoice_to_cust_party_id = DECODE(invoice_to_cust_party_id,p_from_fk_id,p_to_fk_id,invoice_to_cust_party_id),
806: End_Customer_party_id = DECODE(End_Customer_party_id,p_from_fk_id,p_to_fk_id,End_Customer_party_id),
807: End_Customer_cust_party_id = DECODE(End_Customer_cust_party_id,p_from_fk_id,p_to_fk_id,End_Customer_cust_party_id),
808: last_update_date = hz_utility_pub.last_update_date,
809: last_updated_by = hz_utility_pub.user_id,
810: last_update_login = hz_utility_pub.last_update_login,
811: request_id = hz_utility_pub.request_id,
812: program_application_id = hz_utility_pub.program_application_id,

Line 809: last_updated_by = hz_utility_pub.user_id,

805: invoice_to_cust_party_id = DECODE(invoice_to_cust_party_id,p_from_fk_id,p_to_fk_id,invoice_to_cust_party_id),
806: End_Customer_party_id = DECODE(End_Customer_party_id,p_from_fk_id,p_to_fk_id,End_Customer_party_id),
807: End_Customer_cust_party_id = DECODE(End_Customer_cust_party_id,p_from_fk_id,p_to_fk_id,End_Customer_cust_party_id),
808: last_update_date = hz_utility_pub.last_update_date,
809: last_updated_by = hz_utility_pub.user_id,
810: last_update_login = hz_utility_pub.last_update_login,
811: request_id = hz_utility_pub.request_id,
812: program_application_id = hz_utility_pub.program_application_id,
813: program_id = hz_utility_pub.program_id,

Line 810: last_update_login = hz_utility_pub.last_update_login,

806: End_Customer_party_id = DECODE(End_Customer_party_id,p_from_fk_id,p_to_fk_id,End_Customer_party_id),
807: End_Customer_cust_party_id = DECODE(End_Customer_cust_party_id,p_from_fk_id,p_to_fk_id,End_Customer_cust_party_id),
808: last_update_date = hz_utility_pub.last_update_date,
809: last_updated_by = hz_utility_pub.user_id,
810: last_update_login = hz_utility_pub.last_update_login,
811: request_id = hz_utility_pub.request_id,
812: program_application_id = hz_utility_pub.program_application_id,
813: program_id = hz_utility_pub.program_id,
814: program_update_date = sysdate

Line 811: request_id = hz_utility_pub.request_id,

807: End_Customer_cust_party_id = DECODE(End_Customer_cust_party_id,p_from_fk_id,p_to_fk_id,End_Customer_cust_party_id),
808: last_update_date = hz_utility_pub.last_update_date,
809: last_updated_by = hz_utility_pub.user_id,
810: last_update_login = hz_utility_pub.last_update_login,
811: request_id = hz_utility_pub.request_id,
812: program_application_id = hz_utility_pub.program_application_id,
813: program_id = hz_utility_pub.program_id,
814: program_update_date = sysdate
815: Where invoice_to_party_id = p_from_fk_id

Line 812: program_application_id = hz_utility_pub.program_application_id,

808: last_update_date = hz_utility_pub.last_update_date,
809: last_updated_by = hz_utility_pub.user_id,
810: last_update_login = hz_utility_pub.last_update_login,
811: request_id = hz_utility_pub.request_id,
812: program_application_id = hz_utility_pub.program_application_id,
813: program_id = hz_utility_pub.program_id,
814: program_update_date = sysdate
815: Where invoice_to_party_id = p_from_fk_id
816: OR invoice_to_cust_party_id = p_from_fk_id

Line 813: program_id = hz_utility_pub.program_id,

809: last_updated_by = hz_utility_pub.user_id,
810: last_update_login = hz_utility_pub.last_update_login,
811: request_id = hz_utility_pub.request_id,
812: program_application_id = hz_utility_pub.program_application_id,
813: program_id = hz_utility_pub.program_id,
814: program_update_date = sysdate
815: Where invoice_to_party_id = p_from_fk_id
816: OR invoice_to_cust_party_id = p_from_fk_id
817: OR End_Customer_cust_party_id = p_from_fk_id;

Line 834: last_update_date = hz_utility_pub.last_update_date,

830:
831: UPDATE ASO_QUOTE_LINES_ALL SET
832: invoice_to_party_site_id = p_to_fk_id,
833: End_Customer_party_site_id = p_to_fk_id,
834: last_update_date = hz_utility_pub.last_update_date,
835: last_updated_by = hz_utility_pub.user_id,
836: last_update_login = hz_utility_pub.last_update_login,
837: request_id = hz_utility_pub.request_id,
838: program_application_id = hz_utility_pub.program_application_id,

Line 835: last_updated_by = hz_utility_pub.user_id,

831: UPDATE ASO_QUOTE_LINES_ALL SET
832: invoice_to_party_site_id = p_to_fk_id,
833: End_Customer_party_site_id = p_to_fk_id,
834: last_update_date = hz_utility_pub.last_update_date,
835: last_updated_by = hz_utility_pub.user_id,
836: last_update_login = hz_utility_pub.last_update_login,
837: request_id = hz_utility_pub.request_id,
838: program_application_id = hz_utility_pub.program_application_id,
839: program_id = hz_utility_pub.program_id,

Line 836: last_update_login = hz_utility_pub.last_update_login,

832: invoice_to_party_site_id = p_to_fk_id,
833: End_Customer_party_site_id = p_to_fk_id,
834: last_update_date = hz_utility_pub.last_update_date,
835: last_updated_by = hz_utility_pub.user_id,
836: last_update_login = hz_utility_pub.last_update_login,
837: request_id = hz_utility_pub.request_id,
838: program_application_id = hz_utility_pub.program_application_id,
839: program_id = hz_utility_pub.program_id,
840: program_update_date = sysdate

Line 837: request_id = hz_utility_pub.request_id,

833: End_Customer_party_site_id = p_to_fk_id,
834: last_update_date = hz_utility_pub.last_update_date,
835: last_updated_by = hz_utility_pub.user_id,
836: last_update_login = hz_utility_pub.last_update_login,
837: request_id = hz_utility_pub.request_id,
838: program_application_id = hz_utility_pub.program_application_id,
839: program_id = hz_utility_pub.program_id,
840: program_update_date = sysdate
841: Where invoice_to_party_site_id = p_from_fk_id

Line 838: program_application_id = hz_utility_pub.program_application_id,

834: last_update_date = hz_utility_pub.last_update_date,
835: last_updated_by = hz_utility_pub.user_id,
836: last_update_login = hz_utility_pub.last_update_login,
837: request_id = hz_utility_pub.request_id,
838: program_application_id = hz_utility_pub.program_application_id,
839: program_id = hz_utility_pub.program_id,
840: program_update_date = sysdate
841: Where invoice_to_party_site_id = p_from_fk_id
842: OR End_Customer_party_site_id = p_from_fk_id;

Line 839: program_id = hz_utility_pub.program_id,

835: last_updated_by = hz_utility_pub.user_id,
836: last_update_login = hz_utility_pub.last_update_login,
837: request_id = hz_utility_pub.request_id,
838: program_application_id = hz_utility_pub.program_application_id,
839: program_id = hz_utility_pub.program_id,
840: program_update_date = sysdate
841: Where invoice_to_party_site_id = p_from_fk_id
842: OR End_Customer_party_site_id = p_from_fk_id;
843:

Line 941: last_update_date = hz_utility_pub.last_update_date,

937:
938: UPDATE ASO_SHIPMENTS SET
939: ship_to_party_id = DECODE(ship_to_party_id,p_from_fk_id,p_to_fk_id,ship_to_party_id),
940: ship_to_cust_party_id = DECODE(ship_to_cust_party_id,p_from_fk_id,p_to_fk_id,ship_to_cust_party_id),
941: last_update_date = hz_utility_pub.last_update_date,
942: last_updated_by = hz_utility_pub.user_id,
943: last_update_login = hz_utility_pub.last_update_login,
944: request_id = hz_utility_pub.request_id,
945: program_application_id = hz_utility_pub.program_application_id,

Line 942: last_updated_by = hz_utility_pub.user_id,

938: UPDATE ASO_SHIPMENTS SET
939: ship_to_party_id = DECODE(ship_to_party_id,p_from_fk_id,p_to_fk_id,ship_to_party_id),
940: ship_to_cust_party_id = DECODE(ship_to_cust_party_id,p_from_fk_id,p_to_fk_id,ship_to_cust_party_id),
941: last_update_date = hz_utility_pub.last_update_date,
942: last_updated_by = hz_utility_pub.user_id,
943: last_update_login = hz_utility_pub.last_update_login,
944: request_id = hz_utility_pub.request_id,
945: program_application_id = hz_utility_pub.program_application_id,
946: program_id = hz_utility_pub.program_id,

Line 943: last_update_login = hz_utility_pub.last_update_login,

939: ship_to_party_id = DECODE(ship_to_party_id,p_from_fk_id,p_to_fk_id,ship_to_party_id),
940: ship_to_cust_party_id = DECODE(ship_to_cust_party_id,p_from_fk_id,p_to_fk_id,ship_to_cust_party_id),
941: last_update_date = hz_utility_pub.last_update_date,
942: last_updated_by = hz_utility_pub.user_id,
943: last_update_login = hz_utility_pub.last_update_login,
944: request_id = hz_utility_pub.request_id,
945: program_application_id = hz_utility_pub.program_application_id,
946: program_id = hz_utility_pub.program_id,
947: program_update_date = sysdate

Line 944: request_id = hz_utility_pub.request_id,

940: ship_to_cust_party_id = DECODE(ship_to_cust_party_id,p_from_fk_id,p_to_fk_id,ship_to_cust_party_id),
941: last_update_date = hz_utility_pub.last_update_date,
942: last_updated_by = hz_utility_pub.user_id,
943: last_update_login = hz_utility_pub.last_update_login,
944: request_id = hz_utility_pub.request_id,
945: program_application_id = hz_utility_pub.program_application_id,
946: program_id = hz_utility_pub.program_id,
947: program_update_date = sysdate
948: Where ship_to_party_id = p_from_fk_id

Line 945: program_application_id = hz_utility_pub.program_application_id,

941: last_update_date = hz_utility_pub.last_update_date,
942: last_updated_by = hz_utility_pub.user_id,
943: last_update_login = hz_utility_pub.last_update_login,
944: request_id = hz_utility_pub.request_id,
945: program_application_id = hz_utility_pub.program_application_id,
946: program_id = hz_utility_pub.program_id,
947: program_update_date = sysdate
948: Where ship_to_party_id = p_from_fk_id
949: OR ship_to_cust_party_id = p_from_fk_id;

Line 946: program_id = hz_utility_pub.program_id,

942: last_updated_by = hz_utility_pub.user_id,
943: last_update_login = hz_utility_pub.last_update_login,
944: request_id = hz_utility_pub.request_id,
945: program_application_id = hz_utility_pub.program_application_id,
946: program_id = hz_utility_pub.program_id,
947: program_update_date = sysdate
948: Where ship_to_party_id = p_from_fk_id
949: OR ship_to_cust_party_id = p_from_fk_id;
950:

Line 965: last_update_date = hz_utility_pub.last_update_date,

961: arp_message.set_token('TABLE_NAME','ASO_SHIPMENTS', FALSE);
962:
963: UPDATE ASO_SHIPMENTS SET
964: ship_to_party_site_id = p_to_fk_id,
965: last_update_date = hz_utility_pub.last_update_date,
966: last_updated_by = hz_utility_pub.user_id,
967: last_update_login = hz_utility_pub.last_update_login,
968: request_id = hz_utility_pub.request_id,
969: program_application_id = hz_utility_pub.program_application_id,

Line 966: last_updated_by = hz_utility_pub.user_id,

962:
963: UPDATE ASO_SHIPMENTS SET
964: ship_to_party_site_id = p_to_fk_id,
965: last_update_date = hz_utility_pub.last_update_date,
966: last_updated_by = hz_utility_pub.user_id,
967: last_update_login = hz_utility_pub.last_update_login,
968: request_id = hz_utility_pub.request_id,
969: program_application_id = hz_utility_pub.program_application_id,
970: program_id = hz_utility_pub.program_id,

Line 967: last_update_login = hz_utility_pub.last_update_login,

963: UPDATE ASO_SHIPMENTS SET
964: ship_to_party_site_id = p_to_fk_id,
965: last_update_date = hz_utility_pub.last_update_date,
966: last_updated_by = hz_utility_pub.user_id,
967: last_update_login = hz_utility_pub.last_update_login,
968: request_id = hz_utility_pub.request_id,
969: program_application_id = hz_utility_pub.program_application_id,
970: program_id = hz_utility_pub.program_id,
971: program_update_date = sysdate

Line 968: request_id = hz_utility_pub.request_id,

964: ship_to_party_site_id = p_to_fk_id,
965: last_update_date = hz_utility_pub.last_update_date,
966: last_updated_by = hz_utility_pub.user_id,
967: last_update_login = hz_utility_pub.last_update_login,
968: request_id = hz_utility_pub.request_id,
969: program_application_id = hz_utility_pub.program_application_id,
970: program_id = hz_utility_pub.program_id,
971: program_update_date = sysdate
972: Where ship_to_party_site_id = p_from_fk_id;

Line 969: program_application_id = hz_utility_pub.program_application_id,

965: last_update_date = hz_utility_pub.last_update_date,
966: last_updated_by = hz_utility_pub.user_id,
967: last_update_login = hz_utility_pub.last_update_login,
968: request_id = hz_utility_pub.request_id,
969: program_application_id = hz_utility_pub.program_application_id,
970: program_id = hz_utility_pub.program_id,
971: program_update_date = sysdate
972: Where ship_to_party_site_id = p_from_fk_id;
973:

Line 970: program_id = hz_utility_pub.program_id,

966: last_updated_by = hz_utility_pub.user_id,
967: last_update_login = hz_utility_pub.last_update_login,
968: request_id = hz_utility_pub.request_id,
969: program_application_id = hz_utility_pub.program_application_id,
970: program_id = hz_utility_pub.program_id,
971: program_update_date = sysdate
972: Where ship_to_party_site_id = p_from_fk_id;
973:
974: l_count := sql%rowcount;