eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_PAYMENTS

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

993: l_payment_rec := p_payment_tbl(i);
994: l_payment_rec.payment_term_id_from := p_payment_tbl(i).payment_term_id;
995:
996: IF aso_debug_pub.g_debug_flag = 'Y' THEN
997: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows p_payment_tbl(i).payment_term_id'||p_payment_tbl(i).payment_term_id, 1, 'Y');
998: 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');
999: END IF;
1000:
1001: -- BC4J Fix

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

994: l_payment_rec.payment_term_id_from := p_payment_tbl(i).payment_term_id;
995:
996: IF aso_debug_pub.g_debug_flag = 'Y' THEN
997: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows p_payment_tbl(i).payment_term_id'||p_payment_tbl(i).payment_term_id, 1, 'Y');
998: 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');
999: END IF;
1000:
1001: -- BC4J Fix
1002: --x_payment_tbl(i).payment_id := null;

Line 1662: FROM ASO_PAYMENTS

1658:
1659: -- The following cursor is needed for Payment From column Maintenance.
1660: CURSOR c_db_payment_terms(p_payment_id NUMBER) IS
1661: SELECT payment_term_id_from,payment_term_id
1662: FROM ASO_PAYMENTS
1663: WHERE payment_id = p_payment_id;
1664:
1665: -- The following cursors is needed for ship_method_code and Freight Terms Code From column Maintenance.
1666: CURSOR c_db_ship_freight_terms(p_shipment_id NUMBER) IS

Line 1678: from aso_payments

1674: where quote_header_id = p_qte_header_rec.quote_header_id;
1675:
1676: cursor get_payment_type_code( l_payment_id Number) is
1677: select payment_type_code
1678: from aso_payments
1679: where payment_id = l_payment_id;
1680:
1681: cursor get_bill_to_party( l_qte_hdr_id Number) is
1682: select invoice_to_cust_party_id

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

2161: l_payment_rec := p_payment_tbl(i);
2162: l_payment_rec.PAYMENT_TERM_ID_FROM := p_payment_tbl(i).payment_term_id;
2163:
2164: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2165: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows p_payment_tbl(i).payment_term_id'||p_payment_tbl(i).payment_term_id, 1, 'Y');
2166: 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');
2167: END IF;
2168: -- BC4J Fix
2169: --x_payment_tbl(i).PAYMENT_ID := NULL;

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

2162: l_payment_rec.PAYMENT_TERM_ID_FROM := p_payment_tbl(i).payment_term_id;
2163:
2164: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2165: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows p_payment_tbl(i).payment_term_id'||p_payment_tbl(i).payment_term_id, 1, 'Y');
2166: 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');
2167: END IF;
2168: -- BC4J Fix
2169: --x_payment_tbl(i).PAYMENT_ID := NULL;
2170: x_payment_tbl(i).LAST_UPDATE_DATE := l_sysdate;

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

2224:
2225: END IF;
2226:
2227: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2228: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Update Rows l_payment_rec.payment_term_id'||l_payment_rec.payment_term_id, 1, 'Y');
2229: 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');
2230: END IF;
2231:
2232: x_payment_tbl(i).last_update_date := l_sysdate;

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

2225: END IF;
2226:
2227: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2228: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Update Rows l_payment_rec.payment_term_id'||l_payment_rec.payment_term_id, 1, 'Y');
2229: 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');
2230: END IF;
2231:
2232: x_payment_tbl(i).last_update_date := l_sysdate;
2233: x_payment_tbl(i).payment_term_id_from := l_payment_rec.payment_term_id_from;

Line 3497: FROM aso_payments

3493:
3494:
3495: Cursor get_hdr_payment_term IS
3496: SELECT payment_term_id
3497: FROM aso_payments
3498: WHERE quote_header_id = p_qte_header_id
3499: and quote_line_id is null;
3500:
3501: Cursor get_hdr_curr_code IS

Line 3513: from aso_payments

3509: where quote_header_id = p_qte_header_id;
3510:
3511: Cursor get_total_payment_amount( l_qte_hdr_id number) is
3512: select sum(payment_amount)
3513: from aso_payments
3514: where quote_header_id = l_qte_hdr_id
3515: and quote_line_id is not null;
3516:
3517: l_total_list_price NUMBER := 0;

Line 4043: FROM aso_payments

4039: and quote_line_id = p_quote_line_id;
4040:
4041: Cursor get_line_payment_term(p_qte_header_id NUMBER, p_quote_line_id NUMBER) IS
4042: SELECT payment_term_id
4043: FROM aso_payments
4044: WHERE quote_header_id = p_qte_header_id
4045: and quote_line_id = p_quote_line_id;
4046:
4047: Cursor get_hdr_payment_term(p_qte_header_id NUMBER) IS

Line 4049: FROM aso_payments

4045: and quote_line_id = p_quote_line_id;
4046:
4047: Cursor get_hdr_payment_term(p_qte_header_id NUMBER) IS
4048: SELECT payment_term_id
4049: FROM aso_payments
4050: WHERE quote_header_id = p_qte_header_id
4051: and quote_line_id IS NULL ;
4052:
4053: Cursor get_line_qte_price( p_quote_line_id NUMBER) IS

Line 6632: SELECT payment_id, payment_option FROM ASO_PAYMENTS

6628: FROM ASO_QUOTE_HEADERS_ALL
6629: WHERE quote_number = X_qte_number;
6630:
6631: CURSOR c_payment_rec IS
6632: SELECT payment_id, payment_option FROM ASO_PAYMENTS
6633: WHERE quote_header_id = P_Qte_Header_Rec.quote_header_id
6634: AND quote_line_id IS NULL;
6635:
6636: CURSOR c_shipment_rec IS

Line 6843: FROM aso_payments

6839: and quote_line_id = p_quote_line_id;
6840:
6841: Cursor get_line_payment_term(p_qte_header_id NUMBER, p_quote_line_id NUMBER) IS
6842: SELECT payment_term_id
6843: FROM aso_payments
6844: WHERE quote_header_id = p_qte_header_id
6845: and quote_line_id = p_quote_line_id;
6846:
6847: Cursor get_hdr_payment_term(p_qte_header_id NUMBER) IS

Line 6849: FROM aso_payments

6845: and quote_line_id = p_quote_line_id;
6846:
6847: Cursor get_hdr_payment_term(p_qte_header_id NUMBER) IS
6848: SELECT payment_term_id
6849: FROM aso_payments
6850: WHERE quote_header_id = p_qte_header_id
6851: and quote_line_id IS NULL;
6852:
6853: CURSOR C_Get_Hdr_Resource_Id(lc_qte_header_id NUMBER) IS

Line 10687: DELETE FROM ASO_PAYMENTS

10683:
10684: --End of New code for Delete_Promotion 07/22/02
10685:
10686:
10687: DELETE FROM ASO_PAYMENTS
10688: WHERE QUOTE_HEADER_ID = p_qte_header_id;
10689:
10690: DELETE FROM ASO_FREIGHT_CHARGES
10691: WHERE quote_shipment_id in