APPS.JAI_PO_HOOK_PKG dependencies on JAI_CMN_LINES

Line 15: excise_inv_num to excise_inv_number in jai_cmn_lines table

11: related fields.
12: Commented the call to ja_in_Calc_tax procedure and called ja_in_po_calc_tax procedure
13: 2 16-07-2007 iSupplier forward porting
14: Changed shipment_num to shipment_number
15: excise_inv_num to excise_inv_number in jai_cmn_lines table
16:
17: 3 20-09-2007 iProcurement 6066485
18: Commented the currency conversion for ln_assessable_value
19:

Line 30: Fix - Added UOM conversion logic while populating JAI_CMN_LINES table. The changes are

26: same shipment number in different orgs.
27:
28: 6 07-AUG-2009 Bug 8322323 File version 120.15.12010000.3 / 120.17
29: Issue - ASBN Tax Calculation goes wrong when UOM is changed during ASBN creation.
30: Fix - Added UOM conversion logic while populating JAI_CMN_LINES table. The changes are
31: done in procedure populate_cmn_lines
32:
33: 7 29-SEP-2009 Bug 8894051 File version 120.15.12010000.4 / 120.18
34: Issue - ASBN Tax calculation goes wrong if excise / vat assessable price is defined

Line 143: FROM JAI_CMN_LINES lines,

139: -- rtxns.CURRENCY_CONVERSION_TYPE, /*rchandan for 5961325*/
140: -- rtxns.CURRENCY_CONVERSION_RATE, /*rchandan for 5961325*/
141: -- rtxns.CURRENCY_CONVERSION_DATE, /*rchandan for 5961325*/
142: poll.org_id /*rchandan for 5961325*/
143: FROM JAI_CMN_LINES lines,
144: RCV_TRANSACTIONS_INTERFACE rtxns,
145: po_line_locations_all poll
146: WHERE lines.interface_transaction_id =
147: rtxns.interface_transaction_id

Line 695: UPDATE jai_cmn_lines

691: errbuf OUT NOCOPY VARCHAR2,
692: retcode OUT NOCOPY VARCHAR2
693: ) IS
694: BEGIN
695: UPDATE jai_cmn_lines
696: SET excise_inv_number = p_ex_inv_num, excise_inv_date = p_ex_inv_date
697: WHERE shipment_number = p_shipment_num
698: AND (p_header_interface_id IS NULL OR /*bug 8400813*/
699: (p_header_interface_id IS NOT NULL AND header_interface_id = p_header_interface_id));

Line 1014: /*ln_cmn_line_id := JAI_CMN_LINES_S.nextval;*/

1010: lv_ship_num := r_hdrs.shipment_num;
1011:
1012: FOR r_txns IN c_txns_interface(p_hdr_intf_id)
1013: LOOP
1014: /*ln_cmn_line_id := JAI_CMN_LINES_S.nextval;*/
1015: SELECT JAI_CMN_LINES_S.NEXTVAL INTO ln_cmn_line_id FROM DUAL;
1016:
1017: OPEN c_po_line_loc_details(r_txns.po_line_location_id);
1018: FETCH c_po_line_loc_details

Line 1015: SELECT JAI_CMN_LINES_S.NEXTVAL INTO ln_cmn_line_id FROM DUAL;

1011:
1012: FOR r_txns IN c_txns_interface(p_hdr_intf_id)
1013: LOOP
1014: /*ln_cmn_line_id := JAI_CMN_LINES_S.nextval;*/
1015: SELECT JAI_CMN_LINES_S.NEXTVAL INTO ln_cmn_line_id FROM DUAL;
1016:
1017: OPEN c_po_line_loc_details(r_txns.po_line_location_id);
1018: FETCH c_po_line_loc_details
1019: INTO r_line_locations;

Line 1035: INSERT INTO JAI_CMN_LINES

1031:
1032: ln_uom_conv_factor := inv_convert.inv_um_convert(r_txns.item_id, lv_po_uom, lv_asbn_uom);
1033: /*end bug 8322323*/
1034:
1035: INSERT INTO JAI_CMN_LINES
1036: (CMN_LINE_ID,
1037: SHIPMENT_NUMBER,
1038: PO_HEADER_ID,
1039: PO_LINE_ID,

Line 1269: FROM JAI_CMN_LINES

1265: SELECT PHA.rate, PHA.currency_code
1266: FROM PO_HEADERS_ALL PHA
1267: WHERE PHA.PO_HEADER_ID =
1268: (SELECT PO_HEADER_ID
1269: FROM JAI_CMN_LINES
1270: WHERE CMN_LINE_ID = cp_cmn_line_id);
1271:
1272: ln_Tax_amt NUMBER;
1273: lv_curr_tax_amt NUMBER;

Line 2494: FROM jai_cmn_lines

2490: , pha.currency_code
2491: FROM po_headers_all pha
2492: WHERE pha.po_header_id =
2493: (SELECT po_header_id
2494: FROM jai_cmn_lines
2495: WHERE cmn_line_id = cp_cmn_line_id);
2496:
2497:
2498: ln_tax_amt NUMBER;