APPS.GMIUTILS dependencies on GMIUTILS

Line 1: PACKAGE BODY GMIUTILS AS

1: PACKAGE BODY GMIUTILS AS
2: /* $Header: gmiutilb.pls 120.0 2005/05/25 16:00:37 appldev noship $
3: /* +==========================================================================+
4: | PROCEDURE NAME |
5: | get_doc_no |

Line 97: GMIUTILS.x_inventory_item_id := NULL;

93: l_inventory_item_id NUMBER;
94:
95: BEGIN
96: IF P_reset_flag = TRUE THEN
97: GMIUTILS.x_inventory_item_id := NULL;
98: GMIUTILS.x_item_no := NULL;
99: END IF;
100: -- BUG#3197801 Sastry
101: -- Added the OR condition

Line 98: GMIUTILS.x_item_no := NULL;

94:
95: BEGIN
96: IF P_reset_flag = TRUE THEN
97: GMIUTILS.x_inventory_item_id := NULL;
98: GMIUTILS.x_item_no := NULL;
99: END IF;
100: -- BUG#3197801 Sastry
101: -- Added the OR condition
102: IF GMIUTILS.x_inventory_item_id IS NULL OR GMIUTILS.x_item_no<> p_item_no THEN

Line 102: IF GMIUTILS.x_inventory_item_id IS NULL OR GMIUTILS.x_item_no<> p_item_no THEN

98: GMIUTILS.x_item_no := NULL;
99: END IF;
100: -- BUG#3197801 Sastry
101: -- Added the OR condition
102: IF GMIUTILS.x_inventory_item_id IS NULL OR GMIUTILS.x_item_no<> p_item_no THEN
103: OPEN get_inventory_item_id;
104: FETCH get_inventory_item_id INTO l_inventory_item_id ;
105: CLOSE get_inventory_item_id;
106: GMIUTILS.x_inventory_item_id := l_inventory_item_id;

Line 106: GMIUTILS.x_inventory_item_id := l_inventory_item_id;

102: IF GMIUTILS.x_inventory_item_id IS NULL OR GMIUTILS.x_item_no<> p_item_no THEN
103: OPEN get_inventory_item_id;
104: FETCH get_inventory_item_id INTO l_inventory_item_id ;
105: CLOSE get_inventory_item_id;
106: GMIUTILS.x_inventory_item_id := l_inventory_item_id;
107: GMIUTILS.x_item_no := p_item_no; -- BUG#3197801 Sastry
108: END IF;
109: RETURN GMIUTILS.x_inventory_item_id;
110: END get_inventory_item_id;

Line 107: GMIUTILS.x_item_no := p_item_no; -- BUG#3197801 Sastry

103: OPEN get_inventory_item_id;
104: FETCH get_inventory_item_id INTO l_inventory_item_id ;
105: CLOSE get_inventory_item_id;
106: GMIUTILS.x_inventory_item_id := l_inventory_item_id;
107: GMIUTILS.x_item_no := p_item_no; -- BUG#3197801 Sastry
108: END IF;
109: RETURN GMIUTILS.x_inventory_item_id;
110: END get_inventory_item_id;
111: -- END BUG#3071034

Line 109: RETURN GMIUTILS.x_inventory_item_id;

105: CLOSE get_inventory_item_id;
106: GMIUTILS.x_inventory_item_id := l_inventory_item_id;
107: GMIUTILS.x_item_no := p_item_no; -- BUG#3197801 Sastry
108: END IF;
109: RETURN GMIUTILS.x_inventory_item_id;
110: END get_inventory_item_id;
111: -- END BUG#3071034
112:
113: /* +=========================================================================+

Line 441: END GMIUTILS;

437: RETURN FALSE;
438:
439: END lot_status_check;
440:
441: END GMIUTILS;