2353: l_order_by_clause varchar2(2000) default null;
2354: l_query_string varchar2(2000) default null;
2355:
2356:
2357: l_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
2358: l_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
2359: l_name VARCHAR2(250) Default Null;
2360: l_description VARCHAR2(250) Default Null;
2361: l_object_code VARCHAR2(30) Default Null;
2354: l_query_string varchar2(2000) default null;
2355:
2356:
2357: l_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
2358: l_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
2359: l_name VARCHAR2(250) Default Null;
2360: l_description VARCHAR2(250) Default Null;
2361: l_object_code VARCHAR2(30) Default Null;
2362:
3420: l_where_clause varchar2(2000) default null;
3421: l_order_by_clause varchar2(2000) default null;
3422: l_query_string varchar2(2000) default null;
3423:
3424: l_item_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
3425: l_item_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
3426: l_item_name VARCHAR2(250) Default Null;
3427:
3428: l_item_description VARCHAR2(250) Default Null;
3421: l_order_by_clause varchar2(2000) default null;
3422: l_query_string varchar2(2000) default null;
3423:
3424: l_item_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
3425: l_item_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
3426: l_item_name VARCHAR2(250) Default Null;
3427:
3428: l_item_description VARCHAR2(250) Default Null;
3429: l_item_object_code VARCHAR2(30) Default Null;
3429: l_item_object_code VARCHAR2(30) Default Null;
3430:
3431:
3432:
3433: l_item_id11 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
3434: l_item_id22 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
3435:
3436:
3437:
3430:
3431:
3432:
3433: l_item_id11 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
3434: l_item_id22 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
3435:
3436:
3437:
3438: l_party_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
5002: l_order_by_clause varchar2(2000) default null;
5003: l_query_string varchar2(2000) default null;
5004:
5005:
5006: l_item_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
5007: l_item_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
5008: l_item_name VARCHAR2(250) Default Null;
5009: l_item_description VARCHAR2(250) Default Null;
5010: l_item_object_code VARCHAR2(30) Default Null;
5003: l_query_string varchar2(2000) default null;
5004:
5005:
5006: l_item_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
5007: l_item_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
5008: l_item_name VARCHAR2(250) Default Null;
5009: l_item_description VARCHAR2(250) Default Null;
5010: l_item_object_code VARCHAR2(30) Default Null;
5011:
5010: l_item_object_code VARCHAR2(30) Default Null;
5011:
5012:
5013:
5014: l_item_id11 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
5015: l_item_id22 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
5016:
5017:
5018:
5011:
5012:
5013:
5014: l_item_id11 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
5015: l_item_id22 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
5016:
5017:
5018:
5019: l_service_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;