APPS.IBE_QUOTE_SAVE_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 699: FROM aso_quote_headers_all

695: l_quote_source_code,
696: l_resource_id,
697: l_publish_flag,
698: l_price_list_id
699: FROM aso_quote_headers_all
700: WHERE quote_header_id = x_qte_header_rec.quote_header_id;
701: --DBMS_OUTPUT.PUT_line('after select statement ');
702: -- set last_update_date
703: --Removing this check because this is already being done in validate_user_update

Line 1346: from aso_quote_headers_all

1342: where quote_header_id = c_qte_header_id;
1343:
1344: cursor c_get_party_id is
1345: select party_id, cust_account_id
1346: from aso_quote_headers_all
1347: where quote_header_id = p_quote_header_id;
1348:
1349:
1350: rec_get_quote_status c_get_quote_status%rowtype;

Line 1996: from aso_quote_headers_all

1992:
1993: --maithili added for R12
1994: Cursor c_get_Marketing_source(p_quote_header_id NUMBER) is
1995: select marketing_source_code_id
1996: from aso_quote_headers_all
1997: where quote_header_id = p_quote_header_id;
1998:
1999: l_marketing_source_code_id NUMBER;
2000:

Line 3435: from aso_quote_headers_all

3431: X_expiration_date OUT NOCOPY DATE) is
3432:
3433: Cursor c_check_resource_name(quote_hdr_id number) is
3434: Select resource_id,quote_name
3435: from aso_quote_headers_all
3436: Where quote_header_id = quote_hdr_id;
3437:
3438: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_Quote_Save_pvt';
3439: l_api_name CONSTANT VARCHAR2(50) := 'Get_quote_expiration_date_pvt';

Line 3602: from aso_quote_headers_all

3598: p_notes IN VARCHAR2 := NULL) is
3599:
3600: Cursor c_find_resourceid(qte_hdr_id number) is
3601: select resource_id,ASSISTANCE_REASON_CODE
3602: from aso_quote_headers_all
3603: where quote_header_id = qte_hdr_id;
3604: /*Cursor c_get_jtf_resource(salesrep number) is
3605: select resource_id
3606: from jtf_rs_salesreps_mo_v

Line 4398: aso_quote_headers_all where quote_header_id = qte_header_id;

4394: where status_code = p_status_code;
4395:
4396: cursor c_pricing_indicators(qte_header_id number) is -- change line logic pricing Test
4397: select quote_header_id, pricing_status_indicator, tax_status_indicator from
4398: aso_quote_headers_all where quote_header_id = qte_header_id;
4399:
4400: rec_term_pricelist c_term_pricelist%rowtype;
4401: rec_quote_sts_id c_quote_sts_id%rowtype;
4402: loop_count number;

Line 4769: l_upd_stmnt := 'Update ASO_QUOTE_HEADERS_ALL set minisite_id = :1

4765: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4766: IBE_Util.Debug('In Update Header MinisiteId Dynamic SQL');
4767: END IF;
4768: IF (p_minisite_id <> FND_API.G_MISS_NUM) THEN
4769: l_upd_stmnt := 'Update ASO_QUOTE_HEADERS_ALL set minisite_id = :1
4770: where quote_header_id = :2';
4771: EXECUTE IMMEDIATE l_upd_stmnt using p_minisite_id,x_Qte_header_rec.quote_header_id;
4772: IF SQL%ROWCOUNT <> 1 THEN
4773: RAISE FND_API.G_EXC_ERROR;

Line 7313: FROM ASO_QUOTE_HEADERS_ALL

7309: p_minisite_id IN NUMBER ) is
7310:
7311: CURSOR c_check_for_quote(c_quote_header_id NUMBER) IS
7312: SELECT count(*) is_published_quote
7313: FROM ASO_QUOTE_HEADERS_ALL
7314: WHERE quote_header_id = c_quote_header_id
7315: AND resource_id is not null
7316: AND publish_flag = 'Y';
7317: