APPS.IGIDOSL dependencies on IGI_LOOKUPS

Line 268: FROM igi_lookups

264: /* =============== END DEBUG LOG ================== */
265:
266: SELECT meaning
267: INTO l_trx_status
268: FROM igi_lookups
269: WHERE lookup_type = 'DOSSIER STATUS'
270: AND lookup_code = 'INPROCESS';
271:
272: /* =============== START DEBUG LOG ================ */

Line 1300: FROM igi_lookups

1296:
1297: CURSOR get_status
1298: IS
1299: SELECT meaning
1300: FROM igi_lookups
1301: WHERE lookup_type ='DOSSIER STATUS'
1302: AND lookup_code ='COMPLETE';
1303:
1304: BEGIN

Line 1450: FROM igi_lookups

1446: END IF;
1447:
1448:
1449: SELECT meaning INTO l_trx_status
1450: FROM igi_lookups
1451: WHERE lookup_type ='DOSSIER STATUS'
1452: and lookup_code ='REJECTED';
1453:
1454: /* =============== START DEBUG LOG ================ */

Line 2074: FROM igi_lookups

2070: RAISE unreserve_error ;
2071: ELSE
2072:
2073: SELECT meaning INTO l_trx_status
2074: FROM igi_lookups
2075: WHERE lookup_type ='DOSSIER STATUS'
2076: and lookup_code ='REJECTED';
2077:
2078: /* =============== START DEBUG LOG ================ */

Line 2608: l_trx_status igi_lookups.meaning%TYPE;

2604: actid IN NUMBER,
2605: funcmode IN VARCHAR2,
2606: result OUT NOCOPY VARCHAR2 ) IS
2607:
2608: l_trx_status igi_lookups.meaning%TYPE;
2609: l_dossier_num igi_dos_trx_headers.trx_number%TYPE :=
2610: Wf_Engine.GetItemAttrText ( itemtype => itemtype,
2611: itemkey => itemkey,
2612: aname => 'DOSSIER_NUM');

Line 2616: FROM igi_lookups

2612: aname => 'DOSSIER_NUM');
2613:
2614: CURSOR c_meaning IS
2615: SELECT meaning
2616: FROM igi_lookups
2617: WHERE lookup_type = 'DOSSIER STATUS'
2618: AND lookup_code = 'CREATING';
2619:
2620: BEGIN