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 OKL_CHECKLIST_DETAILS

Line 1147: l_ckl_id okl_checklist_details.ckl_id%type;

1143: l_count number := 0;
1144: l_row_found boolean := false;
1145: l_dummy number;
1146:
1147: l_ckl_id okl_checklist_details.ckl_id%type;
1148:
1149: CURSOR c_ckl_id(p_cld_id number) is
1150: select cld.ckl_id
1151: from okl_checklist_details cld

Line 1151: from okl_checklist_details cld

1147: l_ckl_id okl_checklist_details.ckl_id%type;
1148:
1149: CURSOR c_ckl_id(p_cld_id number) is
1150: select cld.ckl_id
1151: from okl_checklist_details cld
1152: where cld.id = p_cld_id
1153: ;
1154:
1155: CURSOR c_dup (p_clh_id number)

Line 1158: FROM okl_checklist_details cld,

1154:
1155: CURSOR c_dup (p_clh_id number)
1156: IS
1157: SELECT 1
1158: FROM okl_checklist_details cld,
1159: okl_checklists clh
1160: where clh.id = cld.ckl_id -- get clh.checklist_type
1161: and clh.checklist_purpose_code = 'CHECKLIST_TEMPLATE'
1162: and cld.ckl_id in (select lst.id

Line 1244: p_token1_value => 'OKL_CHECKLIST_DETAILS.MANDATORY_FLAG');

1240: IF (l_row_not_found) THEN
1241: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1242: p_msg_name => G_INVALID_VALUE,
1243: p_token1 => G_COL_NAME_TOKEN,
1244: p_token1_value => 'OKL_CHECKLIST_DETAILS.MANDATORY_FLAG');
1245:
1246: RAISE G_EXCEPTION_HALT_VALIDATION;
1247: END IF;
1248: END IF;

Line 1304: p_token1_value => 'OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG');

1300: IF (l_row_not_found) THEN
1301: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1302: p_msg_name => G_INVALID_VALUE,
1303: p_token1 => G_COL_NAME_TOKEN,
1304: p_token1_value => 'OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG');
1305:
1306: RAISE G_EXCEPTION_HALT_VALIDATION;
1307: END IF;
1308: END IF;

Line 1365: p_token1_value => 'OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS');

1361: IF (l_row_not_found) THEN
1362: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1363: p_msg_name => G_INVALID_VALUE,
1364: p_token1 => G_COL_NAME_TOKEN,
1365: p_token1_value => 'OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS');
1366:
1367: RAISE G_EXCEPTION_HALT_VALIDATION;
1368: END IF;
1369: END IF;

Line 1424: p_token1_value => 'OKL_CHECKLIST_DETAILS.FUNCTION_ID');

1420: IF (l_row_not_found) THEN
1421: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1422: p_msg_name => G_INVALID_VALUE,
1423: p_token1 => G_COL_NAME_TOKEN,
1424: p_token1_value => 'OKL_CHECKLIST_DETAILS.FUNCTION_ID');
1425:
1426: RAISE G_EXCEPTION_HALT_VALIDATION;
1427: END IF;
1428: END IF;

Line 1459: CURSOR c_grp_clist (p_cld_id okl_checklist_details.id%type)

1455: l_count number := 0;
1456: l_row_found boolean := false;
1457: l_dummy number;
1458:
1459: CURSOR c_grp_clist (p_cld_id okl_checklist_details.id%type)
1460: IS
1461: SELECT 1
1462: FROM okl_checklists clh,
1463: okl_checklist_details cld

Line 1463: okl_checklist_details cld

1459: CURSOR c_grp_clist (p_cld_id okl_checklist_details.id%type)
1460: IS
1461: SELECT 1
1462: FROM okl_checklists clh,
1463: okl_checklist_details cld
1464: WHERE clh.id = cld.ckl_id
1465: AND cld.id = p_cld_id
1466: AND clh.CHECKLIST_PURPOSE_CODE = 'CHECKLIST_TEMPLATE_GROUP'
1467: ;

Line 1525: okl_checklist_details cld

1521: CURSOR c_purpose (p_cld_id number)
1522: IS
1523: SELECT clh.checklist_purpose_code
1524: FROM okl_checklists clh,
1525: okl_checklist_details cld
1526: WHERE clh.id = cld.ckl_id
1527: AND cld.id = p_cld_id
1528: ;
1529:

Line 1618: CURSOR c_todo (p_todo_item_code okl_checklist_details.todo_item_code%type)

1614: l_dummy number;
1615:
1616: l_row_not_found boolean := false;
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'

Line 1713: CURSOR c_todo (p_todo_item_code okl_checklist_details.todo_item_code%type,

1709: l_clh_end_date date;
1710:
1711: l_row_not_found boolean := false;
1712:
1713: CURSOR c_todo (p_todo_item_code okl_checklist_details.todo_item_code%type,
1714: p_ckl_id okl_checklists.id%type)
1715: IS
1716: SELECT lok.START_DATE_ACTIVE,
1717: lok.END_DATE_ACTIVE,

Line 1824: l_todo_item_code okl_checklist_details.todo_item_code%type;

1820: l_dummy number;
1821:
1822: l_row_found boolean := false;
1823: l_checklist_number okl_checklists.checklist_number%type;
1824: l_todo_item_code okl_checklist_details.todo_item_code%type;
1825:
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

Line 1827: CURSOR c_todo_tmp_chk (p_cld_id okl_checklist_details.id%type)

1823: l_checklist_number okl_checklists.checklist_number%type;
1824: l_todo_item_code okl_checklist_details.todo_item_code%type;
1825:
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,

Line 1831: okl_checklist_details cld,

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
1835: AND lok.lookup_code = cld.todo_item_code

Line 1844: CURSOR c_todo_grp_chk (p_cld_id okl_checklist_details.id%type)

1840: NVL(TRUNC(clh.END_DATE),lok.START_DATE_ACTIVE))
1841: ;
1842:
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,

Line 1848: okl_checklist_details cld,

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'
1852: AND cld.id = p_cld_id

Line 1941: from okl_checklist_details cld,

1937:
1938: -- existing checklist items for a checcklist or a grp checklist
1939: cursor c_item_date_range_chk (p_clh_id number) is
1940: select cld.id, cld.todo_item_code
1941: from okl_checklist_details cld,
1942: okl_checklists clh
1943: where cld.ckl_id = clh.id
1944: and cld.ckl_id = p_clh_id
1945: and clh.checklist_purpose_code in ('CHECKLIST_TEMPLATE', 'CHECKLIST_INSTANCE')

Line 1948: from okl_checklist_details cld,

1944: and cld.ckl_id = p_clh_id
1945: and clh.checklist_purpose_code in ('CHECKLIST_TEMPLATE', 'CHECKLIST_INSTANCE')
1946: union
1947: select cld.id, cld.todo_item_code
1948: from okl_checklist_details cld,
1949: okl_checklists clh,
1950: okl_checklists clh_grp
1951: where cld.ckl_id = clh.id
1952: and clh.ckl_id = clh_grp.id

Line 2002: FROM okl_checklist_details cld

1998:
1999: CURSOR c_unq (p_ckl_id okl_checklists.id%type)
2000: IS
2001: SELECT 1
2002: FROM okl_checklist_details cld
2003: WHERE cld.ckl_id = p_ckl_id
2004: -- START: 06-Jan-2006 cklee -- Fixed for instance checklist item duplication check |
2005: -- GROUP BY cld.todo_item_code, cld.function_id
2006: GROUP BY cld.todo_item_code, cld.function_id, cld.INST_CHECKLIST_TYPE

Line 2080: p_token1_value => 'OKL_CHECKLIST_DETAILS.APPEAL_FLAG');

2076: THEN
2077: OKL_API.Set_Message(p_app_name => G_APP_NAME,
2078: p_msg_name => G_INVALID_VALUE,
2079: p_token1 => G_COL_NAME_TOKEN,
2080: p_token1_value => 'OKL_CHECKLIST_DETAILS.APPEAL_FLAG');
2081: RAISE G_EXCEPTION_HALT_VALIDATION;
2082: END IF;
2083: END IF;
2084: RETURN l_return_status;

Line 2982: okl_checklist_details d

2978: l_checklist_obj_id number;
2979: cursor c_dnz_object_id (p_dtl_id number) is
2980: select h.CHECKLIST_OBJ_ID
2981: from okl_checklists h,
2982: okl_checklist_details d
2983: where h.id = d.ckl_id
2984: and d.id = p_dtl_id;
2985: --END:| 21-Dec-2005 cklee -- Fixed bug#4880288 -- 4908242
2986:

