APPS.IGIDOSL dependencies on IGI_LOOKUPS

Line 283: FROM igi_lookups

279: /* =============== END DEBUG LOG ================== */
280:
281: SELECT meaning
282: INTO l_trx_status
283: FROM igi_lookups
284: WHERE lookup_type = 'DOSSIER STATUS'
285: AND lookup_code = 'INPROCESS';
286:
287: /* =============== START DEBUG LOG ================ */

Line 1323: FROM igi_lookups

1319:
1320: CURSOR get_status
1321: IS
1322: SELECT meaning
1323: FROM igi_lookups
1324: WHERE lookup_type ='DOSSIER STATUS'
1325: AND lookup_code ='COMPLETE';
1326:
1327: BEGIN

Line 1379: FROM igi_lookups

1375: BEGIN
1376: select trx_status into l_status
1377: from IGI_DOS_TRX_HEADERS
1378: where trx_status = ( SELECT meaning
1379: FROM igi_lookups
1380: WHERE lookup_type ='DOSSIER STATUS'
1381: and lookup_code ='INPROCESS')
1382: AND trx_number = l_trx_number ;
1383: DEBUG_LOG_STRING (l_proc_level, 'UnreserveFunds.Msg3.11',

Line 1516: FROM igi_lookups

1512: END IF;
1513:
1514:
1515: SELECT meaning INTO l_trx_status
1516: FROM igi_lookups
1517: WHERE lookup_type ='DOSSIER STATUS'
1518: and lookup_code ='REJECTED';
1519:
1520: /* =============== START DEBUG LOG ================ */

Line 2141: FROM igi_lookups

2137: BEGIN
2138: select trx_status into l_status
2139: from IGI_DOS_TRX_HEADERS
2140: where trx_status = ( SELECT meaning
2141: FROM igi_lookups
2142: WHERE lookup_type ='DOSSIER STATUS'
2143: and lookup_code ='INPROCESS')
2144: AND trx_number = l_trx_number ;
2145: DEBUG_LOG_STRING (l_proc_level, 'UnreserveFunds.Msg3.11',

Line 2189: FROM igi_lookups

2185: --RAISE unreserve_error ;
2186: ELSE
2187:
2188: SELECT meaning INTO l_trx_status
2189: FROM igi_lookups
2190: WHERE lookup_type ='DOSSIER STATUS'
2191: and lookup_code ='REJECTED';
2192:
2193: /* =============== START DEBUG LOG ================ */

Line 2742: l_trx_status igi_lookups.meaning%TYPE;

2738: actid IN NUMBER,
2739: funcmode IN VARCHAR2,
2740: result OUT NOCOPY VARCHAR2 ) IS
2741:
2742: l_trx_status igi_lookups.meaning%TYPE;
2743: l_dossier_num igi_dos_trx_headers.trx_number%TYPE :=
2744: Wf_Engine.GetItemAttrText ( itemtype => itemtype,
2745: itemkey => itemkey,
2746: aname => 'DOSSIER_NUM');

Line 2750: FROM igi_lookups

2746: aname => 'DOSSIER_NUM');
2747:
2748: CURSOR c_meaning IS
2749: SELECT meaning
2750: FROM igi_lookups
2751: WHERE lookup_type = 'DOSSIER STATUS'
2752: AND lookup_code = 'CREATING';
2753:
2754: BEGIN