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 174: hz_utility_pub.CREATED_BY,

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

Line 175: hz_utility_pub.CREATION_DATE,

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

Line 176: hz_utility_pub.LAST_UPDATE_LOGIN,

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

Line 177: hz_utility_pub.LAST_UPDATE_DATE,

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

Line 178: hz_utility_pub.LAST_UPDATED_BY

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

Line 365: hz_utility_pub.CREATED_BY,

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

Line 366: hz_utility_pub.CREATION_DATE,

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

Line 367: hz_utility_pub.LAST_UPDATE_LOGIN,

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

Line 368: hz_utility_pub.LAST_UPDATE_DATE,

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

Line 369: hz_utility_pub.LAST_UPDATED_BY

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

Line 526: hz_utility_pub.CREATED_BY,

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

Line 527: hz_utility_pub.CREATION_DATE,

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

Line 528: hz_utility_pub.LAST_UPDATE_LOGIN,

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

Line 529: hz_utility_pub.LAST_UPDATE_DATE,

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

Line 530: hz_utility_pub.LAST_UPDATED_BY

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

Line 646: last_update_date = hz_utility_pub.last_update_date,

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

Line 647: last_updated_by = hz_utility_pub.user_id,

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

Line 648: last_update_login = hz_utility_pub.last_update_login,

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

Line 649: request_id = hz_utility_pub.request_id,

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

Line 650: program_application_id = hz_utility_pub.program_application_id,

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

Line 651: program_id = hz_utility_pub.program_id,

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

Line 674: last_update_date = hz_utility_pub.last_update_date,

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

Line 675: last_updated_by = hz_utility_pub.user_id,

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

Line 676: last_update_login = hz_utility_pub.last_update_login,

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

Line 677: request_id = hz_utility_pub.request_id,

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

Line 678: program_application_id = hz_utility_pub.program_application_id,

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

Line 679: program_id = hz_utility_pub.program_id,

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

Line 699: last_update_date = hz_utility_pub.last_update_date,

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

Line 700: last_updated_by = hz_utility_pub.user_id,

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

Line 701: last_update_login = hz_utility_pub.last_update_login,

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

Line 702: request_id = hz_utility_pub.request_id,

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

Line 703: program_application_id = hz_utility_pub.program_application_id,

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

Line 704: program_id = hz_utility_pub.program_id,

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

Line 807: last_update_date = hz_utility_pub.last_update_date,

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

Line 808: last_updated_by = hz_utility_pub.user_id,

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

Line 809: last_update_login = hz_utility_pub.last_update_login,

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

Line 810: request_id = hz_utility_pub.request_id,

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

Line 811: program_application_id = hz_utility_pub.program_application_id,

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

Line 812: program_id = hz_utility_pub.program_id,

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

Line 833: last_update_date = hz_utility_pub.last_update_date,

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

Line 834: last_updated_by = hz_utility_pub.user_id,

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

Line 835: last_update_login = hz_utility_pub.last_update_login,

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

Line 836: request_id = hz_utility_pub.request_id,

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

Line 837: program_application_id = hz_utility_pub.program_application_id,

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

Line 838: program_id = hz_utility_pub.program_id,

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

Line 940: last_update_date = hz_utility_pub.last_update_date,

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

Line 941: last_updated_by = hz_utility_pub.user_id,

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

Line 942: last_update_login = hz_utility_pub.last_update_login,

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

Line 943: request_id = hz_utility_pub.request_id,

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

Line 944: program_application_id = hz_utility_pub.program_application_id,

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

Line 945: program_id = hz_utility_pub.program_id,

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

Line 964: last_update_date = hz_utility_pub.last_update_date,

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

Line 965: last_updated_by = hz_utility_pub.user_id,

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

Line 966: last_update_login = hz_utility_pub.last_update_login,

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

Line 967: request_id = hz_utility_pub.request_id,

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

Line 968: program_application_id = hz_utility_pub.program_application_id,

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

Line 969: program_id = hz_utility_pub.program_id,

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