APPS.OKC_EXTEND_PVT dependencies on OKC_STATUSES_V

Line 257: FROM okc_statuses_v

253: WHERE code = p_sts_code;
254:
255: CURSOR cur_mean(p_sts_code varchar2) is
256: SELECT meaning
257: FROM okc_statuses_v
258: WHERE code = p_sts_code;
259:
260: l_chg_request_in_process varchar2(1);
261: l_status varchar2(30);

Line 262: l_status_meaning okc_statuses_v.meaning%type;

258: WHERE code = p_sts_code;
259:
260: l_chg_request_in_process varchar2(1);
261: l_status varchar2(30);
262: l_status_meaning okc_statuses_v.meaning%type;
263: l_return_status varchar2(1) := OKC_API.g_ret_sts_success;
264: l_chr_rec cur_k_header%rowtype;
265:
266: BEGIN

Line 424: FROM okc_statuses_v

420: AND cle.sts_code = sts.code;
421:
422: CURSOR cur_mean(p_sts_code varchar2) is
423: SELECT meaning
424: FROM okc_statuses_v
425: WHERE code = p_sts_code;
426:
427: Cursor cur_k_end_date(p_id number) is
428: SELECT end_date+1 from okc_k_headers_b

Line 435: l_status_meaning okc_statuses_v.meaning%type;

431: k_lines_rec cur_k_lines%rowtype;
432:
433: l_return_status varchar2(1) := OKC_API.g_ret_sts_success;
434:
435: l_status_meaning okc_statuses_v.meaning%type;
436: l_extend_in_parameters_rec extend_in_parameters_rec;
437:
438: BEGIN
439: --dbms_output.put_line('validate cle (+) ');

Line 633: l_status_code okc_statuses_v.ste_code%type;

629: i_cle_rec okc_contract_pub.clev_rec_type;
630:
631: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
632: l_api_name constant varchar2(30) := 'update_enddate';
633: l_status_code okc_statuses_v.ste_code%type;
634:
635: BEGIN
636:
637: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1226: l_ste_code okc_statuses_v.ste_code%type;

1222: SELECT ste_code
1223: FROM okc_statuses_b
1224: WHERE code = p_sts_code;
1225:
1226: l_ste_code okc_statuses_v.ste_code%type;
1227:
1228: -- Added for providing extend callout - from header - Bug 2346862/2648677
1229: -- Cursor created to get the PDF_ID for Class 'SERVICE'
1230: --CURSOR c_pdf IS

Line 1523: CURSOR cur_status (p_sts_code okc_statuses_v.code%type) is

1519: CONNECT BY PRIOR id = cle_id
1520: ORDER BY LEVEL asc
1521: FOR UPDATE OF id NOWAIT;
1522:
1523: CURSOR cur_status (p_sts_code okc_statuses_v.code%type) is
1524: SELECT ste_code
1525: FROM okc_statuses_b
1526: WHERE code = p_sts_code;
1527:

Line 1548: l_status_code okc_statuses_v.code%type;

1544: l_price_negotiated number;
1545: i_cle_rec okc_contract_pub.clev_rec_type;
1546: l_cle_rec okc_contract_pub.clev_rec_type;
1547: l_status varchar2(30);
1548: l_status_code okc_statuses_v.code%type;
1549:
1550:
1551: -- Added for providing extend callout - from Line
1552: -- Cursor created to get the PDF_ID for Class 'SERVICE' - Bug 2648677/2346862