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 ASO_QUOTE_HEADERS

Line 65: ASO_QUOTE_HEADERS.QUOTE_HEADER_ID%TYPE

61: INDEX BY BINARY_INTEGER;
62: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
63:
64: TYPE QUOTE_HEADER_ID_LIST_TYPE IS TABLE OF
65: ASO_QUOTE_HEADERS.QUOTE_HEADER_ID%TYPE
66: INDEX BY BINARY_INTEGER;
67: PRIMARY_KEY_ID_LIST QUOTE_HEADER_ID_LIST_TYPE;
68:
69: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 70: ASO_QUOTE_HEADERS.CUST_ACCOUNT_ID%TYPE

66: INDEX BY BINARY_INTEGER;
67: PRIMARY_KEY_ID_LIST QUOTE_HEADER_ID_LIST_TYPE;
68:
69: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
70: ASO_QUOTE_HEADERS.CUST_ACCOUNT_ID%TYPE
71: INDEX BY BINARY_INTEGER;
72: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
73: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
74:

Line 76: ASO_QUOTE_HEADERS.INVOICE_TO_CUST_ACCOUNT_ID%TYPE

72: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
73: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
74:
75: TYPE INV_TO_CUST_ACCT_ID_LIST_TYPE IS TABLE OF
76: ASO_QUOTE_HEADERS.INVOICE_TO_CUST_ACCOUNT_ID%TYPE
77: INDEX BY BINARY_INTEGER;
78: NUM_COL2_ORIG_LIST INV_TO_CUST_ACCT_ID_LIST_TYPE;
79: NUM_COL2_NEW_LIST INV_TO_CUST_ACCT_ID_LIST_TYPE;
80:

Line 82: ASO_QUOTE_HEADERS.END_CUSTOMER_CUST_ACCOUNT_ID%TYPE

78: NUM_COL2_ORIG_LIST INV_TO_CUST_ACCT_ID_LIST_TYPE;
79: NUM_COL2_NEW_LIST INV_TO_CUST_ACCT_ID_LIST_TYPE;
80:
81: TYPE END_CUST_ACCT_ID_LIST_TYPE IS TABLE OF
82: ASO_QUOTE_HEADERS.END_CUSTOMER_CUST_ACCOUNT_ID%TYPE
83: INDEX BY BINARY_INTEGER;
84: NUM_COL3_ORIG_LIST END_CUST_ACCT_ID_LIST_TYPE;
85: NUM_COL3_NEW_LIST END_CUST_ACCT_ID_LIST_TYPE;
86:

Line 95: FROM ASO_QUOTE_HEADERS yt, ra_customer_merges m

91: ,QUOTE_HEADER_ID
92: ,CUST_ACCOUNT_ID
93: ,INVOICE_TO_CUST_ACCOUNT_ID
94: ,END_CUSTOMER_CUST_ACCOUNT_ID
95: FROM ASO_QUOTE_HEADERS yt, ra_customer_merges m
96: WHERE (
97: yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
98: OR yt.INVOICE_TO_CUST_ACCOUNT_ID = m.DUPLICATE_ID
99: OR yt.END_CUSTOMER_CUST_ACCOUNT_ID = m.DUPLICATE_ID

Line 115: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ASO_QUOTE_HEADERS',FALSE);

111:
112: ELSE
113:
114: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
115: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ASO_QUOTE_HEADERS',FALSE);
116: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
117: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
118:
119: open merged_records;

Line 164: 'ASO_QUOTE_HEADERS',

160: LAST_UPDATE_LOGIN,
161: LAST_UPDATE_DATE,
162: LAST_UPDATED_BY
163: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
164: 'ASO_QUOTE_HEADERS',
165: MERGE_HEADER_ID_LIST(I),
166: PRIMARY_KEY_ID_LIST(I),
167: NUM_COL1_ORIG_LIST(I),
168: NUM_COL1_NEW_LIST(I),

Line 185: UPDATE ASO_QUOTE_HEADERS yt SET

181:
182: END IF;
183:
184: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
185: UPDATE ASO_QUOTE_HEADERS yt SET
186: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
187: ,INVOICE_TO_CUST_ACCOUNT_ID=NUM_COL2_NEW_LIST(I)
188: ,END_CUSTOMER_CUST_ACCOUNT_ID=NUM_COL3_NEW_LIST(I)
189: , LAST_UPDATE_DATE=SYSDATE

Line 579: | This procedure will update ASO_QUOTE_HEADERS_ALL table |

575: | MERGE_QUOTE_HEADERS -- |
576: | When in ERP Parties are merged the |
577: | The Foriegn keys to party_id and other columns |
578: | should also be updated in iStore tables. |
579: | This procedure will update ASO_QUOTE_HEADERS_ALL table |
580: | and will be called from party Merge concurrent program. |
581: | DESCRIPTION |
582: | |
583: | REQUIRES |

Line 638: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);

634:
635: IF p_parent_entity_name = 'HZ_PARTIES' Then
636:
637: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
638: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
639:
640: UPDATE ASO_QUOTE_HEADERS_ALL SET
641: party_id = DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id),
642: invoice_to_party_id = DECODE(invoice_to_party_id,p_from_fk_id,p_to_fk_id,invoice_to_party_id),

Line 640: UPDATE ASO_QUOTE_HEADERS_ALL SET

636:
637: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
638: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
639:
640: UPDATE ASO_QUOTE_HEADERS_ALL SET
641: party_id = DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id),
642: invoice_to_party_id = DECODE(invoice_to_party_id,p_from_fk_id,p_to_fk_id,invoice_to_party_id),
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),

Line 669: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);

665:
666: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN
667:
668: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
669: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
670:
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),

Line 671: UPDATE ASO_QUOTE_HEADERS_ALL SET

667:
668: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
669: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
670:
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,

Line 696: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);

692:
693: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN
694:
695: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
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,

Line 698: UPDATE ASO_QUOTE_HEADERS_ALL SET

694:
695: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
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,

Line 726: 'on table ASO_QUOTE_HEADERS_ALL');

722:
723: Exception
724: When RESOURCE_BUSY Then
725: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS; Could not obtain lock'||
726: 'on table ASO_QUOTE_HEADERS_ALL');
727:
728: x_return_status := FND_API.G_RET_STS_ERROR;
729: raise;
730: When Others Then