APPS.OKL_COPY_ASSET_PVT dependencies on OKC_K_HEADERS_V

Line 69: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';

65: G_ID2 CONSTANT VARCHAR2(200) := '#';
66: G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';
67: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
68: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
69: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
70: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
71: -- G_FA_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE ASSET LINES';
72: -- G_IB_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE_IB_LINES';
73: G_TRY_NAME OKL_TRX_TYPES_TL.NAME%TYPE := 'Internal Asset Creation';

Line 70: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';

66: G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';
67: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
68: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
69: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
70: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
71: -- G_FA_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE ASSET LINES';
72: -- G_IB_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE_IB_LINES';
73: G_TRY_NAME OKL_TRX_TYPES_TL.NAME%TYPE := 'Internal Asset Creation';
74: G_LANGUAGE OKL_TRX_TYPES_TL.LANGUAGE%TYPE := 'US';

Line 5784: CURSOR h_new_link_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

5780: AND cle.lse_id = lse.id
5781: AND lse.lse_parent_id is null
5782: AND lse.lse_type = G_TLS_TYPE;
5783:
5784: CURSOR h_new_link_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5785: SELECT 'Y'
5786: FROM okc_k_rel_objs
5787: WHERE chr_id = p_chr_id
5788: AND cle_id IS NULL

Line 5792: CURSOR h_old_link_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

5788: AND cle_id IS NULL
5789: AND rty_code = 'OKLSRV'
5790: AND jtot_object1_code = 'OKL_SERVICE';
5791:
5792: CURSOR h_old_link_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5793: SELECT cle_id,
5794: chr_id,
5795: rty_code,
5796: object1_id1,

Line 5838: CURSOR copy_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

5834: AND rel.jtot_object1_code = 'OKL_COV_PROD'
5835: AND rel.cle_id = line.id
5836: AND line.cle_id = p_srv_top_line_id;
5837:
5838: CURSOR copy_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
5839: p_line_id OKC_K_LINES_V.ID%TYPE) IS
5840: SELECT id
5841: FROM okc_k_lines_b
5842: WHERE orig_system_id1 = p_line_id

Line 6049: CURSOR h_context_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

6045: --AND new_lnk_cle.cle_id = p_cle_id;
6046: AND new_lnk_cle.id = p_cle_id;
6047:
6048: -- Get contract context
6049: CURSOR h_context_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
6050: SELECT authoring_org_id,
6051: inv_organization_id
6052: FROM okc_k_headers_b
6053: WHERE id = p_chr_id;

Line 6055: l_auth_org_id OKC_K_HEADERS_V.AUTHORING_ORG_ID%TYPE;

6051: inv_organization_id
6052: FROM okc_k_headers_b
6053: WHERE id = p_chr_id;
6054:
6055: l_auth_org_id OKC_K_HEADERS_V.AUTHORING_ORG_ID%TYPE;
6056: l_inv_org_id OKC_K_HEADERS_V.INV_ORGANIZATION_ID%TYPE;
6057:
6058: BEGIN
6059: OKL_API.init_msg_list(p_init_msg_list);

Line 6056: l_inv_org_id OKC_K_HEADERS_V.INV_ORGANIZATION_ID%TYPE;

6052: FROM okc_k_headers_b
6053: WHERE id = p_chr_id;
6054:
6055: l_auth_org_id OKC_K_HEADERS_V.AUTHORING_ORG_ID%TYPE;
6056: l_inv_org_id OKC_K_HEADERS_V.INV_ORGANIZATION_ID%TYPE;
6057:
6058: BEGIN
6059: OKL_API.init_msg_list(p_init_msg_list);
6060: -- Make sure PL/SQL table has records in it before passing