APPS.OKL_CHECKLIST_PVT dependencies on OKL_CHECKLISTS_UV

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