APPS.OKL_VP_EXTEND_PVT dependencies on OKC_K_HEADERS_B

Line 22: FROM okc_k_headers_b

18: template_yn,
19: date_terminated,
20: date_renewed,
21: end_date
22: FROM okc_k_headers_b
23: WHERE id = p_extend_in_parameters_rec.p_contract_id;
24:
25: CURSOR is_k_locked is
26: SELECT 'Y'

Line 181: l_end_date okc_k_headers_b.end_date%TYPE;

177: l_sts_code VARCHAR2(100);
178: l_cls_code VARCHAR2(100);
179: l_template_yn VARCHAR2(10);
180: l_code VARCHAR2(100);
181: l_end_date okc_k_headers_b.end_date%TYPE;
182: l_app_id okc_k_headers_b.application_id%TYPE;
183: l_scs_code okc_k_headers_b.scs_code%TYPE;
184: l_k VARCHAR2(255);
185: l_mod okc_k_headers_b.contract_number_modifier%TYPE DEFAULT OKC_API.G_MISS_CHAR;

Line 182: l_app_id okc_k_headers_b.application_id%TYPE;

178: l_cls_code VARCHAR2(100);
179: l_template_yn VARCHAR2(10);
180: l_code VARCHAR2(100);
181: l_end_date okc_k_headers_b.end_date%TYPE;
182: l_app_id okc_k_headers_b.application_id%TYPE;
183: l_scs_code okc_k_headers_b.scs_code%TYPE;
184: l_k VARCHAR2(255);
185: l_mod okc_k_headers_b.contract_number_modifier%TYPE DEFAULT OKC_API.G_MISS_CHAR;
186: l_return_value VARCHAR2(1) := 'Y';

Line 183: l_scs_code okc_k_headers_b.scs_code%TYPE;

179: l_template_yn VARCHAR2(10);
180: l_code VARCHAR2(100);
181: l_end_date okc_k_headers_b.end_date%TYPE;
182: l_app_id okc_k_headers_b.application_id%TYPE;
183: l_scs_code okc_k_headers_b.scs_code%TYPE;
184: l_k VARCHAR2(255);
185: l_mod okc_k_headers_b.contract_number_modifier%TYPE DEFAULT OKC_API.G_MISS_CHAR;
186: l_return_value VARCHAR2(1) := 'Y';
187:

Line 185: l_mod okc_k_headers_b.contract_number_modifier%TYPE DEFAULT OKC_API.G_MISS_CHAR;

181: l_end_date okc_k_headers_b.end_date%TYPE;
182: l_app_id okc_k_headers_b.application_id%TYPE;
183: l_scs_code okc_k_headers_b.scs_code%TYPE;
184: l_k VARCHAR2(255);
185: l_mod okc_k_headers_b.contract_number_modifier%TYPE DEFAULT OKC_API.G_MISS_CHAR;
186: l_return_value VARCHAR2(1) := 'Y';
187:
188:
189: CURSOR c_chr IS

Line 192: FROM okc_k_headers_b

188:
189: CURSOR c_chr IS
190: SELECT sts_code,template_yn,end_date,application_id,scs_code ,contract_number,
191: contract_number_modifier
192: FROM okc_k_headers_b
193: WHERE id = p_chr_id;
194:
195: CURSOR c_sts(p_code IN VARCHAR2) IS
196: SELECT ste_code