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

Line 2246: ( p_strength IN ic_lots_mst.strength%TYPE

2242: --| 11/13/1998 Mike Godfrey - Created |
2243: --| |
2244: --+==========================================================================+
2245: FUNCTION Validate_Strength
2246: ( p_strength IN ic_lots_mst.strength%TYPE
2247: )
2248: RETURN BOOLEAN
2249: IS
2250: BEGIN

Line 2285: ( p_origination_type IN ic_lots_mst.origination_type%TYPE

2281: --| 11/13/1998 Mike Godfrey - Created |
2282: --| |
2283: --+==========================================================================+
2284: FUNCTION Validate_origination_type
2285: ( p_origination_type IN ic_lots_mst.origination_type%TYPE
2286: )
2287: RETURN BOOLEAN
2288: IS
2289: l_origination_type ic_lots_mst.origination_type%TYPE;

Line 2289: l_origination_type ic_lots_mst.origination_type%TYPE;

2285: ( p_origination_type IN ic_lots_mst.origination_type%TYPE
2286: )
2287: RETURN BOOLEAN
2288: IS
2289: l_origination_type ic_lots_mst.origination_type%TYPE;
2290: CURSOR gem_lookups_c1 IS
2291: SELECT
2292: lookup_type
2293: FROM

Line 2346: l_shipvendor_id ic_lots_mst.shipvend_id%TYPE;

2342: )
2343: RETURN NUMBER
2344: IS
2345: l_shipvendor_no po_vend_mst.vendor_no%TYPE;
2346: l_shipvendor_id ic_lots_mst.shipvend_id%TYPE;
2347:
2348: CURSOR po_vend_mst_c1 IS
2349: SELECT
2350: vendor_no

Line 2409: , p_lot_no IN ic_lots_mst.lot_no%TYPE

2405: --| |
2406: --+==========================================================================+
2407: FUNCTION Validate_lot_No
2408: ( p_item_no IN ic_item_mst.item_no%TYPE
2409: , p_lot_no IN ic_lots_mst.lot_no%TYPE
2410: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
2411: )
2412: RETURN BOOLEAN
2413: IS

Line 2410: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE

2406: --+==========================================================================+
2407: FUNCTION Validate_lot_No
2408: ( p_item_no IN ic_item_mst.item_no%TYPE
2409: , p_lot_no IN ic_lots_mst.lot_no%TYPE
2410: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
2411: )
2412: RETURN BOOLEAN
2413: IS
2414: l_item_id ic_item_mst.item_id%TYPE;

Line 2416: l_lot_no ic_lots_mst.lot_no%TYPE;

2412: RETURN BOOLEAN
2413: IS
2414: l_item_id ic_item_mst.item_id%TYPE;
2415: l_item_no ic_item_mst.item_no%TYPE;
2416: l_lot_no ic_lots_mst.lot_no%TYPE;
2417: l_sublot_no ic_lots_mst.sublot_no%TYPE;
2418:
2419: CURSOR ic_lots_mst_c1 IS
2420: SELECT

Line 2417: l_sublot_no ic_lots_mst.sublot_no%TYPE;

2413: IS
2414: l_item_id ic_item_mst.item_id%TYPE;
2415: l_item_no ic_item_mst.item_no%TYPE;
2416: l_lot_no ic_lots_mst.lot_no%TYPE;
2417: l_sublot_no ic_lots_mst.sublot_no%TYPE;
2418:
2419: CURSOR ic_lots_mst_c1 IS
2420: SELECT
2421: a.item_no

Line 2419: CURSOR ic_lots_mst_c1 IS

2415: l_item_no ic_item_mst.item_no%TYPE;
2416: l_lot_no ic_lots_mst.lot_no%TYPE;
2417: l_sublot_no ic_lots_mst.sublot_no%TYPE;
2418:
2419: CURSOR ic_lots_mst_c1 IS
2420: SELECT
2421: a.item_no
2422: , a.item_id
2423: , b.lot_no

Line 2427: , ic_lots_mst b

2423: , b.lot_no
2424: , b.sublot_no
2425: FROM
2426: ic_item_mst a
2427: , ic_lots_mst b
2428: WHERE
2429: p_item_no = a.item_no
2430: AND a.item_id = b.item_id
2431: AND p_lot_no = b.lot_no

Line 2437: OPEN ic_lots_mst_c1;

2433: AND b.delete_mark = 0;
2434:
2435: BEGIN
2436:
2437: OPEN ic_lots_mst_c1;
2438: FETCH ic_lots_mst_c1 INTO l_item_no, l_item_id, l_lot_no, l_sublot_no;
2439: IF (ic_lots_mst_c1%NOTFOUND)
2440: THEN
2441: CLOSE ic_lots_mst_c1;

Line 2438: FETCH ic_lots_mst_c1 INTO l_item_no, l_item_id, l_lot_no, l_sublot_no;

2434:
2435: BEGIN
2436:
2437: OPEN ic_lots_mst_c1;
2438: FETCH ic_lots_mst_c1 INTO l_item_no, l_item_id, l_lot_no, l_sublot_no;
2439: IF (ic_lots_mst_c1%NOTFOUND)
2440: THEN
2441: CLOSE ic_lots_mst_c1;
2442: RETURN FALSE;

Line 2439: IF (ic_lots_mst_c1%NOTFOUND)

2435: BEGIN
2436:
2437: OPEN ic_lots_mst_c1;
2438: FETCH ic_lots_mst_c1 INTO l_item_no, l_item_id, l_lot_no, l_sublot_no;
2439: IF (ic_lots_mst_c1%NOTFOUND)
2440: THEN
2441: CLOSE ic_lots_mst_c1;
2442: RETURN FALSE;
2443: ELSE

Line 2441: CLOSE ic_lots_mst_c1;

2437: OPEN ic_lots_mst_c1;
2438: FETCH ic_lots_mst_c1 INTO l_item_no, l_item_id, l_lot_no, l_sublot_no;
2439: IF (ic_lots_mst_c1%NOTFOUND)
2440: THEN
2441: CLOSE ic_lots_mst_c1;
2442: RETURN FALSE;
2443: ELSE
2444: CLOSE ic_lots_mst_c1;
2445: RETURN TRUE;

Line 2444: CLOSE ic_lots_mst_c1;

2440: THEN
2441: CLOSE ic_lots_mst_c1;
2442: RETURN FALSE;
2443: ELSE
2444: CLOSE ic_lots_mst_c1;
2445: RETURN TRUE;
2446: END IF;
2447:
2448: EXCEPTION

Line 2574: , p_lot_no IN ic_lots_mst.lot_no%TYPE

2570: --| |
2571: --+==========================================================================+
2572: FUNCTION Validate_item_cnv
2573: ( p_item_no IN ic_item_mst.item_no%TYPE
2574: , p_lot_no IN ic_lots_mst.lot_no%TYPE
2575: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
2576: , p_um_type IN ic_item_cnv.um_type%TYPE
2577: )
2578: RETURN BOOLEAN

Line 2575: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE

2571: --+==========================================================================+
2572: FUNCTION Validate_item_cnv
2573: ( p_item_no IN ic_item_mst.item_no%TYPE
2574: , p_lot_no IN ic_lots_mst.lot_no%TYPE
2575: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
2576: , p_um_type IN ic_item_cnv.um_type%TYPE
2577: )
2578: RETURN BOOLEAN
2579: IS

Line 2587: , ic_lots_mst b

2583: SELECT
2584: a.item_no
2585: FROM
2586: ic_item_mst a
2587: , ic_lots_mst b
2588: , ic_item_cnv c
2589: WHERE
2590: p_item_no = a.item_no
2591: AND a.item_id = b.item_id