DBA Data[Home] [Help]

APPS.OKL_CREDIT_PUB dependencies on OKL_CHECKLIST_DETAILS

Line 226: l_todo_item_code okl_checklist_details.TODO_ITEM_CODE%type;

222:
223: lp_rule4_rulv_rec rulv_rec_type;
224: lx_rule4_rulv_rec rulv_rec_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;

Line 228: l_function_id okl_checklist_details_uv.function_id%type;

224: lx_rule4_rulv_rec rulv_rec_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:

Line 262: --from okl_checklist_details ckd

258: select ckd.TODO_ITEM_CODE,
259: --start: 06-May-2005 cklee okl.h Lease App IA Authoring |
260: ckd.FUNCTION_ID,
261: ckd.CHECKLIST_TYPE
262: --from okl_checklist_details ckd
263: from okl_checklist_details_uv ckd
264: --end: 06-May-2005 cklee okl.h Lease App IA Authoring |
265: where ckd.ckl_id = p_ckl_id;
266:

Line 263: from okl_checklist_details_uv ckd

259: --start: 06-May-2005 cklee okl.h Lease App IA Authoring |
260: ckd.FUNCTION_ID,
261: ckd.CHECKLIST_TYPE
262: --from okl_checklist_details ckd
263: from okl_checklist_details_uv ckd
264: --end: 06-May-2005 cklee okl.h Lease App IA Authoring |
265: where ckd.ckl_id = p_ckl_id;
266:
267: begin

Line 699: l_todo_item_code okl_checklist_details.TODO_ITEM_CODE%type;

695: l_row_found boolean := false;
696: l_RULE_INFORMATION1 okc_rules_b.RULE_INFORMATION1%type;
697: l_RULE_INFORMATION2 okc_rules_b.RULE_INFORMATION2%type;
698:
699: l_todo_item_code okl_checklist_details.TODO_ITEM_CODE%type;
700: l_fund_clist_hdr_id okc_rules_b.id%TYPE;
701: l_fund_cl_hdr_notfound boolean := false;
702:
703: --start: 06-May-2005 cklee okl.h Lease App IA Authoring |

Line 704: l_function_id okl_checklist_details_uv.function_id%type;

700: l_fund_clist_hdr_id okc_rules_b.id%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:

Line 740: --from okl_checklist_details ckd

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
740: --from okl_checklist_details ckd
741: from okl_checklist_details_uv ckd
742: --end: 06-May-2005 cklee okl.h Lease App IA Authoring |
743: where ckd.ckl_id = p_ckl_id
744: ;

Line 741: from okl_checklist_details_uv ckd

737: --start: 06-May-2005 cklee okl.h Lease App IA Authoring |
738: ckd.FUNCTION_ID,
739: ckd.CHECKLIST_TYPE
740: --from okl_checklist_details ckd
741: from okl_checklist_details_uv ckd
742: --end: 06-May-2005 cklee okl.h Lease App IA Authoring |
743: where ckd.ckl_id = p_ckl_id
744: ;
745: