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_EXCISE_PROCESSING_PKG dependencies on FND_GLOBAL

Line 351: last_updated_by = fnd_global.user_id,

347: cenvat_claimed_amt = nvl(cenvat_claimed_amt, 0) + p_cenvat_claimed_amt,
348: other_cenvat_claimed_amt = nvl(other_cenvat_claimed_amt,0) + p_other_cenvat_claimed_amt,
349: quantity_for_2nd_claim = nvl(quantity_for_2nd_claim,0) + nvl(ln_trx_qty_for_2nd_claim, 0),
350: last_update_date = sysdate,
351: last_updated_by = fnd_global.user_id,
352: last_update_login = fnd_global.login_id
353: WHERE transaction_id = p_transaction_id;
354:
355: -- this is to set the flag that is shown in JAINPORE, which signifies that the cenvat is claimed or not

Line 352: last_update_login = fnd_global.login_id

348: other_cenvat_claimed_amt = nvl(other_cenvat_claimed_amt,0) + p_other_cenvat_claimed_amt,
349: quantity_for_2nd_claim = nvl(quantity_for_2nd_claim,0) + nvl(ln_trx_qty_for_2nd_claim, 0),
350: last_update_date = sysdate,
351: last_updated_by = fnd_global.user_id,
352: last_update_login = fnd_global.login_id
353: WHERE transaction_id = p_transaction_id;
354:
355: -- this is to set the flag that is shown in JAINPORE, which signifies that the cenvat is claimed or not
356: update JAI_RCV_LINES

Line 359: last_updated_by = fnd_global.user_id,

355: -- this is to set the flag that is shown in JAINPORE, which signifies that the cenvat is claimed or not
356: update JAI_RCV_LINES
357: set claim_modvat_flag = 'Y',
358: last_update_date = sysdate,
359: last_updated_by = fnd_global.user_id,
360: last_update_login = fnd_global.login_id
361: where transaction_id = p_transaction_id;
362:
363: ELSE

Line 360: last_update_login = fnd_global.login_id

356: update JAI_RCV_LINES
357: set claim_modvat_flag = 'Y',
358: last_update_date = sysdate,
359: last_updated_by = fnd_global.user_id,
360: last_update_login = fnd_global.login_id
361: where transaction_id = p_transaction_id;
362:
363: ELSE
364:

Line 368: last_updated_by = fnd_global.user_id,

364:
365: UPDATE JAI_RCV_CENVAT_CLAIMS
366: SET quantity_for_2nd_claim = nvl(quantity_for_2nd_claim,0) + ln_trx_qty_for_2nd_claim,
367: last_update_date = sysdate,
368: last_updated_by = fnd_global.user_id,
369: last_update_login = fnd_global.login_id
370: WHERE transaction_id = r_trx.tax_transaction_id;
371:
372: END IF;

Line 369: last_update_login = fnd_global.login_id

365: UPDATE JAI_RCV_CENVAT_CLAIMS
366: SET quantity_for_2nd_claim = nvl(quantity_for_2nd_claim,0) + ln_trx_qty_for_2nd_claim,
367: last_update_date = sysdate,
368: last_updated_by = fnd_global.user_id,
369: last_update_login = fnd_global.login_id
370: WHERE transaction_id = r_trx.tax_transaction_id;
371:
372: END IF;
373: /* End, Vijay Shankar for Bug#3940588 */

Line 391: last_updated_by = fnd_global.user_id,

387: UPDATE JAI_RCV_CENVAT_CLAIMS
388: SET cenvat_amt_for_2nd_claim = ROUND((NVL(cenvat_amount,0))-(NVL(cenvat_claimed_amt,0)),v_excise_rf),
389: other_cenvat_amt_for_2nd_claim = ROUND((NVL(other_cenvat_amt,0))-(NVL(other_cenvat_claimed_amt,0)),v_excise_edu_cess_rf) ,
390: last_update_date = sysdate,
391: last_updated_by = fnd_global.user_id,
392: last_update_login = fnd_global.login_id
393: WHERE transaction_id = r_trx.tax_transaction_id;
394: ELSE
395:

