APPS.OKE_KCOPY_PKG dependencies on OKE_K_LINES

Line 63: from oke_k_lines_v

59: when others then
60: -- store sql error message on message stack for caller
61:
62: select line_number into l_line_number
63: from oke_k_lines_v
64: where k_line_id=p_from_cle_id;
65: oke_api.set_message (
66: p_app_name =>'OKE',
67: p_msg_name =>'OKE_KCOPY_ITEMS',

Line 1329: FROM okc_K_Lines_V a, oke_k_lines b

1325: a.CURRENCY_CODE_RENEWED,
1326: a.LAST_UPDATE_LOGIN
1327:
1328:
1329: FROM okc_K_Lines_V a, oke_k_lines b
1330: WHERE a.cle_id = f_k_line_id AND a.id=b.k_line_id;
1331:
1332:
1333: BEGIN

Line 1768: oke_k_lines, okc_k_lines_v

1764:
1765:
1766: /*-------------------------------------------------------------------------
1767: PROCEDURE get_k_lines_rec - get OKE and OKC contract line information from
1768: oke_k_lines, okc_k_lines_v
1769: --------------------------------------------------------------------------*/
1770:
1771: PROCEDURE copy_contract_lines(p_api_version IN NUMBER,
1772: p_init_msg_list IN VARCHAR2,

Line 1968: FROM okc_K_Lines_V a, oke_k_lines b

1964: a.CURRENCY_CODE_RENEWED,
1965: a.LAST_UPDATE_LOGIN
1966:
1967:
1968: FROM okc_K_Lines_V a, oke_k_lines b
1969: WHERE a.chr_id = f_k_header_id AND a.id=b.k_line_id;
1970:
1971:
1972: BEGIN

Line 2430: FROM oke_k_lines

2426: -- the amounts are null if there is no sublines
2427: IF ( l_amount IS NULL AND l_amount_u IS NULL ) THEN
2428: SELECT Nvl(line_value,0), Nvl(undef_line_value,0)
2429: INTO l_amount, l_amount_u
2430: FROM oke_k_lines
2431: WHERE k_line_id = c.id;
2432: END IF;
2433:
2434: UPDATE oke_k_lines

Line 2434: UPDATE oke_k_lines

2430: FROM oke_k_lines
2431: WHERE k_line_id = c.id;
2432: END IF;
2433:
2434: UPDATE oke_k_lines
2435: SET line_value_total = l_amount, undef_line_value_total = l_amount_u
2436: WHERE k_line_id = c.id;
2437:
2438: x_total := Nvl(x_total,0) + l_amount;