APPS.GMICVAL dependencies on IC_LOCT_MST

Line 437: --l_loct_desc ic_loct_mst.loct_desc%TYPE; -- Bug 3585309

433: RETURN NUMBER IS
434:
435: /* Local Variable declaration:
436: ===========================*/
437: --l_loct_desc ic_loct_mst.loct_desc%TYPE; -- Bug 3585309
438: l_location ic_loct_mst.location%TYPE; -- Bug 3585309
439: l_default_loct ic_loct_mst.location%TYPE;
440: l_whse_loct_ctl ic_whse_mst.loct_ctl%TYPE;
441: l_whse ic_whse_mst.whse_code%TYPE;

Line 438: l_location ic_loct_mst.location%TYPE; -- Bug 3585309

434:
435: /* Local Variable declaration:
436: ===========================*/
437: --l_loct_desc ic_loct_mst.loct_desc%TYPE; -- Bug 3585309
438: l_location ic_loct_mst.location%TYPE; -- Bug 3585309
439: l_default_loct ic_loct_mst.location%TYPE;
440: l_whse_loct_ctl ic_whse_mst.loct_ctl%TYPE;
441: l_whse ic_whse_mst.whse_code%TYPE;
442:

Line 439: l_default_loct ic_loct_mst.location%TYPE;

435: /* Local Variable declaration:
436: ===========================*/
437: --l_loct_desc ic_loct_mst.loct_desc%TYPE; -- Bug 3585309
438: l_location ic_loct_mst.location%TYPE; -- Bug 3585309
439: l_default_loct ic_loct_mst.location%TYPE;
440: l_whse_loct_ctl ic_whse_mst.loct_ctl%TYPE;
441: l_whse ic_whse_mst.whse_code%TYPE;
442:
443: /* Cursor Definitions

Line 453: FROM ic_loct_mst

449: AND delete_mark = 0;
450:
451: CURSOR validate_location IS
452: SELECT location
453: FROM ic_loct_mst
454: WHERE location = UPPER(plocation)
455: AND whse_code = UPPER(pwhse_code)
456: AND delete_mark = 0;
457:

Line 604: --l_loct_desc ic_loct_mst.loct_desc%TYPE; -- Bug 3585309

600: RETURN NUMBER IS
601:
602: /* Local Variable declaration:
603: =========================== */
604: --l_loct_desc ic_loct_mst.loct_desc%TYPE; -- Bug 3585309
605: l_location ic_loct_mst.location%TYPE; -- Bug 3585309
606: l_default_loct ic_loct_mst.location%TYPE;
607: l_whse_loct_ctl ic_whse_mst.loct_ctl%TYPE;
608: l_whse ic_whse_mst.whse_code%TYPE;

Line 605: l_location ic_loct_mst.location%TYPE; -- Bug 3585309

601:
602: /* Local Variable declaration:
603: =========================== */
604: --l_loct_desc ic_loct_mst.loct_desc%TYPE; -- Bug 3585309
605: l_location ic_loct_mst.location%TYPE; -- Bug 3585309
606: l_default_loct ic_loct_mst.location%TYPE;
607: l_whse_loct_ctl ic_whse_mst.loct_ctl%TYPE;
608: l_whse ic_whse_mst.whse_code%TYPE;
609:

Line 606: l_default_loct ic_loct_mst.location%TYPE;

602: /* Local Variable declaration:
603: =========================== */
604: --l_loct_desc ic_loct_mst.loct_desc%TYPE; -- Bug 3585309
605: l_location ic_loct_mst.location%TYPE; -- Bug 3585309
606: l_default_loct ic_loct_mst.location%TYPE;
607: l_whse_loct_ctl ic_whse_mst.loct_ctl%TYPE;
608: l_whse ic_whse_mst.whse_code%TYPE;
609:
610: /* Cursor Definitions

Line 621: FROM ic_loct_mst

617: AND delete_mark = 0;
618:
619: CURSOR validate_location IS
620: SELECT location
621: FROM ic_loct_mst
622: WHERE location = UPPER(plocation)
623: AND whse_code = UPPER(pwhse_code)
624: AND delete_mark = 0;
625: