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_CREDIT_PUB dependencies on OKL_CHECKLISTS

Line 229: l_inst_checklist_type okl_checklists.checklist_type%type;

225:
226: l_todo_item_code okl_checklist_details.TODO_ITEM_CODE%type;
227: --start: 06-May-2005 cklee okl.h Lease App IA Authoring |
228: l_function_id okl_checklist_details_uv.function_id%type;
229: l_inst_checklist_type okl_checklists.checklist_type%type;
230: l_dummy number;
231: l_is_grp_found boolean;
232:
233:

Line 236: from okl_checklists clist

232:
233:
234: cursor c_is_grp(p_ckl_id number) is
235: select 1
236: from okl_checklists clist
237: where clist.checklist_purpose_code = 'CHECKLIST_TEMPLATE_GROUP'
238: and clist.id = p_ckl_id
239: ;
240:

Line 247: from OKL_CHECKLIST_DTLS_ALL CLD, OKL_CHECKLISTS CLH

243: --start modified abhsaxen for performance SQLID 20562590
244: select cld.todo_item_code,
245: cld.function_id,
246: clh.checklist_type
247: from OKL_CHECKLIST_DTLS_ALL CLD, OKL_CHECKLISTS CLH
248: where cld.ckl_id = clh.id
249: and exists (select 1
250: from okl_checklists chlidren
251: where chlidren.id = cld.ckl_id

Line 250: from okl_checklists chlidren

246: clh.checklist_type
247: from OKL_CHECKLIST_DTLS_ALL CLD, OKL_CHECKLISTS CLH
248: where cld.ckl_id = clh.id
249: and exists (select 1
250: from okl_checklists chlidren
251: where chlidren.id = cld.ckl_id
252: and chlidren.ckl_id = p_ckl_id)
253: --end modified abhsaxen for performance SQLID 20562590
254: ;

Line 705: l_inst_checklist_type okl_checklists.checklist_type%type;

701: l_fund_cl_hdr_notfound boolean := false;
702:
703: --start: 06-May-2005 cklee okl.h Lease App IA Authoring |
704: l_function_id okl_checklist_details_uv.function_id%type;
705: l_inst_checklist_type okl_checklists.checklist_type%type;
706: l_dummy number;
707: l_is_grp_found boolean;
708:
709:

Line 712: from okl_checklists clist

708:
709:
710: cursor c_is_grp(p_ckl_id number) is
711: select 1
712: from okl_checklists clist
713: where clist.checklist_purpose_code = 'CHECKLIST_TEMPLATE_GROUP'
714: and clist.id = p_ckl_id
715: ;
716:

Line 723: from OKL_CHECKLIST_DTLS_ALL CLD, OKL_CHECKLISTS CLH

719: --start modified abhsaxen for performance SQLID 20562606
720: select cld.todo_item_code,
721: cld.function_id,
722: clh.checklist_type
723: from OKL_CHECKLIST_DTLS_ALL CLD, OKL_CHECKLISTS CLH
724: where cld.ckl_id = clh.id
725: and exists (select 1
726: from okl_checklists chlidren
727: where chlidren.id = cld.ckl_id

Line 726: from okl_checklists chlidren

722: clh.checklist_type
723: from OKL_CHECKLIST_DTLS_ALL CLD, OKL_CHECKLISTS CLH
724: where cld.ckl_id = clh.id
725: and exists (select 1
726: from okl_checklists chlidren
727: where chlidren.id = cld.ckl_id
728: and chlidren.ckl_id = p_ckl_id)
729: --end modified abhsaxen for performance SQLID 20562606
730: ;

Line 735: cursor c_chk_tpl (p_ckl_id okl_checklists.id%type) is

731:
732: ---------------------------------------------------------
733: -- to do item lists from setup
734: ---------------------------------------------------------
735: cursor c_chk_tpl (p_ckl_id okl_checklists.id%type) is
736: select ckd.TODO_ITEM_CODE,
737: --start: 06-May-2005 cklee okl.h Lease App IA Authoring |
738: ckd.FUNCTION_ID,
739: ckd.CHECKLIST_TYPE

Line 5830: l_number okl_checklists.CHECKLIST_NUMBER%type;

5826: p_chr_id IN NUMBER
5827: ,p_attr IN VARCHAR2
5828: ) RETURN VARCHAR2
5829: IS
5830: l_number okl_checklists.CHECKLIST_NUMBER%type;
5831: l_ckl_id number;
5832:
5833: CURSOR c (p_ckl_id NUMBER)
5834: IS

Line 5836: from okl_checklists ckl

5832:
5833: CURSOR c (p_ckl_id NUMBER)
5834: IS
5835: select CHECKLIST_NUMBER
5836: from okl_checklists ckl
5837: where ckl.id = to_number(p_ckl_id)
5838: ;
5839:
5840: CURSOR c_fk (p_chr_id NUMBER)