Line 4154: from okl_checklist_details cld

4150: ;
4151:
4152: cursor c_checklist_grp_items (p_clh_id number) is
4153: select 1
4154: from okl_checklist_details cld
4155: where cld.ckl_id = p_clh_id
4156: ;
4157:
4158:

Line 4162: from okl_checklist_details cld

4158:
4159: -- existing checklist items for a checcklist
4160: cursor c_checklist_items (p_clh_id number) is
4161: select 1
4162: from okl_checklist_details cld
4163: where cld.ckl_id = p_clh_id
4164: ;
4165:
4166:

Line 4367: lp_return_status okl_checklist_details.FUNCTION_VALIDATE_RSTS%type;

4363: lp_cldv_rec cldv_rec_type;
4364: lx_cldv_rec cldv_rec_type;
4365: plsql_block VARCHAR2(500);
4366:
4367: lp_return_status okl_checklist_details.FUNCTION_VALIDATE_RSTS%type;
4368: lp_fund_rst okl_checklist_details.FUNCTION_VALIDATE_RSTS%type;
4369: lp_msg_data okl_checklist_details.FUNCTION_VALIDATE_MSG%type;
4370:
4371: -- get checklist template attributes

Line 4368: lp_fund_rst okl_checklist_details.FUNCTION_VALIDATE_RSTS%type;

4364: lx_cldv_rec cldv_rec_type;
4365: plsql_block VARCHAR2(500);
4366:
4367: lp_return_status okl_checklist_details.FUNCTION_VALIDATE_RSTS%type;
4368: lp_fund_rst okl_checklist_details.FUNCTION_VALIDATE_RSTS%type;
4369: lp_msg_data okl_checklist_details.FUNCTION_VALIDATE_MSG%type;
4370:
4371: -- get checklist template attributes
4372: cursor c_clist_funs (p_checklist_obj_id number) is

Line 4369: lp_msg_data okl_checklist_details.FUNCTION_VALIDATE_MSG%type;

4365: plsql_block VARCHAR2(500);
4366:
4367: lp_return_status okl_checklist_details.FUNCTION_VALIDATE_RSTS%type;
4368: lp_fund_rst okl_checklist_details.FUNCTION_VALIDATE_RSTS%type;
4369: lp_msg_data okl_checklist_details.FUNCTION_VALIDATE_MSG%type;
4370:
4371: -- get checklist template attributes
4372: cursor c_clist_funs (p_checklist_obj_id number) is
4373: select cld.FUNCTION_SOURCE,

Line 4375: from okl_checklist_details_uv cld

4371: -- get checklist template attributes
4372: cursor c_clist_funs (p_checklist_obj_id number) is
4373: select cld.FUNCTION_SOURCE,
4374: cld.ID
4375: from okl_checklist_details_uv cld
4376: --START:| 21-Dec-2005 cklee -- Fixed bug#4880288 -- 4908242
4377: ,okl_checklists hdr
4378: -- where cld.DNZ_CHECKLIST_OBJ_ID = p_checklist_obj_id
4379: where cld.ckl_id = hdr.id

Line 4571: from OKL_CHECKLIST_DETAILS chk

4567: NVL(chk.MANDATORY_FLAG, 'N') MANDATORY_FLAG,
4568: chk.USER_NOTE,
4569: chk.FUNCTION_ID,
4570: chk.INST_CHECKLIST_TYPE
4571: from OKL_CHECKLIST_DETAILS chk
4572: --START:| 21-Dec-2005 cklee -- Fixed bug#4880288 -- 4908242
4573: ,okl_checklists hdr
4574: where chk.ckl_id = hdr.id
4575: --where chk.DNZ_CHECKLIST_OBJ_ID = p_lease_app_id

Line 4583: from OKL_CHECKLIST_DETAILS chk

4579: ;
4580:
4581: cursor c_lease_app_list_exists (p_lease_app_id number) is
4582: select 1
4583: from OKL_CHECKLIST_DETAILS chk
4584: --START:| 21-Dec-2005 cklee -- Fixed bug#4880288 -- 4908242
4585: ,okl_checklists hdr
4586: where chk.ckl_id = hdr.id
4587: --where chk.DNZ_CHECKLIST_OBJ_ID = p_lease_app_id