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_FUNDING_PVT dependencies on OKL_CRD_FUND_CHECKLISTS_TPL_UV

Line 506: l_todo_item_code okl_crd_fund_checklists_tpl_uv.TODO_ITEM_CODE%type;

502: l_expired_row_found boolean;
503:
504: l_dummy number;
505: l_rgpv_id okc_rule_groups_b.id%type;
506: l_todo_item_code okl_crd_fund_checklists_tpl_uv.TODO_ITEM_CODE%type;
507: l_mandatory_flag okl_crd_fund_checklists_tpl_uv.mandatory_flag%type;
508: l_note okl_crd_fund_checklists_tpl_uv.note%type;
509: l_status okl_crd_fund_checklists_tpl_uv.status%type;
510: l_fund_cls_tpl_exp_found boolean;

Line 507: l_mandatory_flag okl_crd_fund_checklists_tpl_uv.mandatory_flag%type;

503:
504: l_dummy number;
505: l_rgpv_id okc_rule_groups_b.id%type;
506: l_todo_item_code okl_crd_fund_checklists_tpl_uv.TODO_ITEM_CODE%type;
507: l_mandatory_flag okl_crd_fund_checklists_tpl_uv.mandatory_flag%type;
508: l_note okl_crd_fund_checklists_tpl_uv.note%type;
509: l_status okl_crd_fund_checklists_tpl_uv.status%type;
510: l_fund_cls_tpl_exp_found boolean;
511: l_chklist_sts_row_found boolean;

Line 508: l_note okl_crd_fund_checklists_tpl_uv.note%type;

504: l_dummy number;
505: l_rgpv_id okc_rule_groups_b.id%type;
506: l_todo_item_code okl_crd_fund_checklists_tpl_uv.TODO_ITEM_CODE%type;
507: l_mandatory_flag okl_crd_fund_checklists_tpl_uv.mandatory_flag%type;
508: l_note okl_crd_fund_checklists_tpl_uv.note%type;
509: l_status okl_crd_fund_checklists_tpl_uv.status%type;
510: l_fund_cls_tpl_exp_found boolean;
511: l_chklist_sts_row_found boolean;
512:

Line 509: l_status okl_crd_fund_checklists_tpl_uv.status%type;

505: l_rgpv_id okc_rule_groups_b.id%type;
506: l_todo_item_code okl_crd_fund_checklists_tpl_uv.TODO_ITEM_CODE%type;
507: l_mandatory_flag okl_crd_fund_checklists_tpl_uv.mandatory_flag%type;
508: l_note okl_crd_fund_checklists_tpl_uv.note%type;
509: l_status okl_crd_fund_checklists_tpl_uv.status%type;
510: l_fund_cls_tpl_exp_found boolean;
511: l_chklist_sts_row_found boolean;
512:
513:

Line 521: l_function_id okl_crd_fund_checklists_tpl_uv.function_id%type;

517:
518: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE;
519: l_checklists_row_found boolean;
520: -- start: 23-May-2005 cklee okl.h Lease App IA Authoring |
521: l_function_id okl_crd_fund_checklists_tpl_uv.function_id%type;
522: l_checklist_type okl_crd_fund_checklists_tpl_uv.checklist_type%type;
523: l_lease_app_id number;
524: l_lease_app_found boolean;
525: l_lease_app_list_found boolean;

Line 522: l_checklist_type okl_crd_fund_checklists_tpl_uv.checklist_type%type;

518: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE;
519: l_checklists_row_found boolean;
520: -- start: 23-May-2005 cklee okl.h Lease App IA Authoring |
521: l_function_id okl_crd_fund_checklists_tpl_uv.function_id%type;
522: l_checklist_type okl_crd_fund_checklists_tpl_uv.checklist_type%type;
523: l_lease_app_id number;
524: l_lease_app_found boolean;
525: l_lease_app_list_found boolean;
526: -- end: 23-May-2005 cklee okl.h Lease App IA Authoring |

Line 561: from okl_crd_fund_checklists_tpl_uv tpl

557: -- commented out tpl.STATUS
558: tpl.FUNCTION_ID,
559: tpl.CHECKLIST_TYPE
560: -- end: 23-May-2005 cklee okl.h Lease App IA Authoring |
561: from okl_crd_fund_checklists_tpl_uv tpl
562: where tpl.khr_id = p_credit_id
563: ;
564:
565: -- start: 23-May-2005 cklee okl.h Lease App IA Authoring |

Line 2967: l_status okl_crd_fund_checklists_tpl_uv.STATUS%TYPE;

2963: l_template_row_not_found boolean;
2964:
2965: l_dummy number;
2966: l_chklist_sts_row_found boolean;
2967: l_status okl_crd_fund_checklists_tpl_uv.STATUS%TYPE;
2968: l_fund_cls_tpl_exp_found boolean := false;
2969:
2970: l_credit_id okc_k_headers_b.id%TYPE;
2971: -- start: 23-May-2005 cklee okl.h Lease App IA Authoring |

Line 2980: from okl_crd_fund_checklists_tpl_uv tpl

2976: -- have checklist template setup
2977: ---------------------------------------------------------------------------------------------------------
2978: cursor c_chk_tpl (p_credit_id number) is
2979: select tpl.status
2980: from okl_crd_fund_checklists_tpl_uv tpl
2981: where tpl.khr_id = p_credit_id
2982: ;
2983:
2984: ---------------------------------------------------------------------------------------------------