Line 392: last_update_login = fnd_global.login_id

388: SET cenvat_amt_for_2nd_claim = ROUND((NVL(cenvat_amount,0))-(NVL(cenvat_claimed_amt,0)),v_excise_rf),
389: other_cenvat_amt_for_2nd_claim = ROUND((NVL(other_cenvat_amt,0))-(NVL(other_cenvat_claimed_amt,0)),v_excise_edu_cess_rf) ,
390: last_update_date = sysdate,
391: last_updated_by = fnd_global.user_id,
392: last_update_login = fnd_global.login_id
393: WHERE transaction_id = r_trx.tax_transaction_id;
394: ELSE
395:
396: ln_trx_equivalent_of_receive := jai_rcv_trx_processing_pkg .get_equivalent_qty_of_receive(r_trx.tax_transaction_id);

Line 411: last_updated_by = fnd_global.user_id,

407: UPDATE JAI_RCV_CENVAT_CLAIMS
408: SET cenvat_amt_for_2nd_claim = ROUND(nvl(v_changed_cenvat_quantity, 0) *nvl(cenvat_amount, 0) / nvl(ln_trx_equivalent_of_receive, 0), v_excise_rf) -cenvat_claimed_amt,
409: other_cenvat_amt_for_2nd_claim = ROUND(nvl(v_changed_cenvat_quantity, 0) *nvl(other_cenvat_amt, 0) / nvl(ln_trx_equivalent_of_receive, 0), v_excise_edu_cess_rf) -other_cenvat_claimed_amt,
410: last_update_date = sysdate,
411: last_updated_by = fnd_global.user_id,
412: last_update_login = fnd_global.login_id
413: WHERE transaction_id = r_trx.tax_transaction_id;
414:
415: END IF;

Line 412: last_update_login = fnd_global.login_id

408: SET cenvat_amt_for_2nd_claim = ROUND(nvl(v_changed_cenvat_quantity, 0) *nvl(cenvat_amount, 0) / nvl(ln_trx_equivalent_of_receive, 0), v_excise_rf) -cenvat_claimed_amt,
409: other_cenvat_amt_for_2nd_claim = ROUND(nvl(v_changed_cenvat_quantity, 0) *nvl(other_cenvat_amt, 0) / nvl(ln_trx_equivalent_of_receive, 0), v_excise_edu_cess_rf) -other_cenvat_claimed_amt,
410: last_update_date = sysdate,
411: last_updated_by = fnd_global.user_id,
412: last_update_login = fnd_global.login_id
413: WHERE transaction_id = r_trx.tax_transaction_id;
414:
415: END IF;
416: --end additions for bug#4750798

Line 1426: SYSDATE, FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, FND_GLOBAL.login_id

1422: creation_date, created_by, last_update_date, last_updated_by, last_update_login
1423: ) VALUES (
1424: p_transaction_id, r_trx.parent_transaction_id, r_trx.shipment_line_id,
1425: lv_excise_invoice_no, ld_excise_invoice_date, NULL,
1426: SYSDATE, FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, FND_GLOBAL.login_id
1427: );
1428:
1429: lv_statement_id := '7';
1430: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath);

Line 1644: last_updated_by = fnd_global.user_id

1640: + nvl(r_half_tax.sh_cvd_edu_cess,0)),
1641: /*added nvl(r_half_tax.sh_exc_edu_cess,0) + nvl(r_half_tax.sh_cvd_edu_cess,0) by vkaranam for budget 07 impact - bug#5989740*/
1642: cenvat_sequence = cenvat_sequence + 1,
1643: last_update_date = sysdate,
1644: last_updated_by = fnd_global.user_id
1645: WHERE transaction_id = ln_receive_trx_id;
1646: -- CHK whether the above update is required or not. because there is another update at the end of procedure
1647:
1648: END IF;

Line 2230: p_created_by => fnd_global.user_id,

