APPS.PJM_BORROW_PAYBACK dependencies on PJM_BORROW_TRANSACTIONS

Line 65: -- into PJM_BORROW_TRANSACTIONS

61: -- Name : Trx_Callback
62: -- Pre-reqs : Non
63: -- Function : This function performs the following tasks:
64: -- 1) for a borrow transaction, it inserts a record
65: -- into PJM_BORROW_TRANSACTIONS
66: --
67: -- 2) for a payback transaction, it allocates the
68: -- payback quantity to borrow transactions and
69: -- insert the results in PJM_BORROW_PAYBACKS

Line 113: FROM pjm_borrow_transactions

109: , C_organization_id NUMBER
110: , C_proj_ctrl_level NUMBER ) IS
111: SELECT borrow_transaction_id
112: , outstanding_quantity
113: FROM pjm_borrow_transactions
114: WHERE decode(C_proj_ctrl_level, 1, borrow_project_id, borrow_task_id) =
115: decode(C_proj_ctrl_level, 1, C_borrow_proj_id, C_borrow_task_id)
116: AND decode(C_proj_ctrl_level, 1, lending_project_id, lending_task_id) =
117: decode(C_proj_ctrl_level, 1, C_lending_proj_id, C_lending_task_id)

Line 179: INSERT INTO pjm_borrow_transactions

175: INTO L_payback_date
176: FROM mtl_material_transactions_temp
177: WHERE transaction_temp_id = X_transaction_temp_id;
178:
179: INSERT INTO pjm_borrow_transactions
180: ( borrow_transaction_id
181: , creation_date
182: , created_by
183: , last_update_date

Line 229: FROM pjm_borrow_transactions

225: else
226:
227: SELECT sum(outstanding_quantity)
228: INTO L_outstanding_qty
229: FROM pjm_borrow_transactions
230: WHERE decode(L_proj_ctrl_level, 1, borrow_project_id, borrow_task_id) =
231: decode(L_proj_ctrl_level, 1, L_proj_id, L_task_id)
232: AND decode(L_proj_ctrl_level, 1, lending_project_id, lending_task_id) =
233: decode(L_proj_ctrl_level, 1, L_to_proj_id, L_to_task_id)

Line 299: UPDATE pjm_borrow_transactions

295: , decode(L_proj_ctrl_level, 2, to_task_id, NULL)
296: FROM mtl_material_transactions
297: WHERE transaction_id = X_transaction_id;
298:
299: UPDATE pjm_borrow_transactions
300: SET outstanding_quantity = outstanding_quantity - L_payback_qty
301: , last_update_date = sysdate
302: WHERE borrow_transaction_id = L_borrow_trx_id;
303:

Line 392: from pjm_borrow_transactions

388: C_Organization_Id NUMBER,
389: C_Inventory_Item_Id NUMBER,
390: C_Revision VARCHAR2) IS
391: select outstanding_quantity
392: from pjm_borrow_transactions
393: where decode(c_project_control_lev, 1, lending_project_id,
394: lending_task_id) =
395: decode(c_project_control_lev, 1, c_to_project_id, c_to_task_id)
396: and decode(c_project_control_lev, 1, borrow_project_id,

Line 679: from pjm_borrow_transactions

675:
676: BEGIN
677: select nvl(sum(outstanding_quantity),0)
678: into l_outstanding_qty
679: from pjm_borrow_transactions
680: where decode(l_project_control_lev, 1, lending_project_id,
681: lending_task_id) =
682: decode(l_project_control_lev, 1, l_to_project_id, l_to_task_id)
683: and decode(l_project_control_lev, 1, borrow_project_id,