eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_COPY_CONTRACT_PVT dependencies on OKC_K_HEADERS_V

Line 81: --Functions to fetch data from okc_k_headers_v, okc_k_lines_v,

77: End Loop;
78: Return l_lines_tbl;
79: END migrate_lines_tbl;
80: --------------------------------------------------------------------------
81: --Functions to fetch data from okc_k_headers_v, okc_k_lines_v,
82: --okl_k_headers_v and okl_k_lines_v
83: --These Functions are copy of local functions get_rec in
84: --OKC_CHR_PVT and OKL_KHR_PVT. These are repeated here since they have not
85: --been published. Any changes in in these in the original packages will

Line 89: -- FUNCTION get_rec for: OKC_K_HEADERS_V

85: --been published. Any changes in in these in the original packages will
86: --also heve to be done here.
87: ----------------------------------------------------------------------------
88: ---------------------------------------------------------------------------
89: -- FUNCTION get_rec for: OKC_K_HEADERS_V
90: ---------------------------------------------------------------------------
91: FUNCTION get_chrv_rec (
92: p_chrv_id IN NUMBER,
93: x_no_data_found OUT NOCOPY BOOLEAN

Line 201: FROM Okc_K_Headers_V

197: ,RENEWAL_NOTIFY_TO
198: ,RENEWAL_END_DATE
199: ,SHIP_TO_SITE_USE_ID
200: ,PAYMENT_TERM_ID
201: FROM Okc_K_Headers_V
202: WHERE okc_k_headers_v.id = p_id;
203: l_okc_chrv_pk okc_chrv_pk_csr%ROWTYPE;
204: l_chrv_rec chrv_rec_type;
205: BEGIN

Line 202: WHERE okc_k_headers_v.id = p_id;

198: ,RENEWAL_END_DATE
199: ,SHIP_TO_SITE_USE_ID
200: ,PAYMENT_TERM_ID
201: FROM Okc_K_Headers_V
202: WHERE okc_k_headers_v.id = p_id;
203: l_okc_chrv_pk okc_chrv_pk_csr%ROWTYPE;
204: l_chrv_rec chrv_rec_type;
205: BEGIN
206: x_no_data_found := TRUE;

Line 2193: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

2189: PROCEDURE sync_slh_sll(
2190: x_return_status OUT NOCOPY VARCHAR2,
2191: x_msg_count OUT NOCOPY NUMBER,
2192: x_msg_data OUT NOCOPY VARCHAR2,
2193: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2194: p_old_rgp_id IN NUMBER,
2195: p_new_rgp_id IN NUMBER
2196: ) IS
2197:

Line 2227: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,

2223: SELECT orig_system_id1
2224: FROM okc_k_lines_v
2225: WHERE id = p_cle_id;
2226:
2227: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2228: p_rgp_id NUMBER) IS
2229: SELECT id
2230: FROM okc_rule_groups_v
2231: WHERE dnz_chr_id = p_chr_id

Line 2387: p_old_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

2383: PROCEDURE link_slh_sll(
2384: x_return_status OUT NOCOPY VARCHAR2,
2385: x_msg_count OUT NOCOPY NUMBER,
2386: x_msg_data OUT NOCOPY VARCHAR2,
2387: p_old_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2388: p_new_cle_id IN OKC_K_LINES_V.ID%TYPE,
2389: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2390: ) IS
2391:

Line 2389: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE

2385: x_msg_count OUT NOCOPY NUMBER,
2386: x_msg_data OUT NOCOPY VARCHAR2,
2387: p_old_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2388: p_new_cle_id IN OKC_K_LINES_V.ID%TYPE,
2389: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2390: ) IS
2391:
2392: link_failed EXCEPTION;
2393:

Line 2394: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

2390: ) IS
2391:
2392: link_failed EXCEPTION;
2393:
2394: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2395: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2396: SELECT id,
2397: cle_id
2398: FROM okc_rule_groups_v

Line 2403: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

2399: WHERE dnz_chr_id = p_chr_id
2400: AND cle_id = p_cle_id
2401: AND rgd_code = 'LALEVL';
2402:
2403: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2404: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2405: SELECT id
2406: FROM okc_rule_groups_v
2407: WHERE dnz_chr_id = p_chr_id

Line 2476: p_old_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

2472: PROCEDURE link_slh_sll(
2473: x_return_status OUT NOCOPY VARCHAR2,
2474: x_msg_count OUT NOCOPY NUMBER,
2475: x_msg_data OUT NOCOPY VARCHAR2,
2476: p_old_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2477: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2478: ) IS
2479:
2480: link_failed EXCEPTION;

Line 2477: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE

2473: x_return_status OUT NOCOPY VARCHAR2,
2474: x_msg_count OUT NOCOPY NUMBER,
2475: x_msg_data OUT NOCOPY VARCHAR2,
2476: p_old_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2477: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2478: ) IS
2479:
2480: link_failed EXCEPTION;
2481:

Line 2482: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

2478: ) IS
2479:
2480: link_failed EXCEPTION;
2481:
2482: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
2483: SELECT id,
2484: cle_id
2485: FROM okc_rule_groups_v
2486: WHERE dnz_chr_id = p_chr_id

Line 2490: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

2486: WHERE dnz_chr_id = p_chr_id
2487: AND cle_id IS NULL -- Bug 2376998
2488: AND rgd_code = 'LALEVL';
2489:
2490: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2491: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2492: SELECT id
2493: FROM okc_rule_groups_v
2494: WHERE dnz_chr_id = p_chr_id

Line 3343: l_old_chr_id OKC_K_HEADERS_V.ID%TYPE;

3339: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_CONTRACT_LINES';
3340: l_api_version CONSTANT NUMBER := 1.0;
3341: l_clev_rec_out clev_rec_type;
3342: x_klev_rec_out klev_rec_type;
3343: l_old_chr_id OKC_K_HEADERS_V.ID%TYPE;
3344: CURSOR c_lines(p_from_cle_id NUMBER) IS
3345: SELECT level,
3346: id,
3347: chr_id,