[Home] [Help]
415: where agreement_id = p_contract_id;
416:
417: cursor c_payment_id(p_quote_hdr_id number) is
418: select payment_id
419: from aso_payments
420: where quote_header_id = p_quote_hdr_id
421: and quote_line_id is null;
422:
423: L_API_NAME CONSTANT VARCHAR2(30) := 'handle_header_agreements';
790: ELSE
791: IBE_Util.Debug('existing cart,x_qte_header_rec.quote_header_id='|| x_qte_header_rec.quote_header_id);
792: IBE_Util.Debug('checking if a header payment record is already present...');
793: BEGIN
794: SELECT payment_id into l_org_payment_id FROM ASO_payments
795: WHERE QUOTE_HEADER_ID = x_qte_header_rec.quote_header_id AND quote_line_id is null;
796: IBE_Util.Debug('header payment record found,l_org_payment_id='||l_org_payment_id);
797: EXCEPTION
798: WHEN NO_DATA_FOUND THEN
3246: ,
3247: p_ln_Payment_Tbl IN OUT NOCOPY ASO_Quote_Pub.Payment_Tbl_Type
3248:
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;
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
3258: from aso_payments
3259: where quote_header_id = p_quote_header_id
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
3258: from aso_payments
3259: where quote_header_id = p_quote_header_id
3260: and quote_line_id = p_quote_line_id;
3261:
3262: rec_term_pricelist c_term_pricelist%rowtype;
3330: -- take care of price list id
3331: l_qte_line_tbl(l_ql_loop_counter).price_list_id := l_price_list_id;
3332:
3333: -- now deal with payment term id -
3334: /*Check for the presence of the payment record in the database(aso_payments),
3335: if the record is present then operation code in the l_ln_payment_tbl= 'UPDATE'
3336: else it is 'CREATE'*/
3337: l_payment_id := fnd_api.g_miss_num;
3338: for rec_payment_id in c_payment_id( l_qte_line_tbl(l_ql_loop_counter).quote_header_id,
6516:
6517: cursor c_check_payment_rec_exist(l_quote_header_id number)
6518: is
6519: select payment_id, PAYMENT_TYPE_CODE
6520: from ASO_payments
6521: where QUOTE_HEADER_ID = l_quote_header_id and
6522: quote_line_id is null;
6523: rec_payment_rec_exist c_check_payment_rec_exist%rowtype;
6524: