APPS.IBE_QUOTE_SAVE_PVT dependencies on OE_AGREEMENTS

Line 414: from oe_agreements

410: x_hdr_payment_tbl OUT NOCOPY aso_quote_pub.Payment_Tbl_Type ) is
411:
412: cursor c_term_id(p_contract_id number) is
413: select term_id
414: from oe_agreements
415: where agreement_id = p_contract_id;
416:
417: cursor c_payment_id(p_quote_hdr_id number) is
418: select payment_id

Line 659: FROM OE_Agreements_B

655: -- if contract_id is not null, get its associated price list id from DB
656: ELSE
657: SELECT price_list_id
658: INTO x_qte_header_rec.price_list_id
659: FROM OE_Agreements_B
660: WHERE agreement_id = x_qte_header_rec.contract_id;
661:
662: l_agmt_associated := FND_API.G_TRUE;
663: END IF;

Line 735: FROM OE_Agreements_B

731: x_qte_header_rec.contract_id := l_contract_id;
732:
733: SELECT price_list_id
734: INTO x_qte_header_rec.price_list_id
735: FROM OE_Agreements_B
736: WHERE agreement_id = l_contract_id;
737: END IF;
738: --DBMS_OUTPUT.PUT_line('BEFORE header agreements ');
739: header_agreements(

Line 3253: from oe_agreements_b

3249: ) is
3250: /*This cursor selects price_list_id and term_id(payment_term_id as in aso_payments) */
3251: cursor c_term_pricelist(p_agreement_id number) is
3252: select price_list_id, term_id
3253: from oe_agreements_b
3254: where agreement_id = p_agreement_id;
3255: /*This cursor selects payment_id from aso_payments based on the qte_header_id and quote_line_id*/
3256: cursor c_payment_id(p_quote_header_id number, p_quote_line_id number) is
3257: select payment_id

Line 3305: --retrieve price_list_id from oe_agreements

3301: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3302: ibe_util.debug('Non Empty agreement value');
3303: END IF;
3304: for rec_term_pricelist in c_term_pricelist(l_qte_line_tbl(l_ql_loop_counter).agreement_id) loop
3305: --retrieve price_list_id from oe_agreements
3306: l_price_list_id := rec_term_pricelist.price_list_id;
3307: l_term_id := rec_term_pricelist.term_id;
3308: end loop;
3309: elsif (l_qte_line_tbl(l_ql_loop_counter).agreement_id is null) then

Line 4388: from oe_agreements_b

4384: /*This cursor retrieves payment_term_id and price_list_id for a given agreement id
4385: this modification added to support bundles in iStore */
4386: cursor c_term_pricelist(p_agreement_id number) is
4387: select term_id, price_list_id
4388: from oe_agreements_b
4389: where agreement_id = p_agreement_id;
4390:
4391: Cursor c_quote_sts_id(p_status_code varchar2) is
4392: select quote_status_id