APPS.IBE_QUOTE_SAVE_PVT dependencies on OE_AGREEMENTS

Line 395: from oe_agreements

391: x_hdr_payment_tbl OUT NOCOPY aso_quote_pub.Payment_Tbl_Type ) is
392:
393: cursor c_term_id(p_contract_id number) is
394: select term_id
395: from oe_agreements
396: where agreement_id = p_contract_id;
397:
398: cursor c_payment_id(p_quote_hdr_id number) is
399: select payment_id

Line 640: FROM OE_Agreements_B

636: -- if contract_id is not null, get its associated price list id from DB
637: ELSE
638: SELECT price_list_id
639: INTO x_qte_header_rec.price_list_id
640: FROM OE_Agreements_B
641: WHERE agreement_id = x_qte_header_rec.contract_id;
642:
643: l_agmt_associated := FND_API.G_TRUE;
644: END IF;

Line 716: FROM OE_Agreements_B

712: x_qte_header_rec.contract_id := l_contract_id;
713:
714: SELECT price_list_id
715: INTO x_qte_header_rec.price_list_id
716: FROM OE_Agreements_B
717: WHERE agreement_id = l_contract_id;
718: END IF;
719: --DBMS_OUTPUT.PUT_line('BEFORE header agreements ');
720: header_agreements(

Line 3234: from oe_agreements_b

3230: ) is
3231: /*This cursor selects price_list_id and term_id(payment_term_id as in aso_payments) */
3232: cursor c_term_pricelist(p_agreement_id number) is
3233: select price_list_id, term_id
3234: from oe_agreements_b
3235: where agreement_id = p_agreement_id;
3236: /*This cursor selects payment_id from aso_payments based on the qte_header_id and quote_line_id*/
3237: cursor c_payment_id(p_quote_header_id number, p_quote_line_id number) is
3238: select payment_id

Line 3286: --retrieve price_list_id from oe_agreements

3282: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3283: ibe_util.debug('Non Empty agreement value');
3284: END IF;
3285: for rec_term_pricelist in c_term_pricelist(l_qte_line_tbl(l_ql_loop_counter).agreement_id) loop
3286: --retrieve price_list_id from oe_agreements
3287: l_price_list_id := rec_term_pricelist.price_list_id;
3288: l_term_id := rec_term_pricelist.term_id;
3289: end loop;
3290: elsif (l_qte_line_tbl(l_ql_loop_counter).agreement_id is null) then

Line 4357: from oe_agreements_b

4353: /*This cursor retrieves payment_term_id and price_list_id for a given agreement id
4354: this modification added to support bundles in iStore */
4355: cursor c_term_pricelist(p_agreement_id number) is
4356: select term_id, price_list_id
4357: from oe_agreements_b
4358: where agreement_id = p_agreement_id;
4359:
4360: Cursor c_quote_sts_id(p_status_code varchar2) is
4361: select quote_status_id