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.

[Home] [Help]

APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKC_K_ITEMS

Line 2357: l_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;

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;

Line 2358: l_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE 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:

Line 3424: l_item_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;

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;

Line 3425: l_item_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE 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;

Line 3433: l_item_id11 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE 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:

Line 3434: l_item_id22 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE 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:
3438: l_party_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;

Line 3475: from okc_k_items cim

3471: CURSOR check_item_csr(p_chr_id NUMBER, p_lty_code VARCHAR2, p_id1 VARCHAR2, p_id2 VARCHAR2) IS
3472:
3473: select count(1)
3474:
3475: from okc_k_items cim
3476: , okc_k_lines_b cle
3477: , okc_line_style_sources lss
3478: , okc_line_styles_b lse
3479: where nvl(lss.start_date,sysdate) <= sysdate

Line 3494: from okc_k_items cim

3490:
3491:
3492: CURSOR get_item_csr(p_chr_id NUMBER, p_cle_id NUMBER) IS
3493: SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
3494: from okc_k_items cim
3495: , okc_k_lines_b cle
3496: , okc_line_style_sources lss
3497: , okc_line_styles_b lse
3498: where nvl(lss.start_date,sysdate) <= sysdate

Line 5006: l_item_id1 OKC_K_ITEMS_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;

Line 5007: l_item_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE 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:

Line 5014: l_item_id11 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;

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:

Line 5015: l_item_id22 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE 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:
5019: l_service_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

Line 5048: from okc_k_items cim

5044: CURSOR check_item_csr(p_chr_id NUMBER, p_lty_code VARCHAR2, p_id1 VARCHAR2, p_id2 VARCHAR2) IS
5045:
5046: select count(1)
5047:
5048: from okc_k_items cim
5049: , okc_k_lines_b cle
5050: , okc_line_style_sources lss
5051: , okc_line_styles_b lse
5052: where nvl(lss.start_date,sysdate) <= sysdate

Line 5068: from okc_k_items cim

5064:
5065: CURSOR get_item_csr(p_chr_id NUMBER, p_cle_id NUMBER) IS
5066:
5067: SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
5068: from okc_k_items cim
5069: , okc_k_lines_b cle
5070: , okc_line_style_sources lss
5071: , okc_line_styles_b lse
5072: where nvl(lss.start_date,sysdate) <= sysdate