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 264: last_updated_by = fnd_global.user_id,

260: cenvat_claimed_amt = nvl(cenvat_claimed_amt, 0) + p_cenvat_claimed_amt,
261: other_cenvat_claimed_amt = nvl(other_cenvat_claimed_amt,0) + p_other_cenvat_claimed_amt,
262: quantity_for_2nd_claim = nvl(quantity_for_2nd_claim,0) + nvl(ln_trx_qty_for_2nd_claim, 0),
263: last_update_date = sysdate,
264: last_updated_by = fnd_global.user_id,
265: last_update_login = fnd_global.login_id
266: WHERE transaction_id = p_transaction_id;
267:
268: -- this is to set the flag that is shown in JAINPORE, which signifies that the cenvat is claimed or not

Line 265: last_update_login = fnd_global.login_id

261: other_cenvat_claimed_amt = nvl(other_cenvat_claimed_amt,0) + p_other_cenvat_claimed_amt,
262: quantity_for_2nd_claim = nvl(quantity_for_2nd_claim,0) + nvl(ln_trx_qty_for_2nd_claim, 0),
263: last_update_date = sysdate,
264: last_updated_by = fnd_global.user_id,
265: last_update_login = fnd_global.login_id
266: WHERE transaction_id = p_transaction_id;
267:
268: -- this is to set the flag that is shown in JAINPORE, which signifies that the cenvat is claimed or not
269: update JAI_RCV_LINES

Line 272: last_updated_by = fnd_global.user_id,

268: -- this is to set the flag that is shown in JAINPORE, which signifies that the cenvat is claimed or not
269: update JAI_RCV_LINES
270: set claim_modvat_flag = 'Y',
271: last_update_date = sysdate,
272: last_updated_by = fnd_global.user_id,
273: last_update_login = fnd_global.login_id
274: where transaction_id = p_transaction_id;
275:
276: ELSE

Line 273: last_update_login = fnd_global.login_id

269: update JAI_RCV_LINES
270: set claim_modvat_flag = 'Y',
271: last_update_date = sysdate,
272: last_updated_by = fnd_global.user_id,
273: last_update_login = fnd_global.login_id
274: where transaction_id = p_transaction_id;
275:
276: ELSE
277:

Line 281: last_updated_by = fnd_global.user_id,

277:
278: UPDATE JAI_RCV_CENVAT_CLAIMS
279: SET quantity_for_2nd_claim = nvl(quantity_for_2nd_claim,0) + ln_trx_qty_for_2nd_claim,
280: last_update_date = sysdate,
281: last_updated_by = fnd_global.user_id,
282: last_update_login = fnd_global.login_id
283: WHERE transaction_id = r_trx.tax_transaction_id;
284:
285: END IF;

Line 282: last_update_login = fnd_global.login_id

278: UPDATE JAI_RCV_CENVAT_CLAIMS
279: SET quantity_for_2nd_claim = nvl(quantity_for_2nd_claim,0) + ln_trx_qty_for_2nd_claim,
280: last_update_date = sysdate,
281: last_updated_by = fnd_global.user_id,
282: last_update_login = fnd_global.login_id
283: WHERE transaction_id = r_trx.tax_transaction_id;
284:
285: END IF;
286: /* End, Vijay Shankar for Bug#3940588 */

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

1263: creation_date, created_by, last_update_date, last_updated_by, last_update_login
1264: ) VALUES (
1265: p_transaction_id, r_trx.parent_transaction_id, r_trx.shipment_line_id,
1266: lv_excise_invoice_no, ld_excise_invoice_date, NULL,
1267: SYSDATE, FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, FND_GLOBAL.login_id
1268: );
1269:
1270: lv_statement_id := '7';
1271: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath);

Line 1485: last_updated_by = fnd_global.user_id

1481: + nvl(r_half_tax.sh_cvd_edu_cess,0)),
1482: /*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*/
1483: cenvat_sequence = cenvat_sequence + 1,
1484: last_update_date = sysdate,
1485: last_updated_by = fnd_global.user_id
1486: WHERE transaction_id = ln_receive_trx_id;
1487: -- CHK whether the above update is required or not. because there is another update at the end of procedure
1488:
1489: END IF;