2226: p_vendor_site_id => ln_vendor_site_id,
2227: p_customer_id => ln_customer_id,
2228: p_customer_site_id => ln_customer_site_id,
2229: p_creation_date => SYSDATE,
2230: p_created_by => fnd_global.user_id,
2231: p_last_update_date => SYSDATE,
2232: p_last_updated_by => fnd_global.user_id,
2233: p_last_update_login => fnd_global.login_id,
2234: p_called_from => 'RECEIPTS',

Line 2232: p_last_updated_by => fnd_global.user_id,

2228: p_customer_site_id => ln_customer_site_id,
2229: p_creation_date => SYSDATE,
2230: p_created_by => fnd_global.user_id,
2231: p_last_update_date => SYSDATE,
2232: p_last_updated_by => fnd_global.user_id,
2233: p_last_update_login => fnd_global.login_id,
2234: p_called_from => 'RECEIPTS',
2235: p_cess_amount => ln_exc_edu_cess ,/*added by vkaranam for budget 07 impact - bug#5989740*/
2236: p_sh_cess_amount => ln_sh_exc_edu_cess --added by vkaranam for budget 07 impact - bug#5989740

Line 2233: p_last_update_login => fnd_global.login_id,

2229: p_creation_date => SYSDATE,
2230: p_created_by => fnd_global.user_id,
2231: p_last_update_date => SYSDATE,
2232: p_last_updated_by => fnd_global.user_id,
2233: p_last_update_login => fnd_global.login_id,
2234: p_called_from => 'RECEIPTS',
2235: p_cess_amount => ln_exc_edu_cess ,/*added by vkaranam for budget 07 impact - bug#5989740*/
2236: p_sh_cess_amount => ln_sh_exc_edu_cess --added by vkaranam for budget 07 impact - bug#5989740
2237: );

Line 2244: last_updated_by = fnd_global.user_id,

2240: /*bgowrava for forward porting Bug#5756676..start*/
2241:
2242: UPDATE JAI_RCV_TRANSACTIONS
2243: SET quantity_register_flag = 'Y',
2244: last_updated_by = fnd_global.user_id,
2245: last_update_date = sysdate,
2246: last_update_login = fnd_global.login_id
2247: WHERE transaction_id = p_transaction_id ;
2248:

Line 2246: last_update_login = fnd_global.login_id

2242: UPDATE JAI_RCV_TRANSACTIONS
2243: SET quantity_register_flag = 'Y',
2244: last_updated_by = fnd_global.user_id,
2245: last_update_date = sysdate,
2246: last_update_login = fnd_global.login_id
2247: WHERE transaction_id = p_transaction_id ;
2248:
2249: FND_FILE.put_line(FND_FILE.log, 'Updating quantity register flag to Y');
2250:

Line 2489: last_updated_by = fnd_global.user_id,

2485: /*bgowrava for forward porting Bug#5756676..start*/
2486:
2487: UPDATE JAI_RCV_TRANSACTIONS
2488: SET quantity_register_flag = 'Y',
2489: last_updated_by = fnd_global.user_id,
2490: last_update_date = sysdate,
2491: last_update_login = fnd_global.login_id
2492: WHERE transaction_id = p_transaction_id ;
2493:

Line 2491: last_update_login = fnd_global.login_id

2487: UPDATE JAI_RCV_TRANSACTIONS
2488: SET quantity_register_flag = 'Y',
2489: last_updated_by = fnd_global.user_id,
2490: last_update_date = sysdate,
2491: last_update_login = fnd_global.login_id
2492: WHERE transaction_id = p_transaction_id ;
2493:
2494: FND_FILE.put_line(FND_FILE.log, 'Updating quantity register flag to Y');
2495:

Line 5587: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate

5583: created_by, creation_date, last_updated_by, last_update_date
5584: ) VALUES (
5585: JAI_CMN_RG_OTHERS_S.nextval, ln_source_type, p_source_register,
5586: p_source_register_id, p_tax_type, p_credit, p_debit,
5587: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate
5588: );
5589: EXCEPTION
5590: WHEN OTHERS THEN
5591: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');