DBA Data[Home] [Help]

APPS.IBE_QUOTE_MISC_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 22: from aso_quote_headers_all

18: p_party_id IN NUMBER,
19: p_cust_account_id IN NUMBER) return varchar2 is
20: CURSOR c_get_quote_details(c_quote_header_id NUMBER) is
21: select quote_expiration_date
22: from aso_quote_headers_all
23: where quote_header_id = c_quote_header_id;
24:
25: CURSOR c_find_active_cart(c_quote_header_id NUMBER,
26: c_party_id NUMBER,

Line 2495: from aso_quote_headers_all a, aso_quote_statuses_vl b

2491:
2492: Cursor c_cart_columns (quote_hdr_id number) is
2493: select resource_id, status_code, publish_flag, quote_expiration_date,
2494: max_version_flag , order_id, quote_name
2495: from aso_quote_headers_all a, aso_quote_statuses_vl b
2496: where quote_header_id = quote_hdr_id
2497: and a.quote_status_id = b.quote_status_id;
2498:
2499: Cursor c_cart_from_number(quote_num number, quote_ver number) is

Line 2501: from aso_quote_headers_all a

2497: and a.quote_status_id = b.quote_status_id;
2498:
2499: Cursor c_cart_from_number(quote_num number, quote_ver number) is
2500: select quote_header_id
2501: from aso_quote_headers_all a
2502: where quote_number = quote_num
2503: and quote_version = quote_ver;
2504:
2505: Cursor c_retrieval_number (c_retrieval_number NUMBER) is

Line 2951: from aso_quote_headers_all

2947: is
2948:
2949: CURSOR C_get_quote_id(p_partyid number,p_cust_accountid number ) is
2950: select quote_header_id, last_update_date
2951: from aso_quote_headers_all
2952: where quote_header_id = (select max(quote_header_id)
2953: from aso_quote_headers_all
2954: where upper(quote_source_code) = 'ISTORE ACCOUNT'
2955: and party_id = p_partyid

Line 2953: from aso_quote_headers_all

2949: CURSOR C_get_quote_id(p_partyid number,p_cust_accountid number ) is
2950: select quote_header_id, last_update_date
2951: from aso_quote_headers_all
2952: where quote_header_id = (select max(quote_header_id)
2953: from aso_quote_headers_all
2954: where upper(quote_source_code) = 'ISTORE ACCOUNT'
2955: and party_id = p_partyid
2956: and cust_account_id = p_cust_accountid
2957: and quote_name = 'IBEACTIVECART'

Line 4316: from aso_quote_headers_all

4312: and quote_header_id = p_quote_header_id;
4313:
4314: CURSOR c_getQuoteInfo IS
4315: SELECT quote_header_id
4316: from aso_quote_headers_all
4317: where quote_header_id = p_quote_header_id
4318: AND (party_id = l_party_id OR (party_id = p_party_id AND cust_account_id = p_cust_account_id));
4319:
4320: -- 9/23/02: we're using the next cursor

Line 4356: select quote_source_code from aso_quote_headers_all where quote_header_id = p_quote_header_id;

4352: rec_sharee_info c_getShareeInfo%rowtype;
4353:
4354: -- 9/11/02: we want to check if this cart is a guest cart
4355: CURSOR c_getActiveCartTypeInfo IS
4356: select quote_source_code from aso_quote_headers_all where quote_header_id = p_quote_header_id;
4357: rec_ActiveCartType_info c_getActiveCartTypeInfo%rowtype;
4358:
4359: BEGIN
4360:

Line 4714: from aso_quote_headers_all a, hz_parties p

4710: where quote_sharee_number = c_retrieval_num ;
4711:
4712: cursor c_get_sold_to(c_quote_header_id NUMBER) is
4713: select cust_account_id, party_type
4714: from aso_quote_headers_all a, hz_parties p
4715: where a.party_id = p.party_id
4716: and quote_header_id = c_quote_header_id;
4717:
4718: cursor c_get_party_type(c_party_id NUMBER) is

Line 5343: from aso_quote_headers_all a, aso_quote_statuses_vl b

5339: FUNCTION get_aso_quote_status (p_quote_header_id NUMBER) RETURN VARCHAR2 is
5340:
5341: CURSOR c_quote_status_code (quote_hdr_id number) is
5342: select status_code
5343: from aso_quote_headers_all a, aso_quote_statuses_vl b
5344: where quote_header_id = quote_hdr_id
5345: and a.quote_status_id = b.quote_status_id;
5346:
5347: rec_quote_status_code c_quote_status_code%rowtype;