APPS.OKE_IMPORT_CONTRACT_PUB dependencies on OKE_K_LINES

Line 28: G_VIEW CONSTANT VARCHAR2(200) := 'OKE_K_LINES_V';

24: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_UNEXPECTED_ERROR';
25:
26: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
27: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
28: G_VIEW CONSTANT VARCHAR2(200) := 'OKE_K_LINES_V';
29:
30: G_EXCEPTION_HALT_VALIDATION exception;
31:
32:

Line 231: from oke_k_lines_v

227: IS
228:
229: CURSOR c_dates IS
230: select max(start_date), min(end_date)
231: from oke_k_lines_v
232: where k_line_id in (select cle_id_ascendant from okc_ancestrys
233: where cle_id = p_line_id) ;
234:
235:

Line 310: update oke_k_lines

306: END IF;
307:
308: IF p_diff <> 0 OR p_diff_u <> 0 THEN
309: IF p_parent_id IS NOT NULL THEN
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

Line 346: from oke_k_lines_v

342: l_exit NUMBER := 0;
343:
344: cursor parent_cursor(l_id NUMBER) is
345: select start_date, end_date
346: from oke_k_lines_v
347: where k_line_id = l_id;
348:
349: cursor child_cursor(l_id NUMBER) is
350: select start_date, end_date

Line 351: from oke_k_lines_v

347: where k_line_id = l_id;
348:
349: cursor child_cursor(l_id NUMBER) is
350: select start_date, end_date
351: from oke_k_lines_v
352: where k_line_id in
353: (
354: select cle_id from okc_ancestrys
355: where cle_id_ascendant=l_id

Line 3236: select 'x' from oke_k_lines_v

3232:
3233: l_header_id NUMBER;
3234:
3235: CURSOR c_check (p_header_id NUMBER, p_code VARCHAR2) IS
3236: select 'x' from oke_k_lines_v
3237: where billing_method_code = p_code
3238: and header_id = p_header_id;
3239:
3240: l_check VARCHAR2(1) := '?';

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 3598: update oke_k_lines

3594: END IF;
3595:
3596: -- 5. Update the total amounts the parent and the header
3597: -- line_value_total undef_line_value_total
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

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 3872: -- Get the following fields from the OKE_K_LINES

3868:
3869:
3870:
3871: /* Adding missing validations */
3872: -- Get the following fields from the OKE_K_LINES
3873: OPEN c_line_exists;
3874: FETCH c_line_exists INTO l_chr_id,l_cle_id,l_sts_code,l_lse_id,l_export_flag,
3875: l_PROGRESS_PAYMENT_FLAG,l_start_date,l_end_date,l_proposal_due_date,l_delivery_date
3876: ,l_line_quantity,l_unit_price,l_undef_unit_price,l_oval,l_oval_u