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.

APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_PAYMENTS

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

997: l_payment_rec := p_payment_tbl(i);
998: l_payment_rec.payment_term_id_from := p_payment_tbl(i).payment_term_id;
999:
1000: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1001: 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');
1002: 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');
1003: END IF;
1004:
1005: -- BC4J Fix

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

998: l_payment_rec.payment_term_id_from := p_payment_tbl(i).payment_term_id;
999:
1000: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1001: 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');
1002: 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');
1003: END IF;
1004:
1005: -- BC4J Fix
1006: --x_payment_tbl(i).payment_id := null;

Line 1666: FROM ASO_PAYMENTS

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

Line 1682: from aso_payments

1678: where quote_header_id = p_qte_header_rec.quote_header_id;
1679:
1680: cursor get_payment_type_code( l_payment_id Number) is
1681: select payment_type_code
1682: from aso_payments
1683: where payment_id = l_payment_id;
1684:
1685: cursor get_bill_to_party( l_qte_hdr_id Number) is
1686: select invoice_to_cust_party_id

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

2220: l_payment_rec := p_payment_tbl(i);
2221: l_payment_rec.PAYMENT_TERM_ID_FROM := p_payment_tbl(i).payment_term_id;
2222:
2223: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2224: 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');
2225: 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');
2226: END IF;
2227: -- BC4J Fix
2228: --x_payment_tbl(i).PAYMENT_ID := NULL;

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

2221: l_payment_rec.PAYMENT_TERM_ID_FROM := p_payment_tbl(i).payment_term_id;
2222:
2223: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2224: 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');
2225: 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');
2226: END IF;
2227: -- BC4J Fix
2228: --x_payment_tbl(i).PAYMENT_ID := NULL;
2229: x_payment_tbl(i).LAST_UPDATE_DATE := l_sysdate;

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

2283:
2284: END IF;
2285:
2286: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2287: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Update Rows l_payment_rec.payment_term_id'||l_payment_rec.payment_term_id, 1, 'Y');
2288: 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');
2289: END IF;
2290:
2291: x_payment_tbl(i).last_update_date := l_sysdate;

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

2284: END IF;
2285:
2286: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2287: aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Update Rows l_payment_rec.payment_term_id'||l_payment_rec.payment_term_id, 1, 'Y');
2288: 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');
2289: END IF;
2290:
2291: x_payment_tbl(i).last_update_date := l_sysdate;
2292: x_payment_tbl(i).payment_term_id_from := l_payment_rec.payment_term_id_from;

Line 3558: FROM aso_payments

3554:
3555:
3556: Cursor get_hdr_payment_term IS
3557: SELECT payment_term_id
3558: FROM aso_payments
3559: WHERE quote_header_id = p_qte_header_id
3560: and quote_line_id is null;
3561:
3562: Cursor get_hdr_curr_code IS

Line 3574: from aso_payments

3570: where quote_header_id = p_qte_header_id;
3571:
3572: Cursor get_total_payment_amount( l_qte_hdr_id number) is
3573: select sum(payment_amount)
3574: from aso_payments
3575: where quote_header_id = l_qte_hdr_id
3576: and quote_line_id is not null;
3577:
3578: l_total_list_price NUMBER := 0;

Line 4126: FROM aso_payments

4122: and quote_line_id = p_quote_line_id;
4123:
4124: Cursor get_line_payment_term(p_qte_header_id NUMBER, p_quote_line_id NUMBER) IS
4125: SELECT payment_term_id
4126: FROM aso_payments
4127: WHERE quote_header_id = p_qte_header_id
4128: and quote_line_id = p_quote_line_id;
4129:
4130: Cursor get_hdr_payment_term(p_qte_header_id NUMBER) IS

Line 4132: FROM aso_payments

4128: and quote_line_id = p_quote_line_id;
4129:
4130: Cursor get_hdr_payment_term(p_qte_header_id NUMBER) IS
4131: SELECT payment_term_id
4132: FROM aso_payments
4133: WHERE quote_header_id = p_qte_header_id
4134: and quote_line_id IS NULL ;
4135:
4136: Cursor get_line_qte_price( p_quote_line_id NUMBER) IS

Line 6771: SELECT payment_id, payment_option FROM ASO_PAYMENTS

6767: FROM ASO_QUOTE_HEADERS_ALL
6768: WHERE quote_number = X_qte_number;
6769:
6770: CURSOR c_payment_rec IS
6771: SELECT payment_id, payment_option FROM ASO_PAYMENTS
6772: WHERE quote_header_id = P_Qte_Header_Rec.quote_header_id
6773: AND quote_line_id IS NULL;
6774:
6775: CURSOR c_shipment_rec IS

Line 6983: FROM aso_payments

6979: and quote_line_id = p_quote_line_id;
6980:
6981: Cursor get_line_payment_term(p_qte_header_id NUMBER, p_quote_line_id NUMBER) IS
6982: SELECT payment_term_id
6983: FROM aso_payments
6984: WHERE quote_header_id = p_qte_header_id
6985: and quote_line_id = p_quote_line_id;
6986:
6987: Cursor get_hdr_payment_term(p_qte_header_id NUMBER) IS

Line 6989: FROM aso_payments

6985: and quote_line_id = p_quote_line_id;
6986:
6987: Cursor get_hdr_payment_term(p_qte_header_id NUMBER) IS
6988: SELECT payment_term_id
6989: FROM aso_payments
6990: WHERE quote_header_id = p_qte_header_id
6991: and quote_line_id IS NULL;
6992:
6993: CURSOR C_Get_Hdr_Resource_Id(lc_qte_header_id NUMBER) IS

Line 11758: DELETE FROM ASO_PAYMENTS

11754:
11755: --End of New code for Delete_Promotion 07/22/02
11756:
11757:
11758: DELETE FROM ASO_PAYMENTS
11759: WHERE QUOTE_HEADER_ID = p_qte_header_id;
11760:
11761: DELETE FROM ASO_FREIGHT_CHARGES
11762: WHERE quote_shipment_id in