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:
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,
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),
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),
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:
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;
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:
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;
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;
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:
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;
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:
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;
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: