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.OKL_CHECKLIST_PVT dependencies on FND_LOOKUPS

Line 38: FROM fnd_lookups lok

34:
35: CURSOR c_lookup (p_lookup_code VARCHAR2)
36: IS
37: SELECT 1
38: FROM fnd_lookups lok
39: WHERE lok.lookup_type = 'OKL_CHECKLIST_STATUS_CODE'
40: AND lok.lookup_code = p_lookup_code
41: ;
42:

Line 134: FROM fnd_lookups lok

130: CURSOR c_lookup (p_lookup_code VARCHAR2,
131: p_lookup_type VARCHAR2)
132: IS
133: SELECT lok.MEANING
134: FROM fnd_lookups lok
135: WHERE lok.lookup_type = p_lookup_type
136: AND lok.lookup_code = p_lookup_code
137: ;
138:

Line 334: FROM fnd_lookups lok

330:
331: CURSOR c_lookup (p_lookup_code VARCHAR2)
332: IS
333: SELECT 1
334: FROM fnd_lookups lok
335: WHERE lok.lookup_type = 'OKL_CHECKLIST_OBJ_TYPE_CODE'
336: AND lok.lookup_code = p_lookup_code
337: ;
338:

Line 574: FROM fnd_lookups lok

570: CURSOR c_lookup (p_lookup_code VARCHAR2,
571: p_lookup_type VARCHAR2)
572: IS
573: SELECT lok.MEANING
574: FROM fnd_lookups lok
575: WHERE lok.lookup_type = p_lookup_type
576: AND lok.lookup_code = p_lookup_code
577: AND lok.enabled_flag = 'Y'
578: ;

Line 1222: FROM fnd_lookups lok

1218:
1219: CURSOR c_lookup (p_lookup_code VARCHAR2)
1220: IS
1221: SELECT 1
1222: FROM fnd_lookups lok
1223: WHERE lok.lookup_type = 'OKL_YES_NO'
1224: AND lok.lookup_code = p_lookup_code
1225: ;
1226:

Line 1282: FROM fnd_lookups lok

1278:
1279: CURSOR c_lookup (p_lookup_code VARCHAR2)
1280: IS
1281: SELECT 1
1282: FROM fnd_lookups lok
1283: WHERE lok.lookup_type = 'OKL_YES_NO'
1284: AND lok.lookup_code = p_lookup_code
1285: ;
1286:

Line 1343: FROM fnd_lookups lok

1339:
1340: CURSOR c_lookup (p_lookup_code VARCHAR2)
1341: IS
1342: SELECT 1
1343: FROM fnd_lookups lok
1344: WHERE lok.lookup_type = 'OKL_FUN_VALIDATE_RSTS'
1345: AND lok.lookup_code = p_lookup_code
1346: ;
1347:

Line 1516: FROM fnd_lookups lok

1512:
1513: CURSOR c_type (p_checklist_type VARCHAR2)
1514: IS
1515: SELECT 1
1516: FROM fnd_lookups lok
1517: WHERE lok.lookup_type = G_CHECKLIST_TYPE_LOOKUP_TYPE
1518: AND lok.lookup_code = p_checklist_type
1519: ;
1520:

Line 1621: FROM fnd_lookups lok

1617:
1618: CURSOR c_todo (p_todo_item_code okl_checklist_details.todo_item_code%type)
1619: IS
1620: SELECT 1
1621: FROM fnd_lookups lok
1622: WHERE lok.lookup_type = 'OKL_TODO_ITEMS'
1623: AND lok.lookup_code = p_todo_item_code
1624: ;
1625:

Line 1720: FROM fnd_lookups lok,

1716: SELECT lok.START_DATE_ACTIVE,
1717: lok.END_DATE_ACTIVE,
1718: clh.START_DATE,
1719: clh.END_DATE
1720: FROM fnd_lookups lok,
1721: okl_checklists clh
1722: -- START: Apr 25, 2005 cklee: Modification for okl.h lease app enhancement
1723: -- WHERE decode(clh.checklist_type, 'CREDITLINE', 'OKL_TODO_CREDIT_CHKLST'
1724: -- , 'FUNDING_REQUEST', 'OKL_TODO_FUNDING_CHKLST')

Line 1830: FROM fnd_lookups lok,

1826: -- Check if todo item effective from date within the checklist header's effective dates range
1827: CURSOR c_todo_tmp_chk (p_cld_id okl_checklist_details.id%type)
1828: IS
1829: SELECT clh.checklist_number, cld.todo_item_code
1830: FROM fnd_lookups lok,
1831: okl_checklist_details cld,
1832: okl_checklists clh
1833: WHERE lok.lookup_type = 'OKL_TODO_ITEMS'
1834: AND cld.id = p_cld_id

Line 1847: FROM fnd_lookups lok,

1843: -- Check if todo item effective from date within the checklist group header's effective dates range
1844: CURSOR c_todo_grp_chk (p_cld_id okl_checklist_details.id%type)
1845: IS
1846: SELECT clh_grp.checklist_number, cld.todo_item_code
1847: FROM fnd_lookups lok,
1848: okl_checklist_details cld,
1849: okl_checklists clh,
1850: okl_checklists clh_grp
1851: WHERE lok.lookup_type = 'OKL_TODO_ITEMS'

Line 2063: FROM fnd_lookups lok

2059:
2060: CURSOR c_lookup(p_lookup_code VARCHAR2)
2061: IS
2062: SELECT 1
2063: FROM fnd_lookups lok
2064: WHERE lok.lookup_type = 'OKL_YES_NO'
2065: AND lok.lookup_code = p_lookup_code;
2066: BEGIN
2067: -- check only if object exists

Line 3390: -- 2. CHECKLIST_OBJ_TYPE_CODE is referring from fnd_lookups type

3386: -- Procedure Name : create_checklist_inst_hdr
3387: -- Description : wrapper api for create checklist instance header
3388: -- Business Rules :
3389: -- 1. CHECKLIST_OBJ_ID and CHECKLIST_OBJ_TYPE_CODE are required
3390: -- 2. CHECKLIST_OBJ_TYPE_CODE is referring from fnd_lookups type
3391: -- = 'CHECKLIST_OBJ_TYPE_CODE'
3392: -- 3. CHECKLIST_TYPE will be defaulting to 'NONE'
3393: -- 4. CHECKLIST_NUMBER will be defaulting to 'CHECKLIST_INSTANCE'
3394: -- appending system generated sequence number

Line 3725: -- 3. TODO_ITEM_CODE is referring from fnd_lookups type

3721: -- Description : wrapper api for create checklist instance details
3722: -- Business Rules :
3723: -- 1. CKL_ID, TODO_ITEM_CODE, and INST_CHECKLIST_TYPE are required
3724: -- 2. CKL_ID is referring from okl_checklists.ID as FK
3725: -- 3. TODO_ITEM_CODE is referring from fnd_lookups type
3726: -- = 'OKL_TODO_ITEMS'
3727: -- 4. INST_CHECKLIST_TYPE is referring from fnd_lookups type
3728: -- = 'OKL_CHECKLIST_TYPE'
3729: -- 5. The following columns are referring from fnd_lookups type

Line 3727: -- 4. INST_CHECKLIST_TYPE is referring from fnd_lookups type

3723: -- 1. CKL_ID, TODO_ITEM_CODE, and INST_CHECKLIST_TYPE are required
3724: -- 2. CKL_ID is referring from okl_checklists.ID as FK
3725: -- 3. TODO_ITEM_CODE is referring from fnd_lookups type
3726: -- = 'OKL_TODO_ITEMS'
3727: -- 4. INST_CHECKLIST_TYPE is referring from fnd_lookups type
3728: -- = 'OKL_CHECKLIST_TYPE'
3729: -- 5. The following columns are referring from fnd_lookups type
3730: -- = 'OKL_YES_NO'
3731: -- MANDATORY_FLAG

Line 3729: -- 5. The following columns are referring from fnd_lookups type

3725: -- 3. TODO_ITEM_CODE is referring from fnd_lookups type
3726: -- = 'OKL_TODO_ITEMS'
3727: -- 4. INST_CHECKLIST_TYPE is referring from fnd_lookups type
3728: -- = 'OKL_CHECKLIST_TYPE'
3729: -- 5. The following columns are referring from fnd_lookups type
3730: -- = 'OKL_YES_NO'
3731: -- MANDATORY_FLAG
3732: -- USER_COMPLETE_FLAG
3733: -- APPEAL_FLAG

Line 3734: -- 6. FUNCTION_VALIDATE_RSTS is referring from fnd_lookups type

3730: -- = 'OKL_YES_NO'
3731: -- MANDATORY_FLAG
3732: -- USER_COMPLETE_FLAG
3733: -- APPEAL_FLAG
3734: -- 6. FUNCTION_VALIDATE_RSTS is referring from fnd_lookups type
3735: -- = 'OKL_FUN_VALIDATE_RSTS'
3736: -- 7. System will defaulting DNZ_CHECKLIST_OBJ_ID from the
3737: -- corresponding okl_chekclists.CHECKLIST_OBJ_ID
3738: -- 8. FUNCTION_ID is referring from OKL_DATA_SRC_FNCTNS_V