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_CHECKLISTS

Line 123: l_org_purpose_code okl_checklists.CHECKLIST_PURPOSE_CODE%type;

119: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
120: l_dummy varchar2(80);
121:
122: l_row_not_found boolean := false;
123: l_org_purpose_code okl_checklists.CHECKLIST_PURPOSE_CODE%type;
124: l_org_status_code okl_checklists_uv.STATUS_CODE%type;
125: l_org_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;
126:
127: l_cur_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;

Line 124: l_org_status_code okl_checklists_uv.STATUS_CODE%type;

120: l_dummy varchar2(80);
121:
122: l_row_not_found boolean := false;
123: l_org_purpose_code okl_checklists.CHECKLIST_PURPOSE_CODE%type;
124: l_org_status_code okl_checklists_uv.STATUS_CODE%type;
125: l_org_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;
126:
127: l_cur_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;
128:

Line 125: l_org_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;

121:
122: l_row_not_found boolean := false;
123: l_org_purpose_code okl_checklists.CHECKLIST_PURPOSE_CODE%type;
124: l_org_status_code okl_checklists_uv.STATUS_CODE%type;
125: l_org_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;
126:
127: l_cur_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;
128:
129:

Line 127: l_cur_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;

123: l_org_purpose_code okl_checklists.CHECKLIST_PURPOSE_CODE%type;
124: l_org_status_code okl_checklists_uv.STATUS_CODE%type;
125: l_org_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;
126:
127: l_cur_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;
128:
129:
130: CURSOR c_lookup (p_lookup_code VARCHAR2,
131: p_lookup_type VARCHAR2)

Line 144: FROM okl_checklists_uv clh

140: IS
141: SELECT clh.CHECKLIST_PURPOSE_CODE,
142: clh.STATUS_CODE,
143: clh.STATUS_CODE_MEANING
144: FROM okl_checklists_uv clh
145: WHERE clh.id = p_clh_id
146: ;
147:
148: BEGIN

Line 256: l_purpose_code okl_checklists.CHECKLIST_PURPOSE_CODE%type;

252: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
253: l_dummy number;
254:
255: l_row_not_found boolean := false;
256: l_purpose_code okl_checklists.CHECKLIST_PURPOSE_CODE%type;
257:
258: cursor c_purpose(p_clh_id number) is
259: select clh.CHECKLIST_PURPOSE_CODE
260: from okl_checklists clh

Line 260: from okl_checklists clh

256: l_purpose_code okl_checklists.CHECKLIST_PURPOSE_CODE%type;
257:
258: cursor c_purpose(p_clh_id number) is
259: select clh.CHECKLIST_PURPOSE_CODE
260: from okl_checklists clh
261: where clh.id = p_clh_id
262: ;
263:
264: BEGIN

Line 329: l_purpose_code okl_checklists.CHECKLIST_PURPOSE_CODE%type;

325: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
326: l_dummy number;
327:
328: l_row_not_found boolean := false;
329: l_purpose_code okl_checklists.CHECKLIST_PURPOSE_CODE%type;
330:
331: CURSOR c_lookup (p_lookup_code VARCHAR2)
332: IS
333: SELECT 1

Line 341: from okl_checklists clh

337: ;
338:
339: cursor c_purpose(p_clh_id number) is
340: select clh.CHECKLIST_PURPOSE_CODE
341: from okl_checklists clh
342: where clh.id = p_clh_id
343: ;
344:
345: BEGIN

Line 435: FROM okl_checklists ckl

431:
432: CURSOR c_parent_id (p_id NUMBER)
433: IS
434: SELECT 1
435: FROM okl_checklists ckl
436: WHERE ckl.CHECKLIST_PURPOSE_CODE = 'CHECKLIST_TEMPLATE_GROUP'
437: -- AND ckl.STATUS_CODE = 'NEW'
438: AND ckl.id = p_id
439: ;

Line 458: p_token1_value => 'OKL_CHECKLISTS.CKL_ID');

454: IF (l_row_not_found) THEN
455: OKL_API.Set_Message(p_app_name => G_APP_NAME,
456: p_msg_name => G_INVALID_VALUE,
457: p_token1 => G_COL_NAME_TOKEN,
458: p_token1_value => 'OKL_CHECKLISTS.CKL_ID');
459:
460: RAISE G_EXCEPTION_HALT_VALIDATION;
461: END IF;
462: END IF;

Line 563: l_org_checklist_type okl_checklists.CHECKLIST_TYPE%type;

559: l_dummy varchar2(80);
560:
561: l_row_not_found boolean := false;
562:
563: l_org_checklist_type okl_checklists.CHECKLIST_TYPE%type;
564: l_org_status_code okl_checklists_uv.STATUS_CODE%type;
565: l_org_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;
566:
567: l_cur_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;

Line 564: l_org_status_code okl_checklists_uv.STATUS_CODE%type;

560:
561: l_row_not_found boolean := false;
562:
563: l_org_checklist_type okl_checklists.CHECKLIST_TYPE%type;
564: l_org_status_code okl_checklists_uv.STATUS_CODE%type;
565: l_org_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;
566:
567: l_cur_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;
568:

