APPS.OKE_IMPORT_CONTRACT_PUB dependencies on OKC_K_LINES_B

Line 292: FROM okc_k_lines_b

288: PROCEDURE update_line_total(p_chr_id NUMBER, p_line_id NUMBER, p_parent_id NUMBER, p_diff NUMBER, p_diff_u NUMBER ) IS
289: l_chld_exist VARCHAR2(1) := '?';
290: CURSOR c_children IS
291: SELECT '!'
292: FROM okc_k_lines_b
293: WHERE cle_id = p_LINE_ID;
294: BEGIN
295:
296: OPEN c_children;

Line 314: SELECT id FROM okc_k_lines_b

310: update oke_k_lines
311: set line_value_total = Nvl(line_value_total,0) - Nvl(p_diff,0),
312: undef_line_value_total = Nvl(undef_line_value_total,0) - Nvl(p_diff_u,0)
313: where k_line_id IN (
314: SELECT id FROM okc_k_lines_b
315: WHERE id IS NOT NULL
316: START WITH id = p_parent_id
317: CONNECT BY PRIOR CLE_ID = ID);
318: END IF;

Line 562: select 'X' from okc_k_lines_b

558: FUNCTION CHILD_LINE_EXISTS(p_contract_line_id NUMBER)
559: RETURN VARCHAR2 IS
560:
561: cursor c is
562: select 'X' from okc_k_lines_b
563: where cle_id = p_contract_line_id;
564:
565: l_value VARCHAR2(1);
566: l_found boolean;

Line 3540: FROM okc_k_lines_b cl, oke_k_lines l, oke_k_headers kh

3536: l.undef_line_value_total
3537: INTO L_sts_code, L_object_version_number
3538: ,l_chr_id,l_line_value_total,
3539: l_undef_line_value_total
3540: FROM okc_k_lines_b cl, oke_k_lines l, oke_k_headers kh
3541: WHERE cl.id=l.k_line_id
3542: AND kh.k_header_id=cl.dnz_chr_id
3543: and l.k_line_id=p_contract_line_id;
3544: EXCEPTION

Line 3602: SELECT id FROM okc_k_lines_b

3598: update oke_k_lines
3599: set line_value_total = Nvl(line_value_total,0) - Nvl(l_line_value_total,0),
3600: undef_line_value_total = Nvl(undef_line_value_total,0) - Nvl(l_undef_line_value_total,0)
3601: where k_line_id IN (
3602: SELECT id FROM okc_k_lines_b
3603: WHERE id IS NOT NULL
3604: START WITH id = p_contract_line_id
3605: CONNECT BY PRIOR CLE_ID = ID );
3606:

Line 3785: FROM okc_k_lines_b cl , oke_k_lines el

3781: SELECT cl.dnz_chr_id,cl.cle_id,cl.sts_code,cl.lse_id, el.export_flag
3782: ,el.PROGRESS_PAYMENT_FLAG,cl.start_date,cl.end_date,el.proposal_due_date, el.delivery_date
3783: ,el.line_quantity,el.unit_price, el.undef_unit_price,el.line_value, el.undef_line_value
3784: ,el.line_value_total,el.undef_line_value_total
3785: FROM okc_k_lines_b cl , oke_k_lines el
3786: WHERE cl.id= p_cle_rec.k_line_id
3787: AND el.k_line_id=cl.id;
3788:
3789: l_chr_id NUMBER;

Line 3817: from OKC_K_LINES_B

3813:
3814:
3815: CURSOR c (p_number varchar2, p_cle_id NUMBER) is
3816: select 'x'
3817: from OKC_K_LINES_B
3818: WHERE LINE_NUMBER = p_number
3819: AND id<>p_cle_id
3820: AND ( cle_id = l_cle_id
3821: OR (cle_id is null AND l_cle_id is null))

Line 6338: select okl.sts_code from okc_k_lines_b okl , oke_k_deliverables_b okb

6334: procedure check_opn_code (p_deliverable_id in number,
6335: x_return_status out nocopy varchar2 ) is
6336:
6337: cursor c(p_deliverable_id Number) IS
6338: select okl.sts_code from okc_k_lines_b okl , oke_k_deliverables_b okb
6339: where okl.id = okb.k_line_id
6340: and okb.deliverable_id=p_deliverable_id;
6341:
6342: cursor opn_csr(p_sts_code varchar2, p_opn_code varchar2) is