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 1675: OR ( exists (select 1 from JAI_RCV_LINES b

1671: AND a.receipt_num IS NULL
1672: AND (p_shipment_header_id IS NULL OR a.shipment_header_id = p_shipment_header_id)
1673: AND
1674: ( ( p_called_from = 'JAINPORE' and p_shipment_header_id is null) -- added, Harshita for bug #4300708
1675: OR ( exists (select 1 from JAI_RCV_LINES b
1676: where a.shipment_line_id = b.shipment_line_id
1677: and tax_modified_flag='N') )
1678: )
1679: FOR UPDATE OF transaction_id

Line 1718: exists (select 1 from JAI_RCV_LINES b

1714: )
1715: -- Check to pickup only those lines in which taxes cannot be modified,
1716: and
1717: ( ( p_shipment_header_id is null and p_called_from = 'JAINPORE' ) OR -- added, Harshita for bug #4300708
1718: exists (select 1 from JAI_RCV_LINES b
1719: where b.shipment_line_id = a.shipment_line_id
1720: and b.tax_modified_flag='N')
1721: )
1722: -- 3927371 (generic finding) this should process only these transactions if only receipt number is specified.

Line 1804: FROM jai_rcv_lines b

1800: WHERE organization_id = p_organization_id
1801: AND a.shipment_header_id = p_shipment_header_id
1802: AND a.receipt_num IS NULL
1803: AND EXISTS (SELECT 1
1804: FROM jai_rcv_lines b
1805: WHERE a.shipment_line_id = b.shipment_line_id
1806: AND tax_modified_flag='N')
1807: AND ( --Added date parameters for bug # 13880102
1808: ( p_transaction_from IS NULL AND p_transaction_to IS NULL)

Line 2017: FROM jai_rcv_lines b

2013: OR (p_transaction_to IS NULL AND trunc(creation_date) >= p_transaction_from)
2014: OR (trunc(creation_date) BETWEEN p_transaction_from AND p_transaction_to)
2015: )
2016: AND EXISTS (SELECT 1
2017: FROM jai_rcv_lines b
2018: WHERE b.shipment_line_id = a.shipment_line_id
2019: AND b.tax_modified_flag='N')
2020: );
2021:

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

2185: jai_cmn_utils_pkg.print_log('tax_mod.log','In transaction processing p_called_from:'||p_called_from);
2186: FND_FILE.put_line( FND_FILE.log, 'p_called_from:'||p_called_from);
2187:
2188: IF p_called_from = 'JAINPORE' THEN
2189: FND_FILE.put_line( FND_FILE.log, '~~~~~ Updating JAI_RCV_LINES.tax_modified_flag to N ~~~~~');
2190:
2191: UPDATE JAI_RCV_LINES a
2192: SET tax_modified_flag = 'N',
2193: last_update_date = SYSDATE,

Line 2191: UPDATE JAI_RCV_LINES a

2187:
2188: IF p_called_from = 'JAINPORE' THEN
2189: FND_FILE.put_line( FND_FILE.log, '~~~~~ Updating JAI_RCV_LINES.tax_modified_flag to N ~~~~~');
2190:
2191: UPDATE JAI_RCV_LINES a
2192: SET tax_modified_flag = 'N',
2193: last_update_date = SYSDATE,
2194: last_update_login = fnd_global.login_id,
2195: last_updated_by = fnd_global.user_id

Line 2339: update JAI_RCV_LINES

2335: -- added, Harshita for bug #4300708
2336:
2337: IF ( p_called_from = 'JAINPORE' and p_shipment_header_id is null
2338: and trx.transaction_type IN ('RECEIVE', 'MATCH') ) THEN
2339: update JAI_RCV_LINES
2340: set tax_modified_flag = 'N'
2341: where receipt_num = trx.receipt_num ;
2342: END IF ;
2343:

Line 4073: FROM JAI_RCV_LINES

4069:
4070: CURSOR c_receipt_line_dtls(cp_shipment_line_id JAI_RCV_TRANSACTIONS.shipment_line_id%type) is
4071: SELECT excise_invoice_no, excise_invoice_date, online_claim_flag,
4072: claim_modvat_flag, nvl(rma_type, 'XXXX') rma_type, receipt_num --Added receipt_num for bug #16197556
4073: FROM JAI_RCV_LINES
4074: WHERE shipment_line_id = cp_shipment_line_id;
4075:
4076: 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*/
4077: SELECT count(1) total_cnt,

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

4369: lv_transaction_type := r_trx.transaction_type;
4370: END IF;
4371:
4372: lv_statement_id := '3';
4373: /* Fetch all the Information from JAI_RCV_LINES*/
4374: /*Shifted this code to the beginning of the procedure--vkavulur Bug#16197556 */
4375: /*OPEN c_receipt_line_dtls(r_trx.shipment_line_id);
4376: FETCH c_receipt_line_dtls into r_receipt_line;
4377: CLOSE c_receipt_line_dtls;*/

Line 5402: FROM JAI_RCV_LINES

5398: lv_object_name CONSTANT VARCHAR2(61) := 'jai_rcv_trx_processing_pkg.get_apportion_factor';
5399:
5400: CURSOR c_ja_in_receipt_lines_qty(cp_shipment_line_id IN NUMBER) IS
5401: SELECT qty_received, transaction_id
5402: FROM JAI_RCV_LINES
5403: WHERE shipment_line_id = cp_shipment_line_id;
5404:
5405: r_trx c_trx%ROWTYPE;
5406: r_tax_trx c_base_trx%ROWTYPE;

Line 5477: FROM JAI_RCV_LINES

5473: */
5474:
5475: CURSOR c_ja_in_receipt_lines_qty(cp_shipment_line_id IN NUMBER) IS
5476: SELECT qty_received, transaction_id
5477: FROM JAI_RCV_LINES
5478: WHERE shipment_line_id = cp_shipment_line_id;
5479:
5480: r_trx c_trx%ROWTYPE;
5481: r_tax_trx c_base_trx%ROWTYPE;