Line 2021: p_created_by => fnd_global.user_id,

2017: p_vendor_site_id => ln_vendor_site_id,
2018: p_customer_id => ln_customer_id,
2019: p_customer_site_id => ln_customer_site_id,
2020: p_creation_date => SYSDATE,
2021: p_created_by => fnd_global.user_id,
2022: p_last_update_date => SYSDATE,
2023: p_last_updated_by => fnd_global.user_id,
2024: p_last_update_login => fnd_global.login_id,
2025: p_called_from => 'RECEIPTS',

Line 2023: p_last_updated_by => fnd_global.user_id,

2019: p_customer_site_id => ln_customer_site_id,
2020: p_creation_date => SYSDATE,
2021: p_created_by => fnd_global.user_id,
2022: p_last_update_date => SYSDATE,
2023: p_last_updated_by => fnd_global.user_id,
2024: p_last_update_login => fnd_global.login_id,
2025: p_called_from => 'RECEIPTS',
2026: p_cess_amount => ln_exc_edu_cess ,/*added by vkaranam for budget 07 impact - bug#5989740*/
2027: p_sh_cess_amount => ln_sh_exc_edu_cess --added by vkaranam for budget 07 impact - bug#5989740

Line 2024: p_last_update_login => fnd_global.login_id,

2020: p_creation_date => SYSDATE,
2021: p_created_by => fnd_global.user_id,
2022: p_last_update_date => SYSDATE,
2023: p_last_updated_by => fnd_global.user_id,
2024: p_last_update_login => fnd_global.login_id,
2025: p_called_from => 'RECEIPTS',
2026: p_cess_amount => ln_exc_edu_cess ,/*added by vkaranam for budget 07 impact - bug#5989740*/
2027: p_sh_cess_amount => ln_sh_exc_edu_cess --added by vkaranam for budget 07 impact - bug#5989740
2028: );

Line 2035: last_updated_by = fnd_global.user_id,

2031: /*bgowrava for forward porting Bug#5756676..start*/
2032:
2033: UPDATE JAI_RCV_TRANSACTIONS
2034: SET quantity_register_flag = 'Y',
2035: last_updated_by = fnd_global.user_id,
2036: last_update_date = sysdate,
2037: last_update_login = fnd_global.login_id
2038: WHERE transaction_id = p_transaction_id ;
2039:

Line 2037: last_update_login = fnd_global.login_id

2033: UPDATE JAI_RCV_TRANSACTIONS
2034: SET quantity_register_flag = 'Y',
2035: last_updated_by = fnd_global.user_id,
2036: last_update_date = sysdate,
2037: last_update_login = fnd_global.login_id
2038: WHERE transaction_id = p_transaction_id ;
2039:
2040: FND_FILE.put_line(FND_FILE.log, 'Updating quantity register flag to Y');
2041:

Line 2255: last_updated_by = fnd_global.user_id,

2251: /*bgowrava for forward porting Bug#5756676..start*/
2252:
2253: UPDATE JAI_RCV_TRANSACTIONS
2254: SET quantity_register_flag = 'Y',
2255: last_updated_by = fnd_global.user_id,
2256: last_update_date = sysdate,
2257: last_update_login = fnd_global.login_id
2258: WHERE transaction_id = p_transaction_id ;
2259:

Line 2257: last_update_login = fnd_global.login_id

2253: UPDATE JAI_RCV_TRANSACTIONS
2254: SET quantity_register_flag = 'Y',
2255: last_updated_by = fnd_global.user_id,
2256: last_update_date = sysdate,
2257: last_update_login = fnd_global.login_id
2258: WHERE transaction_id = p_transaction_id ;
2259:
2260: FND_FILE.put_line(FND_FILE.log, 'Updating quantity register flag to Y');
2261:

Line 5054: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate

5050: created_by, creation_date, last_updated_by, last_update_date
5051: ) VALUES (
5052: JAI_CMN_RG_OTHERS_S.nextval, ln_source_type, p_source_register,
5053: p_source_register_id, p_tax_type, p_credit, p_debit,
5054: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate
5055: );
5056: EXCEPTION
5057: WHEN OTHERS THEN
5058: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');