APPS.OKL_VENDOR_PROGRAM_PVT dependencies on OKC_ROLE_SOURCES

Line 31: FROM okc_role_sources rs, okc_subclass_roles sr

27:
28: --Murthy Added Cursors for JTOT OBJECT CODE and check for CONTRACT ID
29: CURSOR cur_jtot_object_code(p_rle_code IN VARCHAR2, p_scs_code IN VARCHAR2, p_buy_or_sell IN VARCHAR2) IS
30: SELECT jtot_object_code
31: FROM okc_role_sources rs, okc_subclass_roles sr
32: WHERE rs.rle_code = sr.rle_code AND SYSDATE BETWEEN rs.start_date AND NVL(rs.end_date,SYSDATE)
33: AND SYSDATE BETWEEN sr.start_date AND NVL(sr.end_date,SYSDATE)
34: AND rs.rle_code = p_rle_code
35: AND rs.buy_or_sell = p_buy_or_sell AND sr.scs_code = p_scs_code;

Line 117: FROM okc_role_sources rs, okc_subclass_roles sr

113:
114: /* --Murthy Added Cursors for JTOT OBJECT CODE and check for CONTRACT ID
115: CURSOR cur_jtot_object_code(p_rle_code IN VARCHAR2, p_scs_code IN VARCHAR2, p_buy_or_sell IN VARCHAR2) IS
116: SELECT jtot_object_code
117: FROM okc_role_sources rs, okc_subclass_roles sr
118: WHERE rs.rle_code = sr.rle_code AND SYSDATE BETWEEN rs.start_date AND NVL(rs.end_date,SYSDATE)
119: AND SYSDATE BETWEEN sr.start_date AND NVL(sr.end_date,SYSDATE)
120: AND rs.rle_code = p_rle_code
121: AND rs.buy_or_sell = p_buy_or_sell AND sr.scs_code = p_scs_code;

Line 138: from OKC_ROLE_SOURCES

134: -- to be removed as and when things are clarified.
135:
136: CURSOR role_csr(p_rle_code VARCHAR2) IS
137: Select access_level
138: from OKC_ROLE_SOURCES
139: where rle_code = p_rle_code
140: and buy_or_sell = 'S';
141:
142: --Manu : 14-Jun-2005

Line 149: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

145: SELECT id FROM OKC_QA_CHECK_LISTS_V WHERE name = p_qa_name;
146:
147: l_qa_id OKC_QA_CHECK_LISTS_V .id%TYPE := NULL;
148:
149: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;
150:
151: BEGIN
152:
153: /* l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name

Line 660: from OKC_ROLE_SOURCES

656: l_msg_data VARCHAR2(2000);
657:
658: CURSOR role_csr(p_rle_code VARCHAR2) IS
659: Select access_level
660: from OKC_ROLE_SOURCES
661: where rle_code = p_rle_code
662: and buy_or_sell = 'S';
663:
664: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

Line 664: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

660: from OKC_ROLE_SOURCES
661: where rle_code = p_rle_code
662: and buy_or_sell = 'S';
663:
664: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;
665:
666: --Added by abhsxen for bug 6487870
667: l_kplv_rec okl_kpl_pvt.kplv_rec_type;
668: x_kplv_rec okl_kpl_pvt.kplv_rec_type;

Line 1108: from OKC_ROLE_SOURCES

1104: l_return_value VARCHAR2(1) := 'N';
1105:
1106: CURSOR role_csr(p_rle_code VARCHAR2) IS
1107: Select access_level
1108: from OKC_ROLE_SOURCES
1109: where rle_code = p_rle_code
1110: and buy_or_sell = 'S';
1111:
1112: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

Line 1112: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

1108: from OKC_ROLE_SOURCES
1109: where rle_code = p_rle_code
1110: and buy_or_sell = 'S';
1111:
1112: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;
1113:
1114: /* Manu Bug #4671978 27-Oct-2005 Begin */
1115: CURSOR cl_get_gov_id(p_program_id OKC_K_HEADERS_V.ID%TYPE) IS
1116: SELECT ID FROM OKC_GOVERNANCES WHERE DNZ_CHR_ID = p_program_id;