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 680: FROM aso_quote_headers_all

676: l_quote_source_code,
677: l_resource_id,
678: l_publish_flag,
679: l_price_list_id
680: FROM aso_quote_headers_all
681: WHERE quote_header_id = x_qte_header_rec.quote_header_id;
682: --DBMS_OUTPUT.PUT_line('after select statement ');
683: -- set last_update_date
684: --Removing this check because this is already being done in validate_user_update

Line 1327: from aso_quote_headers_all

1323: where quote_header_id = c_qte_header_id;
1324:
1325: cursor c_get_party_id is
1326: select party_id, cust_account_id
1327: from aso_quote_headers_all
1328: where quote_header_id = p_quote_header_id;
1329:
1330:
1331: rec_get_quote_status c_get_quote_status%rowtype;

Line 1977: from aso_quote_headers_all

1973:
1974: --maithili added for R12
1975: Cursor c_get_Marketing_source(p_quote_header_id NUMBER) is
1976: select marketing_source_code_id
1977: from aso_quote_headers_all
1978: where quote_header_id = p_quote_header_id;
1979:
1980: l_marketing_source_code_id NUMBER;
1981:

Line 3416: from aso_quote_headers_all

3412: X_expiration_date OUT NOCOPY DATE) is
3413:
3414: Cursor c_check_resource_name(quote_hdr_id number) is
3415: Select resource_id,quote_name
3416: from aso_quote_headers_all
3417: Where quote_header_id = quote_hdr_id;
3418:
3419: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_Quote_Save_pvt';
3420: l_api_name CONSTANT VARCHAR2(50) := 'Get_quote_expiration_date_pvt';

Line 3583: from aso_quote_headers_all

3579: p_notes IN VARCHAR2 := NULL) is
3580:
3581: Cursor c_find_resourceid(qte_hdr_id number) is
3582: select resource_id,ASSISTANCE_REASON_CODE
3583: from aso_quote_headers_all
3584: where quote_header_id = qte_hdr_id;
3585: /*Cursor c_get_jtf_resource(salesrep number) is
3586: select resource_id
3587: from jtf_rs_salesreps_mo_v

Line 3805: -- For the bug, 3014723, retrieve the resource_id from aso_quote_headers, instead of using the cached profile value.

3801: END IF;
3802: IF (lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3804: END IF;
3805: -- For the bug, 3014723, retrieve the resource_id from aso_quote_headers, instead of using the cached profile value.
3806: For rec_find_resourceid in c_find_resourceid(p_quote_header_id) loop
3807: l_resource_id := rec_find_resourceid.resource_id ;
3808: Exit when c_find_resourceid%notfound;
3809: End loop;

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

4678: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4679: IBE_Util.Debug('In Update Header MinisiteId Dynamic SQL');
4680: END IF;
4681: IF (p_minisite_id <> FND_API.G_MISS_NUM) THEN
4682: l_upd_stmnt := 'Update ASO_QUOTE_HEADERS_ALL set minisite_id = :1
4683: where quote_header_id = :2';
4684: EXECUTE IMMEDIATE l_upd_stmnt using p_minisite_id,x_Qte_header_rec.quote_header_id;
4685: IF SQL%ROWCOUNT <> 1 THEN
4686: RAISE FND_API.G_EXC_ERROR;

Line 5872: from ASO_quote_headers

5868: -- billTo
5869: cursor c_check_billTo_rec_exist(l_quote_header_id number)
5870: is
5871: select quote_header_id, INVOICE_TO_PARTY_SITE_ID
5872: from ASO_quote_headers
5873: where QUOTE_HEADER_ID = l_quote_header_id;
5874: rec_billTo_rec_exist c_check_billTo_rec_exist%rowtype;
5875:
5876: cursor c_check_billTo_partyId(l_quote_header_id number)

Line 5879: from ASO_quote_headers

5875:
5876: cursor c_check_billTo_partyId(l_quote_header_id number)
5877: is
5878: select invoice_to_party_id
5879: from ASO_quote_headers
5880: where QUOTE_HEADER_ID = l_quote_header_id and
5881: INVOICE_TO_CUST_ACCOUNT_ID is null and
5882: INVOICE_TO_PARTY_SITE_ID is null;
5883:

Line 6816: from ASO_quote_headers

6812:
6813: cursor c_check_endTo_rec_exist(l_quote_header_id number)
6814: is
6815: select quote_header_id, end_customer_party_id, end_customer_cust_party_id, end_customer_party_site_id, end_customer_cust_account_id
6816: from ASO_quote_headers
6817: where QUOTE_HEADER_ID = l_quote_header_id;
6818: rec_endTo_rec_exist c_check_endTo_rec_exist%rowtype;
6819:
6820: cursor c_get_shipTo_info(l_quote_header_id number)

Line 7177: FROM ASO_QUOTE_HEADERS_ALL

7173: p_minisite_id IN NUMBER ) is
7174:
7175: CURSOR c_check_for_quote(c_quote_header_id NUMBER) IS
7176: SELECT count(*) is_published_quote
7177: FROM ASO_QUOTE_HEADERS_ALL
7178: WHERE quote_header_id = c_quote_header_id
7179: AND resource_id is not null
7180: AND publish_flag = 'Y';
7181:

Line 7212: FROM aso_quote_headers

7208: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
7209:
7210: CURSOR c_get_orig_quote_details(p_quote_header_id NUMBER) IS
7211: SELECT order_type_id,currency_code
7212: FROM aso_quote_headers
7213: WHERE quote_header_id = p_quote_header_id;
7214: l_order_type_id NUMBER;
7215: l_currency_code VARCHAR2(10);
7216:

Line 7539: l_instance_tbl ASO_QUOTE_HEADERS_PVT. Instance_Tbl_Type ;

7535: l_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
7536: x_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
7537: l_control_rec ASO_Quote_Pub.Control_Rec_Type :=
7538: ASO_Quote_Pub.G_Miss_Control_Rec;
7539: l_instance_tbl ASO_QUOTE_HEADERS_PVT. Instance_Tbl_Type ;
7540: l_instance_rec ASO_QUOTE_HEADERS_PVT.Instance_rec_Type ;
7541:
7542: l_refcursor_query VARCHAR2(1000) := 'select aql.quote_header_id,
7543: aql.quote_line_id,

Line 7540: l_instance_rec ASO_QUOTE_HEADERS_PVT.Instance_rec_Type ;

7536: x_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
7537: l_control_rec ASO_Quote_Pub.Control_Rec_Type :=
7538: ASO_Quote_Pub.G_Miss_Control_Rec;
7539: l_instance_tbl ASO_QUOTE_HEADERS_PVT. Instance_Tbl_Type ;
7540: l_instance_rec ASO_QUOTE_HEADERS_PVT.Instance_rec_Type ;
7541:
7542: l_refcursor_query VARCHAR2(1000) := 'select aql.quote_header_id,
7543: aql.quote_line_id,
7544: aql.inventory_item_id,