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.PMI_COST_ANALZ_PACK dependencies on GEM_LOOKUPS

Line 147: FUNCTION gmca_get_meaning(p_lookup_typ IN gem_lookups.lookup_type%TYPE,

143: END IF;
144: CLOSE get_perbal_cur;
145: END gmca_get_perbal;
146:
147: FUNCTION gmca_get_meaning(p_lookup_typ IN gem_lookups.lookup_type%TYPE,
148: p_lookup_cd IN gem_lookups.lookup_code%TYPE ) RETURN VARCHAR2 IS
149: CURSOR get_meaning_cur IS
150: SELECT Meaning
151: FROM gem_lookups

Line 148: p_lookup_cd IN gem_lookups.lookup_code%TYPE ) RETURN VARCHAR2 IS

144: CLOSE get_perbal_cur;
145: END gmca_get_perbal;
146:
147: FUNCTION gmca_get_meaning(p_lookup_typ IN gem_lookups.lookup_type%TYPE,
148: p_lookup_cd IN gem_lookups.lookup_code%TYPE ) RETURN VARCHAR2 IS
149: CURSOR get_meaning_cur IS
150: SELECT Meaning
151: FROM gem_lookups
152: WHERE

Line 151: FROM gem_lookups

147: FUNCTION gmca_get_meaning(p_lookup_typ IN gem_lookups.lookup_type%TYPE,
148: p_lookup_cd IN gem_lookups.lookup_code%TYPE ) RETURN VARCHAR2 IS
149: CURSOR get_meaning_cur IS
150: SELECT Meaning
151: FROM gem_lookups
152: WHERE
153: lookup_type = p_lookup_typ AND
154: lookup_code = p_lookup_cd AND
155: enabled_flag= 'Y' AND

Line 158: l_meaning gem_lookups.meaning%TYPE;

154: lookup_code = p_lookup_cd AND
155: enabled_flag= 'Y' AND
156: start_date_active <= sysdate AND
157: (end_date_active IS NULL OR end_date_active >= sysdate);
158: l_meaning gem_lookups.meaning%TYPE;
159: BEGIN
160: OPEN get_meaning_cur;
161: FETCH get_meaning_cur INTO l_meaning; --get the value from gem lookups
162: CLOSE get_meaning_cur;

Line 161: FETCH get_meaning_cur INTO l_meaning; --get the value from gem lookups

157: (end_date_active IS NULL OR end_date_active >= sysdate);
158: l_meaning gem_lookups.meaning%TYPE;
159: BEGIN
160: OPEN get_meaning_cur;
161: FETCH get_meaning_cur INTO l_meaning; --get the value from gem lookups
162: CLOSE get_meaning_cur;
163: return l_meaning;
164: END gmca_get_meaning;
165:

Line 184: FETCH get_onhand_cur INTO l_item_id,l_qty; --get the value from gem lookups

180: l_item_id ic_loct_inv.item_id%TYPE;
181: l_qty NUMBER;
182: BEGIN
183: OPEN get_onhand_cur;
184: FETCH get_onhand_cur INTO l_item_id,l_qty; --get the value from gem lookups
185: CLOSE get_onhand_cur;
186: return l_qty;
187: END gmca_get_onhandqty;
188: