DBA Data[Home] [Help]

APPS.OKL_SPLIT_CONTRACT_PVT dependencies on OKC_LINE_STYLES_V

Line 37: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';

33: -- GLOBAL VARIABLES
34: -------------------------------------------------------------------------------------------------
35: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SPLIT_CONTRACT_PVT';
36: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
37: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
38: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
39: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
40: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
41: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'SOLD_SERVICE';

Line 38: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';

34: -------------------------------------------------------------------------------------------------
35: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SPLIT_CONTRACT_PVT';
36: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
37: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
38: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
39: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
40: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
41: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'SOLD_SERVICE';
42: G_SRL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_SERV_ASSET';

Line 39: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';

35: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SPLIT_CONTRACT_PVT';
36: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
37: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
38: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
39: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
40: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
41: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'SOLD_SERVICE';
42: G_SRL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_SERV_ASSET';
43: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'FEE';

Line 40: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';

36: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
37: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
38: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
39: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
40: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
41: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'SOLD_SERVICE';
42: G_SRL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_SERV_ASSET';
43: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'FEE';
44: G_FEL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_FEE_ASSET';

Line 50: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';

46: G_USL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_USAGE_ASSET';
47:
48: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
49: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
50: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
51: G_DEBUG_SPLIT BOOLEAN := FALSE;
52: ----------------------------------------------------------------------------------------------------
53: SUBTYPE cimv_rec_type IS OKL_OKC_MIGRATION_PVT.cimv_rec_type;
54: SUBTYPE clev_rec_type IS OKL_OKC_MIGRATION_PVT.clev_rec_type;

Line 1157: OKC_LINE_STYLES_V lse,

1153: SELECT 1
1154: FROM DUAL
1155: WHERE EXISTS (SELECT 1
1156: FROM OKC_SUBCLASS_TOP_LINE stl,
1157: OKC_LINE_STYLES_V lse,
1158: OKC_K_LINES_V cle
1159: WHERE cle.id = p_top_line_id
1160: AND cle.dnz_chr_id = p_dnz_chr_id
1161: AND cle.cle_id IS NULL

Line 3380: OKC_LINE_STYLES_V lse,

3376: SELECT orig_system_id1 orig_cle_fa,
3377: txl.tas_id tas_id_fa,
3378: cle.id id
3379: FROM OKC_K_LINES_V cle,
3380: OKC_LINE_STYLES_V lse,
3381: OKL_TXL_ASSETS_B txl
3382: WHERE cle.dnz_chr_id = p_chr_id
3383: AND cle.lse_id = lse.id
3384: AND lse.lty_code = G_FA_LINE_LTY_CODE

Line 3393: OKC_LINE_STYLES_V lse,

3389: SELECT orig_system_id1 orig_cle_ib,
3390: iti.tas_id tas_id_ib,
3391: cle.id id
3392: FROM OKC_K_LINES_V cle,
3393: OKC_LINE_STYLES_V lse,
3394: OKL_TXL_ITM_INSTS iti
3395: WHERE cle.dnz_chr_id = p_chr_id
3396: AND cle.lse_id = lse.id
3397: AND lse.lty_code = G_IB_LINE_LTY_CODE

Line 4136: OKC_LINE_STYLES_V lse,

4132:
4133: CURSOR c_old_top_line_cnt(p_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE) IS
4134: SELECT COUNT(cle.id)
4135: FROM OKC_SUBCLASS_TOP_LINE stl,
4136: OKC_LINE_STYLES_V lse,
4137: OKC_K_LINES_V cle,
4138: OKC_K_HEADERS_V chrv
4139: WHERE chrv.contract_number = p_contract_number
4140: AND chrv.id = cle.dnz_chr_id