APPS.GMI_VALID_GRP dependencies on GEM_LOOKUPS

Line 2271: --| gem_lookups |

2267: --| Validates origination_type |
2268: --| |
2269: --| DESCRIPTION |
2270: --| This function validates that Origination Type exists on |
2271: --| gem_lookups |
2272: --| |
2273: --| PARAMETERS |
2274: --| p_origination_type IN NUMBER - Origination Type |
2275: --| |

Line 2290: CURSOR gem_lookups_c1 IS

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
2294: gem_lookups

Line 2294: gem_lookups

2290: CURSOR gem_lookups_c1 IS
2291: SELECT
2292: lookup_type
2293: FROM
2294: gem_lookups
2295: WHERE
2296: lookup_type = 'ORIGINATION_TYPE'
2297: AND lookup_code = p_origination_type;
2298:

Line 2301: OPEN gem_lookups_c1;

2297: AND lookup_code = p_origination_type;
2298:
2299: BEGIN
2300:
2301: OPEN gem_lookups_c1;
2302: FETCH gem_lookups_c1 INTO l_origination_type;
2303: IF (gem_lookups_c1%NOTFOUND)
2304: THEN
2305: CLOSE gem_lookups_c1;

Line 2302: FETCH gem_lookups_c1 INTO l_origination_type;

2298:
2299: BEGIN
2300:
2301: OPEN gem_lookups_c1;
2302: FETCH gem_lookups_c1 INTO l_origination_type;
2303: IF (gem_lookups_c1%NOTFOUND)
2304: THEN
2305: CLOSE gem_lookups_c1;
2306: RETURN FALSE;

Line 2303: IF (gem_lookups_c1%NOTFOUND)

2299: BEGIN
2300:
2301: OPEN gem_lookups_c1;
2302: FETCH gem_lookups_c1 INTO l_origination_type;
2303: IF (gem_lookups_c1%NOTFOUND)
2304: THEN
2305: CLOSE gem_lookups_c1;
2306: RETURN FALSE;
2307: ELSE

Line 2305: CLOSE gem_lookups_c1;

2301: OPEN gem_lookups_c1;
2302: FETCH gem_lookups_c1 INTO l_origination_type;
2303: IF (gem_lookups_c1%NOTFOUND)
2304: THEN
2305: CLOSE gem_lookups_c1;
2306: RETURN FALSE;
2307: ELSE
2308: CLOSE gem_lookups_c1;
2309: RETURN TRUE;

Line 2308: CLOSE gem_lookups_c1;

2304: THEN
2305: CLOSE gem_lookups_c1;
2306: RETURN FALSE;
2307: ELSE
2308: CLOSE gem_lookups_c1;
2309: RETURN TRUE;
2310: END IF;
2311:
2312: EXCEPTION