Line 565: l_org_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;

561: l_row_not_found boolean := false;
562:
563: l_org_checklist_type okl_checklists.CHECKLIST_TYPE%type;
564: l_org_status_code okl_checklists_uv.STATUS_CODE%type;
565: l_org_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;
566:
567: l_cur_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;
568:
569:

Line 567: l_cur_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;

563: l_org_checklist_type okl_checklists.CHECKLIST_TYPE%type;
564: l_org_status_code okl_checklists_uv.STATUS_CODE%type;
565: l_org_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;
566:
567: l_cur_status_code_meaning okl_checklists_uv.STATUS_CODE_MEANING%type;
568:
569:
570: CURSOR c_lookup (p_lookup_code VARCHAR2,
571: p_lookup_type VARCHAR2)

Line 585: FROM okl_checklists_uv clh

581: IS
582: SELECT clh.CHECKLIST_TYPE,
583: clh.STATUS_CODE,
584: clh.STATUS_CODE_MEANING
585: FROM okl_checklists_uv clh
586: WHERE clh.id = p_clh_id
587: ;
588:
589:

Line 860: l_purpose_code okl_checklists.CHECKLIST_PURPOSE_CODE%type;

856: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
857: l_dummy number;
858:
859: l_row_not_found boolean := false;
860: l_purpose_code okl_checklists.CHECKLIST_PURPOSE_CODE%type;
861:
862: CURSOR c_purpose (p_clh_id number)
863: IS
864: SELECT clh.CHECKLIST_PURPOSE_CODE

Line 865: FROM okl_checklists clh

861:
862: CURSOR c_purpose (p_clh_id number)
863: IS
864: SELECT clh.CHECKLIST_PURPOSE_CODE
865: FROM okl_checklists clh
866: WHERE clh.id = p_clh_id
867: ;
868:
869: -- get all rows by group id

Line 876: FROM okl_checklists grp,

872: SELECT grp.START_DATE grp_START_DATE,
873: grp.END_DATE grp_END_DATE,
874: cld.START_DATE cld_START_DATE,
875: cld.END_DATE cld_END_DATE
876: FROM okl_checklists grp,
877: okl_checklists cld
878: WHERE grp.id = cld.ckl_id
879: AND grp.id = p_clh_id
880: ;

Line 877: okl_checklists cld

873: grp.END_DATE grp_END_DATE,
874: cld.START_DATE cld_START_DATE,
875: cld.END_DATE cld_END_DATE
876: FROM okl_checklists grp,
877: okl_checklists cld
878: WHERE grp.id = cld.ckl_id
879: AND grp.id = p_clh_id
880: ;
881:

Line 889: FROM okl_checklists grp,

885: SELECT grp.START_DATE grp_START_DATE,
886: grp.END_DATE grp_END_DATE,
887: cld.START_DATE cld_START_DATE,
888: cld.END_DATE cld_END_DATE
889: FROM okl_checklists grp,
890: okl_checklists cld
891: WHERE grp.id = cld.ckl_id
892: AND cld.id = p_clh_id
893: ;

Line 890: okl_checklists cld

886: grp.END_DATE grp_END_DATE,
887: cld.START_DATE cld_START_DATE,
888: cld.END_DATE cld_END_DATE
889: FROM okl_checklists grp,
890: okl_checklists cld
891: WHERE grp.id = cld.ckl_id
892: AND cld.id = p_clh_id
893: ;
894:

Line 1040: FROM okl_checklists clh

1036:
1037: CURSOR c_unq (p_checklist_number VARCHAR2, p_checklist_type VARCHAR2)
1038: IS
1039: SELECT count(1)
1040: FROM okl_checklists clh
1041: WHERE UPPER(clh.checklist_number) = UPPER(p_checklist_number)
1042: AND clh.checklist_type = p_checklist_type
1043: ;
1044:

Line 1092: from okl_checklists clh

1088: l_row_found boolean := false;
1089:
1090: cursor c_date(p_id number)
1091: is select 1
1092: from okl_checklists clh
1093: where clh.start_date is not null
1094: and trunc(clh.start_date) > trunc(clh.end_date)
1095: and clh.id = p_id
1096: ;

Line 1159: okl_checklists clh

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
1163: from okl_checklists lst,

Line 1163: from okl_checklists lst,

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
1163: from okl_checklists lst,
1164: okl_checklists prt
1165: where lst.ckl_id = prt.ckl_id
1166: and prt.id = p_clh_id)
1167: GROUP BY cld.todo_item_code, cld.FUNCTION_ID, clh.checklist_type

Line 1164: okl_checklists prt

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
1163: from okl_checklists lst,
1164: okl_checklists prt
1165: where lst.ckl_id = prt.ckl_id
1166: and prt.id = p_clh_id)
1167: GROUP BY cld.todo_item_code, cld.FUNCTION_ID, clh.checklist_type
1168: HAVING count(1) > 1

Line 1462: FROM okl_checklists clh,

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
1464: WHERE clh.id = cld.ckl_id
1465: AND cld.id = p_cld_id
1466: AND clh.CHECKLIST_PURPOSE_CODE = 'CHECKLIST_TEMPLATE_GROUP'

