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_WF_LOT_RETEST dependencies on IC_LOTS_MST

Line 5: /* called via trigger on ic_lots_mst */

1: PACKAGE BODY gmi_wf_lot_retest AS
2: /* $Header: gmiltrtb.pls 115.4 2003/10/16 15:22:28 hsaleeb ship $ */
3:
4: PROCEDURE init_wf (
5: /* called via trigger on ic_lots_mst */
6: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
7: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
8: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
9: p_retest_date IN ic_lots_mst.retest_date%TYPE ,

Line 6: p_lot_id IN ic_lots_mst.lot_id%TYPE ,

2: /* $Header: gmiltrtb.pls 115.4 2003/10/16 15:22:28 hsaleeb ship $ */
3:
4: PROCEDURE init_wf (
5: /* called via trigger on ic_lots_mst */
6: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
7: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
8: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
9: p_retest_date IN ic_lots_mst.retest_date%TYPE ,
10: p_item_id IN ic_lots_mst.item_id%TYPE ,

Line 7: p_lot_no IN ic_lots_mst.lot_no%TYPE ,

3:
4: PROCEDURE init_wf (
5: /* called via trigger on ic_lots_mst */
6: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
7: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
8: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
9: p_retest_date IN ic_lots_mst.retest_date%TYPE ,
10: p_item_id IN ic_lots_mst.item_id%TYPE ,
11: p_created_by IN ic_lots_mst.created_by%TYPE

Line 8: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,

4: PROCEDURE init_wf (
5: /* called via trigger on ic_lots_mst */
6: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
7: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
8: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
9: p_retest_date IN ic_lots_mst.retest_date%TYPE ,
10: p_item_id IN ic_lots_mst.item_id%TYPE ,
11: p_created_by IN ic_lots_mst.created_by%TYPE
12: )

Line 9: p_retest_date IN ic_lots_mst.retest_date%TYPE ,

5: /* called via trigger on ic_lots_mst */
6: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
7: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
8: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
9: p_retest_date IN ic_lots_mst.retest_date%TYPE ,
10: p_item_id IN ic_lots_mst.item_id%TYPE ,
11: p_created_by IN ic_lots_mst.created_by%TYPE
12: )
13:

Line 10: p_item_id IN ic_lots_mst.item_id%TYPE ,

6: p_lot_id IN ic_lots_mst.lot_id%TYPE ,
7: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
8: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
9: p_retest_date IN ic_lots_mst.retest_date%TYPE ,
10: p_item_id IN ic_lots_mst.item_id%TYPE ,
11: p_created_by IN ic_lots_mst.created_by%TYPE
12: )
13:
14: IS

Line 11: p_created_by IN ic_lots_mst.created_by%TYPE

7: p_lot_no IN ic_lots_mst.lot_no%TYPE ,
8: p_sublot_no IN ic_lots_mst.sublot_no%TYPE ,
9: p_retest_date IN ic_lots_mst.retest_date%TYPE ,
10: p_item_id IN ic_lots_mst.item_id%TYPE ,
11: p_created_by IN ic_lots_mst.created_by%TYPE
12: )
13:
14: IS
15: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMWLOTEX';

Line 311: l_lot_id ic_lots_mst.lot_id%TYPE := TO_NUMBER(LTRIM(p_itemkey,'RT')) ;

307: l_count_lots_mst NUMBER := 0;
308: l_sum_loct_onhand ic_loct_inv.loct_onhand%TYPE := 0 ;
309: l_sum_loct_onhand2 ic_loct_inv.loct_onhand2%TYPE := 0 ;
310:
311: l_lot_id ic_lots_mst.lot_id%TYPE := TO_NUMBER(LTRIM(p_itemkey,'RT')) ;
312: l_lot_no ic_lots_mst.lot_no%TYPE ;
313: l_sublot_no ic_lots_mst.sublot_no%TYPE ;
314:
315: l_sqlcode NUMBER;

Line 312: l_lot_no ic_lots_mst.lot_no%TYPE ;

308: l_sum_loct_onhand ic_loct_inv.loct_onhand%TYPE := 0 ;
309: l_sum_loct_onhand2 ic_loct_inv.loct_onhand2%TYPE := 0 ;
310:
311: l_lot_id ic_lots_mst.lot_id%TYPE := TO_NUMBER(LTRIM(p_itemkey,'RT')) ;
312: l_lot_no ic_lots_mst.lot_no%TYPE ;
313: l_sublot_no ic_lots_mst.sublot_no%TYPE ;
314:
315: l_sqlcode NUMBER;
316: l_sqlerrm VARCHAR2(512);

Line 313: l_sublot_no ic_lots_mst.sublot_no%TYPE ;

309: l_sum_loct_onhand2 ic_loct_inv.loct_onhand2%TYPE := 0 ;
310:
311: l_lot_id ic_lots_mst.lot_id%TYPE := TO_NUMBER(LTRIM(p_itemkey,'RT')) ;
312: l_lot_no ic_lots_mst.lot_no%TYPE ;
313: l_sublot_no ic_lots_mst.sublot_no%TYPE ;
314:
315: l_sqlcode NUMBER;
316: l_sqlerrm VARCHAR2(512);
317: l_errname VARCHAR2(30);

Line 329: FROM ic_lots_mst

325: IF (p_funcmode = 'RUN') THEN
326:
327: SELECT COUNT(*)
328: INTO l_count_lots_mst
329: FROM ic_lots_mst
330: WHERE lot_id = l_lot_id
331: AND delete_mark = 0 ;
332:
333: IF (l_count_lots_mst <> 1) THEN