APPS.OKE_KCOPY_PKG dependencies on OKC_K_LINES_B

Line 131: from okc_k_lines_b

127: l_api_version constant number := 1.0;
128:
129: cursor c_dnz_chr_id is
130: select dnz_chr_id,price_level_ind
131: from okc_k_lines_b
132: where id = p_to_cle_id;
133:
134: cursor c_cimv is
135: select id

Line 751: f_k_line_id in number, -- orig okc_k_lines_b.id

747: x_msg_count out nocopy number,
748: x_msg_data out nocopy varchar2,
749: f_k_header_id in number, -- orig okc_k_headers_b.id
750: n_k_header_id in number, -- new okc_k_headers_b.id
751: f_k_line_id in number, -- orig okc_k_lines_b.id
752: n_k_line_id in number, -- new okc_k_lines_b.id
753: p_k_header_id in number -- original header id, must provide, cannot be null
754: ) is
755:

Line 752: n_k_line_id in number, -- new okc_k_lines_b.id

748: x_msg_data out nocopy varchar2,
749: f_k_header_id in number, -- orig okc_k_headers_b.id
750: n_k_header_id in number, -- new okc_k_headers_b.id
751: f_k_line_id in number, -- orig okc_k_lines_b.id
752: n_k_line_id in number, -- new okc_k_lines_b.id
753: p_k_header_id in number -- original header id, must provide, cannot be null
754: ) is
755:
756: x_pty_id number; -- new party id returned from api call

Line 924: f_k_line_id IN NUMBER, -- Orig OKC_K_LINES_B.id

920: x_msg_count OUT NOCOPY NUMBER,
921: x_msg_data OUT NOCOPY VARCHAR2,
922: f_k_header_id IN NUMBER, -- Orig OKC_K_HEADERS_B.id
923: n_k_header_id IN NUMBER, -- New OKC_K_HEADERS_B.id
924: f_k_line_id IN NUMBER, -- Orig OKC_K_LINES_B.id
925: n_k_line_id IN NUMBER -- New OKC_K_LINES_B.id
926: ) IS
927:
928: l_cat_id NUMBER; -- Old ARTICLE ID

Line 925: n_k_line_id IN NUMBER -- New OKC_K_LINES_B.id

921: x_msg_data OUT NOCOPY VARCHAR2,
922: f_k_header_id IN NUMBER, -- Orig OKC_K_HEADERS_B.id
923: n_k_header_id IN NUMBER, -- New OKC_K_HEADERS_B.id
924: f_k_line_id IN NUMBER, -- Orig OKC_K_LINES_B.id
925: n_k_line_id IN NUMBER -- New OKC_K_LINES_B.id
926: ) IS
927:
928: l_cat_id NUMBER; -- Old ARTICLE ID
929: x_cat_id NUMBER; -- New ARTICLE ID

Line 2411: FROM okc_k_lines_b

2407: l_amount_u NUMBER;
2408:
2409: CURSOR l_lines IS
2410: SELECT id
2411: FROM okc_k_lines_b
2412: WHERE dnz_chr_id = p_chr_id
2413: AND ( cle_id = p_cle_id AND p_cle_id IS NOT NULL
2414: OR cle_id IS NULL AND p_cle_id IS NULL);
2415: