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_ITEM_CNV

Line 2556: --| exists on ic_item_cnv |

2552: --| Validates Item / Lot conversion exists |
2553: --| |
2554: --| DESCRIPTION |
2555: --| This function validates that the combination of parameters passed |
2556: --| exists on ic_item_cnv |
2557: --| |
2558: --| PARAMETERS |
2559: --| p_item_no IN VARCHAR2(32) - Item Number |
2560: --| p_lot_no IN VARCHAR2(32) - Lot Number |

Line 2576: , p_um_type IN ic_item_cnv.um_type%TYPE

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
2580: l_item_no ic_item_mst.item_no%TYPE;

Line 2582: CURSOR ic_item_cnv_c1 IS

2578: RETURN BOOLEAN
2579: IS
2580: l_item_no ic_item_mst.item_no%TYPE;
2581:
2582: CURSOR ic_item_cnv_c1 IS
2583: SELECT
2584: a.item_no
2585: FROM
2586: ic_item_mst a

Line 2588: , ic_item_cnv c

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
2592: AND p_lot_no = b.lot_no

Line 2601: OPEN ic_item_cnv_c1;

2597: AND c.um_type = p_um_type;
2598:
2599: BEGIN
2600:
2601: OPEN ic_item_cnv_c1;
2602: FETCH ic_item_cnv_c1 INTO l_item_no;
2603: IF (ic_item_cnv_c1%NOTFOUND)
2604: THEN
2605: CLOSE ic_item_cnv_c1;

Line 2602: FETCH ic_item_cnv_c1 INTO l_item_no;

2598:
2599: BEGIN
2600:
2601: OPEN ic_item_cnv_c1;
2602: FETCH ic_item_cnv_c1 INTO l_item_no;
2603: IF (ic_item_cnv_c1%NOTFOUND)
2604: THEN
2605: CLOSE ic_item_cnv_c1;
2606: RETURN FALSE;

Line 2603: IF (ic_item_cnv_c1%NOTFOUND)

2599: BEGIN
2600:
2601: OPEN ic_item_cnv_c1;
2602: FETCH ic_item_cnv_c1 INTO l_item_no;
2603: IF (ic_item_cnv_c1%NOTFOUND)
2604: THEN
2605: CLOSE ic_item_cnv_c1;
2606: RETURN FALSE;
2607: ELSE

Line 2605: CLOSE ic_item_cnv_c1;

2601: OPEN ic_item_cnv_c1;
2602: FETCH ic_item_cnv_c1 INTO l_item_no;
2603: IF (ic_item_cnv_c1%NOTFOUND)
2604: THEN
2605: CLOSE ic_item_cnv_c1;
2606: RETURN FALSE;
2607: ELSE
2608: CLOSE ic_item_cnv_c1;
2609: RETURN TRUE;

Line 2608: CLOSE ic_item_cnv_c1;

2604: THEN
2605: CLOSE ic_item_cnv_c1;
2606: RETURN FALSE;
2607: ELSE
2608: CLOSE ic_item_cnv_c1;
2609: RETURN TRUE;
2610: END IF;
2611:
2612: EXCEPTION