DBA Data[Home] [Help]

APPS.OKL_RELEASE_PVT dependencies on OKC_LINE_STYLES_V

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

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';

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

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';

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

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) := '#';

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

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';

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

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

Line 48: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';

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: -------------------------------------------------------------------------------------------------

Line 2561: and USUB_LINE.lse_id=(select id from okc_line_styles_v where lty_code = 'LINK_USAGE_ASSET')

2557: and UITEM.JTOT_OBJECT1_CODE = 'OKL_USAGE'
2558: and UITEM.OBJECT1_ID2='#'
2559: and USAGE.id=UITEM.cle_id
2560: and USUB_LINE.cle_id=USAGE.id
2561: and USUB_LINE.lse_id=(select id from okc_line_styles_v where lty_code = 'LINK_USAGE_ASSET')
2562: and LINK_ITEM.cle_id=USUB_LINE.id
2563: and LINK_ITEM.OBJECT1_ID1=top_line.id
2564: and LINK_ITEM.OBJECT1_ID2='#'
2565: and top_line.lse_id=(select id from okc_line_styles_v where lty_code = 'FREE_FORM1')

Line 2565: and top_line.lse_id=(select id from okc_line_styles_v where lty_code = 'FREE_FORM1')

2561: and USUB_LINE.lse_id=(select id from okc_line_styles_v where lty_code = 'LINK_USAGE_ASSET')
2562: and LINK_ITEM.cle_id=USUB_LINE.id
2563: and LINK_ITEM.OBJECT1_ID1=top_line.id
2564: and LINK_ITEM.OBJECT1_ID2='#'
2565: and top_line.lse_id=(select id from okc_line_styles_v where lty_code = 'FREE_FORM1')
2566: and top_line.id = tcl.kle_id
2567: and tcl.tcn_id = p_source_trx_id
2568: AND tcl.before_transfer_yn = 'N'
2569: );