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 94: FROM ASO_QUOTE_HEADERS yt, ra_customer_merges m

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

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

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

Line 163: 'ASO_QUOTE_HEADERS',

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

Line 184: UPDATE ASO_QUOTE_HEADERS yt SET

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

Line 578: | This procedure will update ASO_QUOTE_HEADERS_ALL table |

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

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

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

Line 639: UPDATE ASO_QUOTE_HEADERS_ALL SET

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

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

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

Line 670: UPDATE ASO_QUOTE_HEADERS_ALL SET

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

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

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

Line 697: UPDATE ASO_QUOTE_HEADERS_ALL SET

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

Line 725: 'on table ASO_QUOTE_HEADERS_ALL');

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