Line 1509: l_purpose okl_checklists.checklist_purpose_code%type;

1505: ) RETURN VARCHAR2
1506: IS
1507: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1508: l_dummy number;
1509: l_purpose okl_checklists.checklist_purpose_code%type;
1510:
1511: l_row_not_found boolean := false;
1512:
1513: CURSOR c_type (p_checklist_type VARCHAR2)

Line 1524: FROM okl_checklists clh,

1520:
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: ;

Line 1714: p_ckl_id okl_checklists.id%type)

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,
1718: clh.START_DATE,

Line 1721: okl_checklists clh

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')
1725: -- = lok.lookup_type

Line 1823: l_checklist_number okl_checklists.checklist_number%type;

1819: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
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)

Line 1832: okl_checklists clh

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
1836: AND cld.ckl_id = clh.id

Line 1849: okl_checklists clh,

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

Line 1850: okl_checklists clh_grp

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
1853: AND lok.lookup_code = cld.todo_item_code
1854: AND cld.ckl_id = clh.id

Line 1942: okl_checklists clh

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')
1946: union

Line 1949: okl_checklists clh,

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
1953: and clh_grp.id = p_clh_id

Line 1950: okl_checklists clh_grp

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
1953: and clh_grp.id = p_clh_id
1954: and clh_grp.checklist_purpose_code = 'CHECKLIST_TEMPLATE_GROUP'

Line 1999: CURSOR c_unq (p_ckl_id okl_checklists.id%type)

1995: l_count number := 0;
1996: l_row_found boolean := false;
1997: l_dummy number;
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

Line 2981: from okl_checklists h,

2977: --START:| 21-Dec-2005 cklee -- Fixed bug#4880288 -- 4908242
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

Line 3243: l_org_status_code okl_checklists.status_code%type;

3239: i NUMBER;
3240: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3241: lp_clhv_rec clhv_rec_type;
3242: lx_clhv_rec clhv_rec_type;
3243: l_org_status_code okl_checklists.status_code%type;
3244:
3245: cursor c_get_status (p_clh_id number) is
3246: select clh.status_code
3247: from okl_checklists clh

Line 3247: from okl_checklists clh

3243: l_org_status_code okl_checklists.status_code%type;
3244:
3245: cursor c_get_status (p_clh_id number) is
3246: select clh.status_code
3247: from okl_checklists clh
3248: where clh.id = p_clh_id;
3249:
3250: cursor c_get_children (p_clh_id number) is
3251: select clh.id

Line 3252: from okl_checklists clh

3248: where clh.id = p_clh_id;
3249:
3250: cursor c_get_children (p_clh_id number) is
3251: select clh.id
3252: from okl_checklists clh
3253: where clh.ckl_id = p_clh_id;
3254:
3255: begin
3256: -- Set API savepoint

Line 3724: -- 2. CKL_ID is referring from okl_checklists.ID as FK

3720: -- Procedure Name : create_checklist_inst_dtl
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'

Line 3764: from okl_checklists clh

3760: l_obj_id number;
3761:
3762: cursor c_obj_id (p_clh_id number) is
3763: select clh.CHECKLIST_OBJ_ID
3764: from okl_checklists clh
3765: where clh.id = p_clh_id;
3766:
3767: begin
3768: -- Set API savepoint

Line 4134: from okl_checklists clh

4130: cursor c_checklists (p_clh_id number) is
4131: select clh.status_code,
4132: clh.checklist_purpose_code,
4133: clh.ckl_id
4134: from okl_checklists clh
4135: where clh.id = p_clh_id
4136: ;
4137:
4138: -- existing checklists for a group checklist

Line 4141: from okl_checklists clh

4137:
4138: -- existing checklists for a group checklist
4139: cursor c_checklist_grp (p_clh_id number) is
4140: select 1
4141: from okl_checklists clh
4142: where clh.ckl_id = p_clh_id
4143: ;
4144:
4145: -- existing checklist items for a group checklist

Line 4148: from okl_checklists clh

4144:
4145: -- existing checklist items for a group checklist
4146: cursor c_clist_ids_by_grp (p_clh_id number) is
4147: select clh.id
4148: from okl_checklists clh
4149: where clh.ckl_id = p_clh_id
4150: ;
4151:
4152: cursor c_checklist_grp_items (p_clh_id number) is

Line 4377: ,okl_checklists hdr

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
4380: and hdr.CHECKLIST_OBJ_ID = p_checklist_obj_id
4381: --START:| 21-Dec-2005 cklee -- Fixed bug#4880288 -- 4908242

Line 4573: ,okl_checklists hdr

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
4576: and hdr.CHECKLIST_OBJ_ID = p_lease_app_id
4577: --START:| 21-Dec-2005 cklee -- Fixed bug#4880288 -- 4908242

Line 4585: ,okl_checklists hdr

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
4588: and hdr.CHECKLIST_OBJ_ID = p_lease_app_id
4589: --END:| 21-Dec-2005 cklee -- Fixed bug#4880288 -- 4908242