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.IBE_QUOTE_SAVE_PVT dependencies on ASO_QUOTE_HEADERS

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 3824: -- For the bug, 3014723, retrieve the resource_id from aso_quote_headers, instead of using the cached profile value.

3820: END IF;
3821: IF (lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3823: END IF;
3824: -- For the bug, 3014723, retrieve the resource_id from aso_quote_headers, instead of using the cached profile value.
3825: For rec_find_resourceid in c_find_resourceid(p_quote_header_id) loop
3826: l_resource_id := rec_find_resourceid.resource_id ;
3827: Exit when c_find_resourceid%notfound;
3828: End loop;

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 5976: from ASO_quote_headers

5972: -- billTo
5973: cursor c_check_billTo_rec_exist(l_quote_header_id number)
5974: is
5975: select quote_header_id, INVOICE_TO_PARTY_SITE_ID
5976: from ASO_quote_headers
5977: where QUOTE_HEADER_ID = l_quote_header_id;
5978: rec_billTo_rec_exist c_check_billTo_rec_exist%rowtype;
5979:
5980: cursor c_check_billTo_partyId(l_quote_header_id number)

Line 5983: from ASO_quote_headers

5979:
5980: cursor c_check_billTo_partyId(l_quote_header_id number)
5981: is
5982: select invoice_to_party_id
5983: from ASO_quote_headers
5984: where QUOTE_HEADER_ID = l_quote_header_id and
5985: INVOICE_TO_CUST_ACCOUNT_ID is null and
5986: INVOICE_TO_PARTY_SITE_ID is null;
5987:

Line 6952: from ASO_quote_headers

6948:
6949: cursor c_check_endTo_rec_exist(l_quote_header_id number)
6950: is
6951: select quote_header_id, end_customer_party_id, end_customer_cust_party_id, end_customer_party_site_id, end_customer_cust_account_id
6952: from ASO_quote_headers
6953: where QUOTE_HEADER_ID = l_quote_header_id;
6954: rec_endTo_rec_exist c_check_endTo_rec_exist%rowtype;
6955:
6956: cursor c_get_shipTo_info(l_quote_header_id number)

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:

Line 7348: FROM aso_quote_headers

7344: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
7345:
7346: CURSOR c_get_orig_quote_details(p_quote_header_id NUMBER) IS
7347: SELECT order_type_id,currency_code, price_list_id -- bug 11805700,scnagara
7348: FROM aso_quote_headers
7349: WHERE quote_header_id = p_quote_header_id;
7350: l_order_type_id NUMBER;
7351: l_currency_code VARCHAR2(10);
7352: l_price_list_id NUMBER; -- bug 11805700,scnagara

Line 7681: l_instance_tbl ASO_QUOTE_HEADERS_PVT. Instance_Tbl_Type ;

7677: l_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
7678: x_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
7679: l_control_rec ASO_Quote_Pub.Control_Rec_Type :=
7680: ASO_Quote_Pub.G_Miss_Control_Rec;
7681: l_instance_tbl ASO_QUOTE_HEADERS_PVT. Instance_Tbl_Type ;
7682: l_instance_rec ASO_QUOTE_HEADERS_PVT.Instance_rec_Type ;
7683:
7684: l_refcursor_query VARCHAR2(1000) := 'select aql.quote_header_id,
7685: aql.quote_line_id,

Line 7682: l_instance_rec ASO_QUOTE_HEADERS_PVT.Instance_rec_Type ;

7678: x_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
7679: l_control_rec ASO_Quote_Pub.Control_Rec_Type :=
7680: ASO_Quote_Pub.G_Miss_Control_Rec;
7681: l_instance_tbl ASO_QUOTE_HEADERS_PVT. Instance_Tbl_Type ;
7682: l_instance_rec ASO_QUOTE_HEADERS_PVT.Instance_rec_Type ;
7683:
7684: l_refcursor_query VARCHAR2(1000) := 'select aql.quote_header_id,
7685: aql.quote_line_id,
7686: aql.inventory_item_id,