APPS.OKE_CONTRACT_PUB dependencies on OKC_K_LINES_B

Line 1216: UPDATE OKC_K_LINES_B

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

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

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

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

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

Line 4153: select id from okc_k_lines_b

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