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.GMI_TRANS_ENGINE_PVT dependencies on IC_LOCT_INV

Line 57: * a view created from the data in ic_loct_inv and ic_tran_pnd

53: * Modified create completed transaction to accept/process
54: * journal transactions doc types also.
55: * Jalaj Srivastava Bug 2519568
56: * Removed DML code for ic_summ_inv since, now ic_summ_inv is
57: * a view created from the data in ic_loct_inv and ic_tran_pnd
58: * Joe DiIorio Bug 2643440 11.5.1J
59: * Added nocopy.
60: * Joe DiIorio Bug 3090255 11.5.10L 08/15/2003
61: * Added field intorder_posted_ind.

Line 73: * the lot status and qc grade of the lot in ic_loct_inv

69: * Teresa Wong B3415691 6/7/2004
70: * Enhancement for Serono (Pls refer to B3599127)
71: * Modified update_pending_to_completed
72: * to ensure the completed transaction reflected
73: * the lot status and qc grade of the lot in ic_loct_inv
74: * at the time the transaction took place
75: *********************************************************************
76: */
77: /* Global variables */

Line 132: a view created from the data in ic_loct_inv and ic_tran_pnd

128:
129: /* ***********************************************************
130: Jalaj Srivastava Bug 2519568
131: Removed DML code for ic_summ_inv since, now ic_summ_inv is
132: a view created from the data in ic_loct_inv and ic_tran_pnd
133: *********************************************************** */
134:
135: PENDING_TRANSACTION_BUILD
136: ( p_tran_rec => l_tran_rec

Line 216: l_ic_loct_inv_row_in ic_loct_inv%ROWTYPE;

212: l_return_status VARCHAR2(1);
213: -- BEGIN Bug# 2341493 VRA Srinivas 26/04/2002
214: l_status_ctl NUMBER;
215: --END Bug# 2341493
216: l_ic_loct_inv_row_in ic_loct_inv%ROWTYPE;
217: l_ic_loct_inv_row_out ic_loct_inv%ROWTYPE;
218:
219: -- BEGIN Bug# 2341493 VRA Srinivas 26/04/2002
220: CURSOR Cur_status_ctl(pitem_id NUMBER) IS

Line 217: l_ic_loct_inv_row_out ic_loct_inv%ROWTYPE;

213: -- BEGIN Bug# 2341493 VRA Srinivas 26/04/2002
214: l_status_ctl NUMBER;
215: --END Bug# 2341493
216: l_ic_loct_inv_row_in ic_loct_inv%ROWTYPE;
217: l_ic_loct_inv_row_out ic_loct_inv%ROWTYPE;
218:
219: -- BEGIN Bug# 2341493 VRA Srinivas 26/04/2002
220: CURSOR Cur_status_ctl(pitem_id NUMBER) IS
221: SELECT

Line 279: GMI_LOCT_INV_PVT.UPDATING_IC_LOCT_INV

275: --Jalaj Srivastava Bug 2483644
276: --Now journal txns would also be posted using these APIs
277: IF ( (l_tran_rec.non_inv = 0) AND (substr(l_tran_rec.doc_type,1,3) <> 'GRD') )
278: THEN
279: GMI_LOCT_INV_PVT.UPDATING_IC_LOCT_INV
280: (
281: p_tran_rec => l_tran_rec,
282: x_return_status =>l_return_status
283: );

Line 298: a view created from the data in ic_loct_inv and ic_tran_pnd

294: /* Update Inventory Balances ( Actuals). */
295: /* ***********************************************************
296: Jalaj Srivastava Bug 2519568
297: Removed DML code for ic_summ_inv since, now ic_summ_inv is
298: a view created from the data in ic_loct_inv and ic_tran_pnd
299: *********************************************************** */
300:
301:
302: /* Jalaj Srivastava Bug 1427922 */

Line 600: a view created from the data in ic_loct_inv and ic_tran_pnd

596:
597: /* ***********************************************************
598: Jalaj Srivastava Bug 2519568
599: Removed DML code for ic_summ_inv since, now ic_summ_inv is
600: a view created from the data in ic_loct_inv and ic_tran_pnd
601: *********************************************************** */
602: END IF;
603:
604: /* Call Create_pending_transaction to build ic_tran_pnd%rowtype; */

Line 747: a view created from the data in ic_loct_inv and ic_tran_pnd

743:
744: /* ***********************************************************
745: Jalaj Srivastava Bug 2519568
746: Removed DML code for ic_summ_inv since, now ic_summ_inv is
747: a view created from the data in ic_loct_inv and ic_tran_pnd
748: *********************************************************** */
749:
750: ELSE
751: /* Update Previous Demand */

Line 854: ic_loct_inv

850: v_location IN VARCHAR2) IS
851: SELECT
852: lot_status
853: FROM
854: ic_loct_inv
855: WHERE
856: item_id = v_item_id
857: AND whse_code = v_whse
858: AND lot_id = v_lot_id

Line 865: ic_loct_inv i,

861: CURSOR Cur_qc_grade(v_lot_id IN NUMBER) IS
862: SELECT
863: DECODE(i.lot_id, 0, NULL, m.qc_grade)
864: FROM
865: ic_loct_inv i,
866: ic_lots_mst m
867: WHERE
868: m.lot_id = i.lot_id
869: AND i.lot_id = v_lot_id;

Line 927: a view created from the data in ic_loct_inv and ic_tran_pnd

923:
924: /* ***********************************************************
925: Jalaj Srivastava Bug 2519568
926: Removed DML code for ic_summ_inv since, now ic_summ_inv is
927: a view created from the data in ic_loct_inv and ic_tran_pnd
928: *********************************************************** */
929:
930: GMI_LOCT_INV_PVT.UPDATING_IC_LOCT_INV
931: (

Line 930: GMI_LOCT_INV_PVT.UPDATING_IC_LOCT_INV

926: Removed DML code for ic_summ_inv since, now ic_summ_inv is
927: a view created from the data in ic_loct_inv and ic_tran_pnd
928: *********************************************************** */
929:
930: GMI_LOCT_INV_PVT.UPDATING_IC_LOCT_INV
931: (
932: p_tran_rec => l_tran_rec,
933: x_return_status =>l_return_status
934: );

Line 949: the lot status and qc grade of the lot in ic_loct_inv

945: END IF;
946:
947: /* TKW B3415691 - Enhancement for Serono (Pls refer to B3599127) */
948: /* Added code to ensure the completed transaction reflected
949: the lot status and qc grade of the lot in ic_loct_inv
950: at the time the transaction took place */
951: l_item_mst_rec.item_id := l_tran_rec.item_id;
952: IF NOT gmivdbl.ic_item_mst_select (
953: p_ic_item_mst_row => l_item_mst_rec,