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.JAI_RCV_TRX_PROCESSING_PKG dependencies on JAI_RCV_LINES

Line 77: - UPDATEs JAI_RCV_LINES with tax_modified_flag as 'N' so that taxes for that line cannot be modified anymore

73: - Increased the filtering condition for transactions processing by adding p_shipment_header_id and p_shipment_line_id
74: parameters to PROCESS_BATCH procedure
75: - Modified CURSORs c_trxns_to_populate_dtls and c_get_transactions of PROCESS_BATCH, to pickup only those transactions
76: where in users cannot modify the taxes anymore
77: - UPDATEs JAI_RCV_LINES with tax_modified_flag as 'N' so that taxes for that line cannot be modified anymore
78: when p_called_from is JAINPORE (Localization Receipts form)
79: - Calls to transaction_preprocessor and transaction_postprocessed are made to do processing required before and after
80: actual processing
81: - Changes in PROCESS_TRANSACTION procedure

Line 1321: OR ( exists (select 1 from JAI_RCV_LINES b

1317: AND a.receipt_num IS NULL
1318: AND (p_shipment_header_id IS NULL OR a.shipment_header_id = p_shipment_header_id)
1319: AND
1320: ( ( p_called_from = 'JAINPORE' and p_shipment_header_id is null) -- added, Harshita for bug #4300708
1321: OR ( exists (select 1 from JAI_RCV_LINES b
1322: where a.shipment_line_id = b.shipment_line_id
1323: and tax_modified_flag='N') )
1324: )
1325: FOR UPDATE OF transaction_id

Line 1364: exists (select 1 from JAI_RCV_LINES b

1360: )
1361: -- Check to pickup only those lines in which taxes cannot be modified,
1362: and
1363: ( ( p_shipment_header_id is null and p_called_from = 'JAINPORE' ) OR -- added, Harshita for bug #4300708
1364: exists (select 1 from JAI_RCV_LINES b
1365: where b.shipment_line_id = a.shipment_line_id
1366: and b.tax_modified_flag='N')
1367: )
1368: -- 3927371 (generic finding) this should process only these transactions if only receipt number is specified.

Line 1443: FROM jai_rcv_lines b

1439: WHERE organization_id = p_organization_id
1440: AND a.shipment_header_id = p_shipment_header_id
1441: AND a.receipt_num IS NULL
1442: AND EXISTS (SELECT 1
1443: FROM jai_rcv_lines b
1444: WHERE a.shipment_line_id = b.shipment_line_id
1445: AND tax_modified_flag='N')
1446: );
1447:

Line 1648: FROM jai_rcv_lines b

1644: OR (p_transaction_to IS NULL AND trunc(creation_date) >= p_transaction_from)
1645: OR (trunc(creation_date) BETWEEN p_transaction_from AND p_transaction_to)
1646: )
1647: AND EXISTS (SELECT 1
1648: FROM jai_rcv_lines b
1649: WHERE b.shipment_line_id = a.shipment_line_id
1650: AND b.tax_modified_flag='N')
1651: );
1652:

Line 1820: FND_FILE.put_line( FND_FILE.log, '~ Updating JAI_RCV_LINES.tax_modified_flag to N ~');

1816: jai_cmn_utils_pkg.print_log('tax_mod.log','In transaction processing p_called_from:'||p_called_from);
1817: FND_FILE.put_line( FND_FILE.log, 'p_called_from:'||p_called_from);
1818:
1819: IF p_called_from = 'JAINPORE' THEN
1820: FND_FILE.put_line( FND_FILE.log, '~~~~~ Updating JAI_RCV_LINES.tax_modified_flag to N ~~~~~');
1821:
1822: UPDATE JAI_RCV_LINES a
1823: SET tax_modified_flag = 'N',
1824: last_update_date = SYSDATE,

Line 1822: UPDATE JAI_RCV_LINES a

1818:
1819: IF p_called_from = 'JAINPORE' THEN
1820: FND_FILE.put_line( FND_FILE.log, '~~~~~ Updating JAI_RCV_LINES.tax_modified_flag to N ~~~~~');
1821:
1822: UPDATE JAI_RCV_LINES a
1823: SET tax_modified_flag = 'N',
1824: last_update_date = SYSDATE,
1825: last_update_login = fnd_global.login_id,
1826: last_updated_by = fnd_global.user_id

Line 1931: update JAI_RCV_LINES

1927: -- added, Harshita for bug #4300708
1928:
1929: IF ( p_called_from = 'JAINPORE' and p_shipment_header_id is null
1930: and trx.transaction_type IN ('RECEIVE', 'MATCH') ) THEN
1931: update JAI_RCV_LINES
1932: set tax_modified_flag = 'N'
1933: where receipt_num = trx.receipt_num ;
1934: END IF ;
1935:

Line 3585: FROM JAI_RCV_LINES

3581:
3582: CURSOR c_receipt_line_dtls(cp_shipment_line_id JAI_RCV_TRANSACTIONS.shipment_line_id%type) is
3583: SELECT excise_invoice_no, excise_invoice_date, online_claim_flag,
3584: claim_modvat_flag, nvl(rma_type, 'XXXX') rma_type
3585: FROM JAI_RCV_LINES
3586: WHERE shipment_line_id = cp_shipment_line_id;
3587:
3588: CURSOR c_taxes(cp_shipment_line_id JAI_RCV_TRANSACTIONS.shipment_line_id%type) is /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3589: SELECT count(1) total_cnt,

Line 3761: /* Fetch all the Information from JAI_RCV_LINES*/

3757: lv_transaction_type := r_trx.transaction_type;
3758: END IF;
3759:
3760: lv_statement_id := '3';
3761: /* Fetch all the Information from JAI_RCV_LINES*/
3762: OPEN c_receipt_line_dtls(r_trx.shipment_line_id);
3763: FETCH c_receipt_line_dtls into r_receipt_line;
3764: CLOSE c_receipt_line_dtls;
3765:

Line 4721: FROM JAI_RCV_LINES

4717: lv_object_name CONSTANT VARCHAR2(61) := 'jai_rcv_trx_processing_pkg.get_apportion_factor';
4718:
4719: CURSOR c_ja_in_receipt_lines_qty(cp_shipment_line_id IN NUMBER) IS
4720: SELECT qty_received, transaction_id
4721: FROM JAI_RCV_LINES
4722: WHERE shipment_line_id = cp_shipment_line_id;
4723:
4724: r_trx c_trx%ROWTYPE;
4725: r_tax_trx c_base_trx%ROWTYPE;

Line 4796: FROM JAI_RCV_LINES

4792: */
4793:
4794: CURSOR c_ja_in_receipt_lines_qty(cp_shipment_line_id IN NUMBER) IS
4795: SELECT qty_received, transaction_id
4796: FROM JAI_RCV_LINES
4797: WHERE shipment_line_id = cp_shipment_line_id;
4798:
4799: r_trx c_trx%ROWTYPE;
4800: r_tax_trx c_base_trx%ROWTYPE;