APPS.IBE_QUOTE_SAVE_PVT dependencies on ASO_QUOTE_HEADERS_ALL

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 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 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: