APPS.OKE_CONTRACT_PUB dependencies on OKC_K_LINES_B

Line 1215: UPDATE OKC_K_LINES_B

1211:
1212:
1213: -- update the original line number instead of OKC generated line number
1214:
1215: UPDATE OKC_K_LINES_B
1216: SET line_number = l_line_number
1217: WHERE ID = l_cle_rec.K_LINE_ID;
1218:
1219: -- prepare the OUT NOCOPY /* file.sql.39 change */ okc rec to reflact the update

Line 3224: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)

3220: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
3221: where h.id = p_id
3222: and l.header_id = p_id
3223: and h.id = k.k_header_id
3224: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)
3225: and exists (select 'x' from okc_assents a
3226: where a.opn_code = 'CREATE_DELV'
3227: and a.sts_code = l.status_code
3228: and a.scs_code = 'PROJECT'

Line 3268: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)

3264: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
3265: where h.id = p_id
3266: and l.header_id = p_id
3267: and h.id = k.k_header_id
3268: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)
3269: and not exists (select 'x' from oke_k_deliverables_b where k_line_id = l.k_line_id)
3270: and exists (select 'x' from okc_assents a
3271: where a.opn_code = 'CREATE_DELV'
3272: and a.sts_code = l.status_code

Line 4151: select id from okc_k_lines_b

4147: l_doc_id NUMBER;
4148: l_doc_type VARCHAR2(30);
4149:
4150: cursor c_cle is
4151: select id from okc_k_lines_b
4152: where dnz_chr_id = p_chr_id;
4153:
4154: cursor c_item is
4155: select id