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.

[Home] [Help]

APPS.JAI_RCV_TRANSACTIONS_PKG dependencies on FND_GLOBAL

Line 91: lv_created_by := FND_GLOBAL.user_id;

87:
88: BEGIN
89:
90: lv_creation_date := SYSDATE;
91: lv_created_by := FND_GLOBAL.user_id;
92: lv_last_update_date := SYSDATE;
93: lv_last_updated_by := lv_created_by;
94: lv_last_update_login := FND_GLOBAL.login_id;
95:

Line 94: lv_last_update_login := FND_GLOBAL.login_id;

90: lv_creation_date := SYSDATE;
91: lv_created_by := FND_GLOBAL.user_id;
92: lv_last_update_date := SYSDATE;
93: lv_last_updated_by := lv_created_by;
94: lv_last_update_login := FND_GLOBAL.login_id;
95:
96: INSERT INTO JAI_RCV_TRANSACTIONS(
97: shipment_header_id, shipment_line_id, transaction_id, transaction_type, quantity, uom_code,
98: transaction_date, parent_transaction_id, parent_transaction_type, receipt_num, organization_id,

Line 170: lv_last_updated_by := FND_GLOBAL.user_id;

166:
167: BEGIN
168:
169: lv_last_update_date := SYSDATE;
170: lv_last_updated_by := FND_GLOBAL.user_id;
171: lv_last_update_login := FND_GLOBAL.login_id;
172:
173: UPDATE JAI_RCV_TRANSACTIONS SET
174: PARENT_TRANSACTION_TYPE = nvl(P_PARENT_TRANSACTION_TYPE, PARENT_TRANSACTION_TYPE),

Line 171: lv_last_update_login := FND_GLOBAL.login_id;

167: BEGIN
168:
169: lv_last_update_date := SYSDATE;
170: lv_last_updated_by := FND_GLOBAL.user_id;
171: lv_last_update_login := FND_GLOBAL.login_id;
172:
173: UPDATE JAI_RCV_TRANSACTIONS SET
174: PARENT_TRANSACTION_TYPE = nvl(P_PARENT_TRANSACTION_TYPE, PARENT_TRANSACTION_TYPE),
175: RECEIPT_NUM = nvl(P_RECEIPT_NUM, RECEIPT_NUM),

Line 243: last_updated_by = fnd_global.user_id,

239: process_date = nvl(p_process_date, process_date),
240: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
241: PROCESS_VAT_STATUS = nvl(p_process_vat_flag, PROCESS_VAT_STATUS),
242: process_vat_message = nvl(p_process_vat_message, process_vat_message),
243: last_updated_by = fnd_global.user_id,
244: last_update_login = fnd_global.login_id,
245: last_update_date = SYSDATE
246: WHERE transaction_id = p_transaction_id;
247:

Line 244: last_update_login = fnd_global.login_id,

240: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
241: PROCESS_VAT_STATUS = nvl(p_process_vat_flag, PROCESS_VAT_STATUS),
242: process_vat_message = nvl(p_process_vat_message, process_vat_message),
243: last_updated_by = fnd_global.user_id,
244: last_update_login = fnd_global.login_id,
245: last_update_date = SYSDATE
246: WHERE transaction_id = p_transaction_id;
247:
248: END update_process_flags;

Line 260: last_updated_by = fnd_global.user_id,

256: BEGIN
257: UPDATE JAI_RCV_TRANSACTIONS
258: SET excise_invoice_no = p_excise_invoice_no,
259: excise_invoice_date = p_excise_invoice_date,
260: last_updated_by = fnd_global.user_id,
261: last_update_login = fnd_global.login_id,
262: last_update_date = SYSDATE
263: WHERE transaction_id = p_transaction_id;
264:

Line 261: last_update_login = fnd_global.login_id,

257: UPDATE JAI_RCV_TRANSACTIONS
258: SET excise_invoice_no = p_excise_invoice_no,
259: excise_invoice_date = p_excise_invoice_date,
260: last_updated_by = fnd_global.user_id,
261: last_update_login = fnd_global.login_id,
262: last_update_date = SYSDATE
263: WHERE transaction_id = p_transaction_id;
264:
265: END update_excise_invoice_no;

Line 296: LAST_UPDATED_BY = fnd_global.user_id,

292: ATTRIBUTE8 = nvl(P_ATTRIBUTE8, ATTRIBUTE8),
293: ATTRIBUTE9 = nvl(P_ATTRIBUTE9, ATTRIBUTE9),
294: ATTRIBUTE10 = nvl(P_ATTRIBUTE10, ATTRIBUTE10),
295: LAST_UPDATE_DATE = sysdate,
296: LAST_UPDATED_BY = fnd_global.user_id,
297: LAST_UPDATE_LOGIN = fnd_global.login_id
298: WHERE transaction_id = p_transaction_id;
299:
300: END update_attributes;

Line 297: LAST_UPDATE_LOGIN = fnd_global.login_id

293: ATTRIBUTE9 = nvl(P_ATTRIBUTE9, ATTRIBUTE9),
294: ATTRIBUTE10 = nvl(P_ATTRIBUTE10, ATTRIBUTE10),
295: LAST_UPDATE_DATE = sysdate,
296: LAST_UPDATED_BY = fnd_global.user_id,
297: LAST_UPDATE_LOGIN = fnd_global.login_id
298: WHERE transaction_id = p_transaction_id;
299:
300: END update_attributes;
301: