34: -- GLOBAL VARIABLES
35: -------------------------------------------------------------------------------------------------
36: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RELEASE_PVT';
37: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
38: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
39: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
40: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
41: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
42: G_ERROR CONSTANT VARCHAR2(200) := 'OKL_COPY_ASSET_LINES';
35: -------------------------------------------------------------------------------------------------
36: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RELEASE_PVT';
37: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
38: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
39: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
40: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
41: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
42: G_ERROR CONSTANT VARCHAR2(200) := 'OKL_COPY_ASSET_LINES';
43: G_CREATION_ERROR CONSTANT VARCHAR2(200) := 'Error Occurred in Creation';
36: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RELEASE_PVT';
37: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
38: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
39: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
40: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
41: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
42: G_ERROR CONSTANT VARCHAR2(200) := 'OKL_COPY_ASSET_LINES';
43: G_CREATION_ERROR CONSTANT VARCHAR2(200) := 'Error Occurred in Creation';
44: G_ID2 CONSTANT VARCHAR2(200) := '#';
37: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
38: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
39: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
40: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
41: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
42: G_ERROR CONSTANT VARCHAR2(200) := 'OKL_COPY_ASSET_LINES';
43: G_CREATION_ERROR CONSTANT VARCHAR2(200) := 'Error Occurred in Creation';
44: G_ID2 CONSTANT VARCHAR2(200) := '#';
45: G_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE ASSET LINES';
43: G_CREATION_ERROR CONSTANT VARCHAR2(200) := 'Error Occurred in Creation';
44: G_ID2 CONSTANT VARCHAR2(200) := '#';
45: G_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE ASSET LINES';
46: G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';
47: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
48: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
49: G_YN_ERROR CONSTANT VARCHAR2(200) := 'Invalid Value for ';
50: -------------------------------------------------------------------------------------------------
51: -- GLOBAL COMPOSITE TYPE VARIABLES
44: G_ID2 CONSTANT VARCHAR2(200) := '#';
45: G_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE ASSET LINES';
46: G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';
47: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
48: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
49: G_YN_ERROR CONSTANT VARCHAR2(200) := 'Invalid Value for ';
50: -------------------------------------------------------------------------------------------------
51: -- GLOBAL COMPOSITE TYPE VARIABLES
52: -------------------------------------------------------------------------------------------------
2533: and UITEM.JTOT_OBJECT1_CODE = 'OKL_USAGE'
2534: and UITEM.OBJECT1_ID2='#'
2535: and USAGE.id=UITEM.cle_id
2536: and USUB_LINE.cle_id=USAGE.id
2537: and USUB_LINE.lse_id=(select id from okc_line_styles_v where lty_code = 'LINK_USAGE_ASSET')
2538: and LINK_ITEM.cle_id=USUB_LINE.id
2539: and LINK_ITEM.OBJECT1_ID1=top_line.id
2540: and LINK_ITEM.OBJECT1_ID2='#'
2541: and top_line.lse_id=(select id from okc_line_styles_v where lty_code = 'FREE_FORM1')
2537: and USUB_LINE.lse_id=(select id from okc_line_styles_v where lty_code = 'LINK_USAGE_ASSET')
2538: and LINK_ITEM.cle_id=USUB_LINE.id
2539: and LINK_ITEM.OBJECT1_ID1=top_line.id
2540: and LINK_ITEM.OBJECT1_ID2='#'
2541: and top_line.lse_id=(select id from okc_line_styles_v where lty_code = 'FREE_FORM1')
2542: and top_line.id = tcl.kle_id
2543: and tcl.tcn_id = p_source_trx_id
2544: AND tcl.before_transfer_yn = 'N'
2545: );