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 103: FROM JAI_CMN_LINES lines,

99: -- rtxns.CURRENCY_CONVERSION_TYPE, /*rchandan for 5961325*/
100: -- rtxns.CURRENCY_CONVERSION_RATE, /*rchandan for 5961325*/
101: -- rtxns.CURRENCY_CONVERSION_DATE, /*rchandan for 5961325*/
102: poll.org_id /*rchandan for 5961325*/
103: FROM JAI_CMN_LINES lines,
104: RCV_TRANSACTIONS_INTERFACE rtxns,
105: po_line_locations_all poll
106: WHERE lines.interface_transaction_id =
107: rtxns.interface_transaction_id

Line 605: UPDATE jai_cmn_lines

601: errbuf OUT NOCOPY VARCHAR2,
602: retcode OUT NOCOPY VARCHAR2
603: ) IS
604: BEGIN
605: UPDATE jai_cmn_lines
606: SET excise_inv_number = p_ex_inv_num, excise_inv_date = p_ex_inv_date
607: WHERE shipment_number = p_shipment_num;
608:
609: errbuf := NULL;

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

907: lv_ship_num := r_hdrs.shipment_num;
908:
909: FOR r_txns IN c_txns_interface(p_hdr_intf_id)
910: LOOP
911: /*ln_cmn_line_id := JAI_CMN_LINES_S.nextval;*/
912: SELECT JAI_CMN_LINES_S.NEXTVAL INTO ln_cmn_line_id FROM DUAL;
913:
914: OPEN c_po_line_loc_details(r_txns.po_line_location_id);
915: FETCH c_po_line_loc_details

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

908:
909: FOR r_txns IN c_txns_interface(p_hdr_intf_id)
910: LOOP
911: /*ln_cmn_line_id := JAI_CMN_LINES_S.nextval;*/
912: SELECT JAI_CMN_LINES_S.NEXTVAL INTO ln_cmn_line_id FROM DUAL;
913:
914: OPEN c_po_line_loc_details(r_txns.po_line_location_id);
915: FETCH c_po_line_loc_details
916: INTO r_line_locations;

Line 919: INSERT INTO JAI_CMN_LINES

915: FETCH c_po_line_loc_details
916: INTO r_line_locations;
917: CLOSE c_po_line_loc_details;
918:
919: INSERT INTO JAI_CMN_LINES
920: (CMN_LINE_ID,
921: SHIPMENT_NUMBER,
922: PO_HEADER_ID,
923: PO_LINE_ID,

Line 1140: FROM JAI_CMN_LINES

1136: SELECT PHA.rate, PHA.currency_code
1137: FROM PO_HEADERS_ALL PHA
1138: WHERE PHA.PO_HEADER_ID =
1139: (SELECT PO_HEADER_ID
1140: FROM JAI_CMN_LINES
1141: WHERE CMN_LINE_ID = cp_cmn_line_id);
1142:
1143: ln_Tax_amt NUMBER;
1144: lv_curr_tax_amt NUMBER;

Line 2292: FROM jai_cmn_lines

2288: , pha.currency_code
2289: FROM po_headers_all pha
2290: WHERE pha.po_header_id =
2291: (SELECT po_header_id
2292: FROM jai_cmn_lines
2293: WHERE cmn_line_id = cp_cmn_line_id);
2294:
2295:
2296: ln_tax_amt NUMBER;