APPS.IBE_QUOTE_SAVESHARE_PVT dependencies on ASO_QUOTE_HEADERS

Line 719: FROM aso_quote_headers

715: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
716:
717: CURSOR c_order_type(p_quote_header_id NUMBER) IS
718: SELECT order_type_id
719: FROM aso_quote_headers
720: WHERE quote_header_id = p_quote_header_id;
721: l_order_type_id NUMBER;
722:
723:

Line 1039: from ASO_QUOTE_HEADERS

1035: l_last_update_date_tmp DATE;
1036:
1037: CURSOR c_q_datenumber (c_quote_header_id number) is
1038: select last_update_date, quote_number
1039: from ASO_QUOTE_HEADERS
1040: where quote_header_id = c_quote_header_id;
1041:
1042:
1043: CURSOR c_q_date (c_quote_header_id number) is

Line 1045: from ASO_QUOTE_HEADERS

1041:
1042:
1043: CURSOR c_q_date (c_quote_header_id number) is
1044: select last_update_date
1045: from ASO_QUOTE_HEADERS
1046: where quote_header_id = c_quote_header_id;
1047:
1048: CURSOR c_q_number (c_quote_header_id number) is
1049: select quote_number

Line 1050: from ASO_QUOTE_HEADERS

1046: where quote_header_id = c_quote_header_id;
1047:
1048: CURSOR c_q_number (c_quote_header_id number) is
1049: select quote_number
1050: from ASO_QUOTE_HEADERS
1051: where quote_header_id = c_quote_header_id;
1052:
1053:
1054: /* Cursor to select the cart name used for "Replace Cart" functionality*/

Line 1057: FROM aso_quote_headers

1053:
1054: /* Cursor to select the cart name used for "Replace Cart" functionality*/
1055: CURSOR c_cart_name(p_quote_header_id number) is
1056: SELECT quote_name, quote_number
1057: FROM aso_quote_headers
1058: WHERE quote_header_id =p_quote_header_id;
1059:
1060: /* Cursor to select the quote owners used for "Replace Cart" functionality done by a recepient(sharee)*/
1061:

Line 1063: select created_by from aso_quote_headers_all

1059:
1060: /* Cursor to select the quote owners used for "Replace Cart" functionality done by a recepient(sharee)*/
1061:
1062: cursor c_check_cart_owner(p_quote_header_id number) is
1063: select created_by from aso_quote_headers_all
1064: where quote_header_id = p_quote_header_id;
1065:
1066: rec_cart_name c_cart_name%rowtype;
1067: l_target_cart_owner number;

Line 1625: from aso_quote_headers_all

1621: l_last_update_date_tmp DATE;
1622:
1623: cursor c_owner_party(c_quote_header_id number) is
1624: select party_id, cust_account_id, quote_header_id
1625: from aso_quote_headers_all
1626: where quote_header_id = c_quote_header_id;
1627:
1628: rec_owner_party c_owner_party%rowtype;
1629:

Line 2104: from aso_quote_headers

2100: quote_name,
2101: party_id,
2102: cust_account_id,
2103: currency_code
2104: from aso_quote_headers
2105: where quote_header_id = p_quote_header_id;
2106:
2107: cursor c_getIdDate(p_party_id number
2108: ,p_cust_account_id number

Line 2111: from aso_quote_headers

2107: cursor c_getIdDate(p_party_id number
2108: ,p_cust_account_id number
2109: ,p_quote_source_code varchar2) is
2110: select quote_header_id,last_update_date
2111: from aso_quote_headers
2112: where party_id = p_party_id
2113: and cust_account_id = p_cust_account_id
2114: and quote_name = 'IBEACTIVECART'
2115: and quote_source_code = p_quote_source_code

Line 2130: from aso_quote_headers

2126: and cust_account_id = c_cust_account_id;
2127:
2128: cursor c_get_quote_details(c_quote_header_id number) is
2129: select resource_id, publish_flag
2130: from aso_quote_headers
2131: where quote_header_id = c_quote_header_id;
2132:
2133: rec_getHdr c_getHdr%rowtype;
2134: rec_get_retrieval_num c_get_retrieval_num%rowtype;

Line 3158: from aso_quote_headers

3154: := ASO_Quote_Pub.g_miss_qte_header_rec;
3155:
3156: cursor C_GETHEADERREC(qte_header_id number) is
3157: select quote_password, quote_number, quote_version
3158: from aso_quote_headers
3159: where quote_header_id = qte_header_id;
3160:
3161: BEGIN
3162: