DBA Data[Home] [Help]

APPS.JAI_RCV_TRANSACTIONS_PKG dependencies on FND_GLOBAL

Line 96: lv_created_by := FND_GLOBAL.user_id;

92:
93: BEGIN
94:
95: lv_creation_date := SYSDATE;
96: lv_created_by := FND_GLOBAL.user_id;
97: lv_last_update_date := SYSDATE;
98: lv_last_updated_by := lv_created_by;
99: lv_last_update_login := FND_GLOBAL.login_id;
100:

Line 99: lv_last_update_login := FND_GLOBAL.login_id;

95: lv_creation_date := SYSDATE;
96: lv_created_by := FND_GLOBAL.user_id;
97: lv_last_update_date := SYSDATE;
98: lv_last_updated_by := lv_created_by;
99: lv_last_update_login := FND_GLOBAL.login_id;
100:
101: INSERT INTO JAI_RCV_TRANSACTIONS(
102: shipment_header_id, shipment_line_id, transaction_id, transaction_type, quantity, uom_code,
103: transaction_date, parent_transaction_id, parent_transaction_type, receipt_num, organization_id,

Line 188: lv_last_updated_by := FND_GLOBAL.user_id;

184:
185: BEGIN
186:
187: lv_last_update_date := SYSDATE;
188: lv_last_updated_by := FND_GLOBAL.user_id;
189: lv_last_update_login := FND_GLOBAL.login_id;
190:
191: UPDATE JAI_RCV_TRANSACTIONS SET
192: PARENT_TRANSACTION_TYPE = nvl(P_PARENT_TRANSACTION_TYPE, PARENT_TRANSACTION_TYPE),

Line 189: lv_last_update_login := FND_GLOBAL.login_id;

185: BEGIN
186:
187: lv_last_update_date := SYSDATE;
188: lv_last_updated_by := FND_GLOBAL.user_id;
189: lv_last_update_login := FND_GLOBAL.login_id;
190:
191: UPDATE JAI_RCV_TRANSACTIONS SET
192: PARENT_TRANSACTION_TYPE = nvl(P_PARENT_TRANSACTION_TYPE, PARENT_TRANSACTION_TYPE),
193: RECEIPT_NUM = nvl(P_RECEIPT_NUM, RECEIPT_NUM),

Line 263: last_updated_by = fnd_global.user_id,

259: process_date = nvl(p_process_date, process_date),
260: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
261: PROCESS_VAT_STATUS = nvl(p_process_vat_flag, PROCESS_VAT_STATUS),
262: process_vat_message = nvl(p_process_vat_message, process_vat_message),
263: last_updated_by = fnd_global.user_id,
264: last_update_login = fnd_global.login_id,
265: last_update_date = SYSDATE
266: WHERE transaction_id = p_transaction_id;
267:

Line 264: last_update_login = fnd_global.login_id,

260: /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
261: PROCESS_VAT_STATUS = nvl(p_process_vat_flag, PROCESS_VAT_STATUS),
262: process_vat_message = nvl(p_process_vat_message, process_vat_message),
263: last_updated_by = fnd_global.user_id,
264: last_update_login = fnd_global.login_id,
265: last_update_date = SYSDATE
266: WHERE transaction_id = p_transaction_id;
267:
268: END update_process_flags;

Line 280: last_updated_by = fnd_global.user_id,

276: BEGIN
277: UPDATE JAI_RCV_TRANSACTIONS
278: SET excise_invoice_no = p_excise_invoice_no,
279: excise_invoice_date = p_excise_invoice_date,
280: last_updated_by = fnd_global.user_id,
281: last_update_login = fnd_global.login_id,
282: last_update_date = SYSDATE
283: WHERE transaction_id = p_transaction_id;
284:

Line 281: last_update_login = fnd_global.login_id,

277: UPDATE JAI_RCV_TRANSACTIONS
278: SET excise_invoice_no = p_excise_invoice_no,
279: excise_invoice_date = p_excise_invoice_date,
280: last_updated_by = fnd_global.user_id,
281: last_update_login = fnd_global.login_id,
282: last_update_date = SYSDATE
283: WHERE transaction_id = p_transaction_id;
284:
285: END update_excise_invoice_no;

Line 316: LAST_UPDATED_BY = fnd_global.user_id,

312: ATTRIBUTE8 = nvl(P_ATTRIBUTE8, ATTRIBUTE8),
313: ATTRIBUTE9 = nvl(P_ATTRIBUTE9, ATTRIBUTE9),
314: ATTRIBUTE10 = nvl(P_ATTRIBUTE10, ATTRIBUTE10),
315: LAST_UPDATE_DATE = sysdate,
316: LAST_UPDATED_BY = fnd_global.user_id,
317: LAST_UPDATE_LOGIN = fnd_global.login_id
318: WHERE transaction_id = p_transaction_id;
319:
320: END update_attributes;

Line 317: LAST_UPDATE_LOGIN = fnd_global.login_id

313: ATTRIBUTE9 = nvl(P_ATTRIBUTE9, ATTRIBUTE9),
314: ATTRIBUTE10 = nvl(P_ATTRIBUTE10, ATTRIBUTE10),
315: LAST_UPDATE_DATE = sysdate,
316: LAST_UPDATED_BY = fnd_global.user_id,
317: LAST_UPDATE_LOGIN = fnd_global.login_id
318: WHERE transaction_id = p_transaction_id;
319:
320: END update_attributes;
321:

Line 368: LAST_UPDATED_BY = fnd_global.user_id,

364: VAT_INV_GEN_STATUS = nvl(P_VAT_INV_GEN_STATUS, VAT_INV_GEN_STATUS),
365: EXCISE_INV_GEN_NUMBER = nvl(P_EXCISE_INV_GEN_NUMBER, EXCISE_INV_GEN_NUMBER),
366: VAT_INV_GEN_NUMBER = nvl(P_VAT_INV_GEN_NUMBER, VAT_INV_GEN_NUMBER),
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 = p_transaction_id;
371:
372: END update_inv_stat_and_no;

Line 369: LAST_UPDATE_LOGIN = fnd_global.login_id

365: EXCISE_INV_GEN_NUMBER = nvl(P_EXCISE_INV_GEN_NUMBER, EXCISE_INV_GEN_NUMBER),
366: VAT_INV_GEN_NUMBER = nvl(P_VAT_INV_GEN_NUMBER, VAT_INV_GEN_NUMBER),
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 = p_transaction_id;
371:
372: END update_inv_stat_and_no;
373:

Line 408: LAST_UPDATED_BY = fnd_global.user_id,

404: BEGIN
405: UPDATE JAI_RCV_TRANSACTIONS SET
406: CENVAT_COSTED_FLAG = nvl(P_CENVAT_COSTED_FLAG, CENVAT_COSTED_FLAG),
407: LAST_UPDATE_DATE = sysdate,
408: LAST_UPDATED_BY = fnd_global.user_id,
409: LAST_UPDATE_LOGIN = fnd_global.login_id
410: WHERE transaction_id = p_transaction_id;
411:
412: END update_cenvat_costed_flag;

Line 409: LAST_UPDATE_LOGIN = fnd_global.login_id

405: UPDATE JAI_RCV_TRANSACTIONS SET
406: CENVAT_COSTED_FLAG = nvl(P_CENVAT_COSTED_FLAG, CENVAT_COSTED_FLAG),
407: LAST_UPDATE_DATE = sysdate,
408: LAST_UPDATED_BY = fnd_global.user_id,
409: LAST_UPDATE_LOGIN = fnd_global.login_id
410: WHERE transaction_id = p_transaction_id;
411:
412: END update_cenvat_costed_flag;
413: