DBA Data[Home] [Help]

APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKC_K_ITEMS

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

2337: l_order_by_clause varchar2(2000) default null;
2338: l_query_string varchar2(2000) default null;
2339:
2340:
2341: l_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
2342: l_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
2343: l_name VARCHAR2(250) Default Null;
2344: l_description VARCHAR2(250) Default Null;
2345: l_object_code VARCHAR2(30) Default Null;

Line 2342: l_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;

2338: l_query_string varchar2(2000) default null;
2339:
2340:
2341: l_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
2342: l_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
2343: l_name VARCHAR2(250) Default Null;
2344: l_description VARCHAR2(250) Default Null;
2345: l_object_code VARCHAR2(30) Default Null;
2346:

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

3404: l_where_clause varchar2(2000) default null;
3405: l_order_by_clause varchar2(2000) default null;
3406: l_query_string varchar2(2000) default null;
3407:
3408: l_item_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
3409: l_item_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
3410: l_item_name VARCHAR2(250) Default Null;
3411:
3412: l_item_description VARCHAR2(250) Default Null;

Line 3409: l_item_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;

3405: l_order_by_clause varchar2(2000) default null;
3406: l_query_string varchar2(2000) default null;
3407:
3408: l_item_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
3409: l_item_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
3410: l_item_name VARCHAR2(250) Default Null;
3411:
3412: l_item_description VARCHAR2(250) Default Null;
3413: l_item_object_code VARCHAR2(30) Default Null;

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

3413: l_item_object_code VARCHAR2(30) Default Null;
3414:
3415:
3416:
3417: l_item_id11 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
3418: l_item_id22 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
3419:
3420:
3421:

Line 3418: l_item_id22 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;

3414:
3415:
3416:
3417: l_item_id11 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
3418: l_item_id22 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
3419:
3420:
3421:
3422: l_party_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;

Line 3459: from okc_k_items cim

3455: CURSOR check_item_csr(p_chr_id NUMBER, p_lty_code VARCHAR2, p_id1 VARCHAR2, p_id2 VARCHAR2) IS
3456:
3457: select count(1)
3458:
3459: from okc_k_items cim
3460: , okc_k_lines_b cle
3461: , okc_line_style_sources lss
3462: , okc_line_styles_b lse
3463: where nvl(lss.start_date,sysdate) <= sysdate

Line 3478: from okc_k_items cim

3474:
3475:
3476: CURSOR get_item_csr(p_chr_id NUMBER, p_cle_id NUMBER) IS
3477: SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
3478: from okc_k_items cim
3479: , okc_k_lines_b cle
3480: , okc_line_style_sources lss
3481: , okc_line_styles_b lse
3482: where nvl(lss.start_date,sysdate) <= sysdate

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

4986: l_order_by_clause varchar2(2000) default null;
4987: l_query_string varchar2(2000) default null;
4988:
4989:
4990: l_item_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
4991: l_item_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
4992: l_item_name VARCHAR2(250) Default Null;
4993: l_item_description VARCHAR2(250) Default Null;
4994: l_item_object_code VARCHAR2(30) Default Null;

Line 4991: l_item_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;

4987: l_query_string varchar2(2000) default null;
4988:
4989:
4990: l_item_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
4991: l_item_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
4992: l_item_name VARCHAR2(250) Default Null;
4993: l_item_description VARCHAR2(250) Default Null;
4994: l_item_object_code VARCHAR2(30) Default Null;
4995:

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

4994: l_item_object_code VARCHAR2(30) Default Null;
4995:
4996:
4997:
4998: l_item_id11 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
4999: l_item_id22 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
5000:
5001:
5002:

Line 4999: l_item_id22 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;

4995:
4996:
4997:
4998: l_item_id11 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
4999: l_item_id22 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
5000:
5001:
5002:
5003: l_service_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

Line 5032: from okc_k_items cim

5028: CURSOR check_item_csr(p_chr_id NUMBER, p_lty_code VARCHAR2, p_id1 VARCHAR2, p_id2 VARCHAR2) IS
5029:
5030: select count(1)
5031:
5032: from okc_k_items cim
5033: , okc_k_lines_b cle
5034: , okc_line_style_sources lss
5035: , okc_line_styles_b lse
5036: where nvl(lss.start_date,sysdate) <= sysdate

Line 5052: from okc_k_items cim

5048:
5049: CURSOR get_item_csr(p_chr_id NUMBER, p_cle_id NUMBER) IS
5050:
5051: SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
5052: from okc_k_items cim
5053: , okc_k_lines_b cle
5054: , okc_line_style_sources lss
5055: , okc_line_styles_b lse
5056: where nvl(lss.start_date,sysdate) <= sysdate