DBA Data[Home] [Help]

APPS.ASO_QUOTE_LINES_PVT dependencies on ASO_PAYMENTS

Line 1016: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows l_payment_tbl(i).payment_term_id'||l_payment_tbl(i).payment_term_id, 1, 'Y');

1012: x_payment_tbl(i) := l_payment_rec;
1013: l_payment_rec.payment_term_id_from := l_payment_tbl(i).payment_term_id;
1014:
1015: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1016: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows l_payment_tbl(i).payment_term_id'||l_payment_tbl(i).payment_term_id, 1, 'Y');
1017: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows l_payment_rec.PAYMENT_TERM_ID_FROM'||l_payment_rec.PAYMENT_TERM_ID_FROM, 1, 'Y');
1018: END IF;
1019: -- BC4J Fix
1020: --x_payment_tbl(i).PAYMENT_ID := NULL;

Line 1017: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows l_payment_rec.PAYMENT_TERM_ID_FROM'||l_payment_rec.PAYMENT_TERM_ID_FROM, 1, 'Y');

1013: l_payment_rec.payment_term_id_from := l_payment_tbl(i).payment_term_id;
1014:
1015: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1016: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows l_payment_tbl(i).payment_term_id'||l_payment_tbl(i).payment_term_id, 1, 'Y');
1017: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows l_payment_rec.PAYMENT_TERM_ID_FROM'||l_payment_rec.PAYMENT_TERM_ID_FROM, 1, 'Y');
1018: END IF;
1019: -- BC4J Fix
1020: --x_payment_tbl(i).PAYMENT_ID := NULL;
1021: x_payment_tbl(i).PAYMENT_TERM_ID_FROM := l_payment_rec.PAYMENT_TERM_ID_FROM;

Line 1276: from aso_payments

1272: AND organization_id = p_organization_id;
1273:
1274: Cursor get_hdr_term(l_qte_hdr_id number) is
1275: select payment_term_id
1276: from aso_payments
1277: where quote_header_id = l_qte_hdr_id
1278: and quote_line_id is null;
1279:
1280: l_hdr_term_id number := null;

Line 4852: FROM ASO_PAYMENTS

4848: AND relationship_type_code = 'SERVICE';
4849:
4850: CURSOR c_db_payment_terms(p_payment_id number) IS
4851: SELECT payment_term_id_from,payment_term_id
4852: FROM ASO_PAYMENTS
4853: WHERE payment_id = p_payment_id;
4854:
4855: CURSOR c_db_ship_freight_terms(p_shipment_id number) IS
4856: SELECT ship_method_code_from,ship_method_code,

Line 4867: from aso_payments

4863: where quote_line_detail_id = p_quote_line_detail_id;
4864:
4865: cursor get_payment_type_code( l_payment_id Number) is
4866: select payment_type_code
4867: from aso_payments
4868: where payment_id = l_payment_id;
4869:
4870: cursor get_bill_to_party( l_qte_line_id Number) is
4871: select invoice_to_cust_party_id

Line 8471: -- insert rows into aso_payments_tbl

8467:
8468: -- End of New code to call aso_pricing_int.delete_promotion 07/22/02
8469:
8470:
8471: -- insert rows into aso_payments_tbl
8472:
8473:
8474: FOR i IN 1..l_Payment_Tbl.count LOOP
8475: l_payment_rec := l_payment_tbl(i);

Line 8487: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows Quote Line l_payment_tbl(i).payment_term_id'||l_payment_tbl(i).payment_term_id, 1, 'Y');

8483: -- BC4J Fix
8484: -- x_payment_tbl(i).PAYMENT_ID := null;
8485: l_payment_rec.PAYMENT_TERM_ID_FROM := l_payment_tbl(i).payment_term_id;
8486: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8487: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows Quote Line l_payment_tbl(i).payment_term_id'||l_payment_tbl(i).payment_term_id, 1, 'Y');
8488: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows Quote Linel_payment_rec.PAYMENT_TERM_ID_FROM'||l_payment_rec.PAYMENT_TERM_ID_FROM, 1, 'Y');
8489: END IF;
8490:
8491: -- Suyog Payments Changes

Line 8488: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows Quote Linel_payment_rec.PAYMENT_TERM_ID_FROM'||l_payment_rec.PAYMENT_TERM_ID_FROM, 1, 'Y');

8484: -- x_payment_tbl(i).PAYMENT_ID := null;
8485: l_payment_rec.PAYMENT_TERM_ID_FROM := l_payment_tbl(i).payment_term_id;
8486: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8487: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows Quote Line l_payment_tbl(i).payment_term_id'||l_payment_tbl(i).payment_term_id, 1, 'Y');
8488: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows Quote Linel_payment_rec.PAYMENT_TERM_ID_FROM'||l_payment_rec.PAYMENT_TERM_ID_FROM, 1, 'Y');
8489: END IF;
8490:
8491: -- Suyog Payments Changes
8492:

Line 8533: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Update Rows l_payment_rec.payment_term_id'||l_payment_rec.payment_term_id, 1, 'Y');

8529: ELSE
8530: l_payment_rec.payment_term_id_from := l_payment_rec.payment_term_id;
8531: END IF;
8532: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8533: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Update Rows l_payment_rec.payment_term_id'||l_payment_rec.payment_term_id, 1, 'Y');
8534: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Update Rows l_payment_rec.PAYMENT_TERM_ID_FROM'||l_payment_rec.PAYMENT_TERM_ID_FROM, 1, 'Y');
8535: END IF;
8536:
8537:

Line 8534: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Update Rows l_payment_rec.PAYMENT_TERM_ID_FROM'||l_payment_rec.PAYMENT_TERM_ID_FROM, 1, 'Y');

8530: l_payment_rec.payment_term_id_from := l_payment_rec.payment_term_id;
8531: END IF;
8532: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8533: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Update Rows l_payment_rec.payment_term_id'||l_payment_rec.payment_term_id, 1, 'Y');
8534: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Update Rows l_payment_rec.PAYMENT_TERM_ID_FROM'||l_payment_rec.PAYMENT_TERM_ID_FROM, 1, 'Y');
8535: END IF;
8536:
8537:
8538: -- Suyog Payments Changes

Line 9664: aso_payments_pkg.Delete_Row(p_payment_id => l_payment_tbl(1).payment_id);

9660: IF aso_debug_pub.g_debug_flag = 'Y' THEN
9661: aso_debug_pub.add('Delete_Quote_Line: Before calling table handler to delete payment row', 1, 'Y');
9662: END IF;
9663:
9664: aso_payments_pkg.Delete_Row(p_payment_id => l_payment_tbl(1).payment_id);
9665: end if;
9666:
9667: end if;
9668: