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 8589: -- insert rows into aso_payments_tbl

8585:
8586: -- End of New code to call aso_pricing_int.delete_promotion 07/22/02
8587:
8588:
8589: -- insert rows into aso_payments_tbl
8590:
8591:
8592: FOR i IN 1..l_Payment_Tbl.count LOOP
8593: l_payment_rec := l_payment_tbl(i);

Line 8605: 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');

8601: -- BC4J Fix
8602: -- x_payment_tbl(i).PAYMENT_ID := null;
8603: l_payment_rec.PAYMENT_TERM_ID_FROM := l_payment_tbl(i).payment_term_id;
8604: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8605: 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');
8606: 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');
8607: END IF;
8608:
8609: -- Suyog Payments Changes

Line 8606: 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');

8602: -- x_payment_tbl(i).PAYMENT_ID := null;
8603: l_payment_rec.PAYMENT_TERM_ID_FROM := l_payment_tbl(i).payment_term_id;
8604: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8605: 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');
8606: 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');
8607: END IF;
8608:
8609: -- Suyog Payments Changes
8610:

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

8647: ELSE
8648: l_payment_rec.payment_term_id_from := l_payment_rec.payment_term_id;
8649: END IF;
8650: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8651: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Update Rows l_payment_rec.payment_term_id'||l_payment_rec.payment_term_id, 1, 'Y');
8652: 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');
8653: END IF;
8654:
8655:

Line 8652: 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');

8648: l_payment_rec.payment_term_id_from := l_payment_rec.payment_term_id;
8649: END IF;
8650: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8651: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Update Rows l_payment_rec.payment_term_id'||l_payment_rec.payment_term_id, 1, 'Y');
8652: 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');
8653: END IF;
8654:
8655:
8656: -- Suyog Payments Changes

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

9778: IF aso_debug_pub.g_debug_flag = 'Y' THEN
9779: aso_debug_pub.add('Delete_Quote_Line: Before calling table handler to delete payment row', 1, 'Y');
9780: END IF;
9781:
9782: aso_payments_pkg.Delete_Row(p_payment_id => l_payment_tbl(1).payment_id);
9783: end if;
9784:
9785: end if;
9786: