DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on FA_API_TYPES

Line 115: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type) IS

111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113: p_asset_id IN NUMBER,
114: p_book_type_code IN VARCHAR2,
115: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type) IS
116:
117: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
118: l_api_name CONSTANT VARCHAR2(30) := 'GET_DEPRN_RESERVE';
119: l_api_version CONSTANT NUMBER := 1.0;

Line 121: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

117: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
118: l_api_name CONSTANT VARCHAR2(30) := 'GET_DEPRN_RESERVE';
119: l_api_version CONSTANT NUMBER := 1.0;
120:
121: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
122: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
123: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
124:
125: l_deprn_reserve NUMBER;

Line 122: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

118: l_api_name CONSTANT VARCHAR2(30) := 'GET_DEPRN_RESERVE';
119: l_api_version CONSTANT NUMBER := 1.0;
120:
121: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
122: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
123: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
124:
125: l_deprn_reserve NUMBER;
126:

Line 123: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

119: l_api_version CONSTANT NUMBER := 1.0;
120:
121: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
122: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
123: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
124:
125: l_deprn_reserve NUMBER;
126:
127: BEGIN

Line 990: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) is

986: p_sla_asset_chr_id IN Number,
987: --Bug# 6373605--SLA populate source
988: --Bug# 4028371
989: x_fa_trx_date OUT NOCOPY DATE,
990: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) is
991:
992: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
993: l_api_name CONSTANT varchar2(30) := 'FIXED_ASSET_ADJ_CST';
994: l_api_version CONSTANT NUMBER := 1.0;

Line 996: l_trans_rec FA_API_TYPES.trans_rec_type;

992: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
993: l_api_name CONSTANT varchar2(30) := 'FIXED_ASSET_ADJ_CST';
994: l_api_version CONSTANT NUMBER := 1.0;
995:
996: l_trans_rec FA_API_TYPES.trans_rec_type;
997: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
998: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
999: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1000: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

Line 997: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

993: l_api_name CONSTANT varchar2(30) := 'FIXED_ASSET_ADJ_CST';
994: l_api_version CONSTANT NUMBER := 1.0;
995:
996: l_trans_rec FA_API_TYPES.trans_rec_type;
997: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
998: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
999: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1000: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1001: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

Line 998: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

994: l_api_version CONSTANT NUMBER := 1.0;
995:
996: l_trans_rec FA_API_TYPES.trans_rec_type;
997: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
998: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
999: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1000: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1001: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1002: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 999: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

995:
996: l_trans_rec FA_API_TYPES.trans_rec_type;
997: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
998: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
999: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1000: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1001: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1002: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1003: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

Line 1000: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

996: l_trans_rec FA_API_TYPES.trans_rec_type;
997: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
998: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
999: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1000: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1001: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1002: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1003: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1004: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

Line 1001: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

997: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
998: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
999: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1000: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1001: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1002: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1003: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1004: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1005: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

Line 1002: l_inv_tbl FA_API_TYPES.inv_tbl_type;

998: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
999: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1000: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1001: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1002: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1003: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1004: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1005: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1006: l_inv_rec FA_API_TYPES.inv_rec_type;

Line 1003: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

999: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1000: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1001: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1002: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1003: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1004: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1005: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1006: l_inv_rec FA_API_TYPES.inv_rec_type;
1007: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 1004: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

1000: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1001: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1002: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1003: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1004: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1005: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1006: l_inv_rec FA_API_TYPES.inv_rec_type;
1007: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1008: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;

Line 1005: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

1001: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1002: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1003: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1004: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1005: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1006: l_inv_rec FA_API_TYPES.inv_rec_type;
1007: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1008: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1009:

Line 1006: l_inv_rec FA_API_TYPES.inv_rec_type;

1002: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1003: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1004: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1005: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1006: l_inv_rec FA_API_TYPES.inv_rec_type;
1007: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1008: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1009:
1010: l_asset_id NUMBER;

Line 1007: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

1003: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1004: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1005: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1006: l_inv_rec FA_API_TYPES.inv_rec_type;
1007: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1008: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1009:
1010: l_asset_id NUMBER;
1011: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;

Line 1008: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;

1004: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1005: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1006: l_inv_rec FA_API_TYPES.inv_rec_type;
1007: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1008: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1009:
1010: l_asset_id NUMBER;
1011: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;
1012: l_adjust_cost NUMBER;

Line 1019: l_fa_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

1015: --Bug# 2981308
1016: l_adj_percent_sv NUMBER;
1017:
1018: --Bug# 5946411: parameters for getting depreciation reserve
1019: l_fa_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1020: l_fa_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1021:
1022: --Bug# 6373605 begin
1023: l_fxhv_rec okl_sla_acc_sources_pvt.fxhv_rec_type;

Line 1020: l_fa_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

1016: l_adj_percent_sv NUMBER;
1017:
1018: --Bug# 5946411: parameters for getting depreciation reserve
1019: l_fa_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1020: l_fa_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1021:
1022: --Bug# 6373605 begin
1023: l_fxhv_rec okl_sla_acc_sources_pvt.fxhv_rec_type;
1024: l_fxlv_rec okl_sla_acc_sources_pvt.fxlv_rec_type;

Line 1291: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,

1287: x_msg_data OUT NOCOPY VARCHAR2,
1288: p_chr_id IN NUMBER,
1289: p_asset_id IN NUMBER,
1290: p_book_type_code IN OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE,
1291: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1292: --Bug Fix# 2925461
1293: p_adj_date IN DATE,
1294: --Bug# 3156924
1295: p_trans_number IN VARCHAR2,

Line 1309: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) is

1305: p_sla_source_kle_id IN Number,
1306: --Bug# 6373605--SLA populate source
1307: --Bug# 4028371
1308: x_fa_trx_date OUT NOCOPY DATE,
1309: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) is
1310:
1311: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
1312: l_api_name CONSTANT varchar2(30) := 'FIXED_ASSET_ADJUST';
1313: l_api_version CONSTANT NUMBER := 1.0;

Line 1315: l_trans_rec FA_API_TYPES.trans_rec_type;

1311: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
1312: l_api_name CONSTANT varchar2(30) := 'FIXED_ASSET_ADJUST';
1313: l_api_version CONSTANT NUMBER := 1.0;
1314:
1315: l_trans_rec FA_API_TYPES.trans_rec_type;
1316: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1317: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1318: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1319: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

Line 1316: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

1312: l_api_name CONSTANT varchar2(30) := 'FIXED_ASSET_ADJUST';
1313: l_api_version CONSTANT NUMBER := 1.0;
1314:
1315: l_trans_rec FA_API_TYPES.trans_rec_type;
1316: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1317: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1318: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1319: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1320: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

Line 1317: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

1313: l_api_version CONSTANT NUMBER := 1.0;
1314:
1315: l_trans_rec FA_API_TYPES.trans_rec_type;
1316: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1317: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1318: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1319: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1320: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1321: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 1318: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

1314:
1315: l_trans_rec FA_API_TYPES.trans_rec_type;
1316: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1317: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1318: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1319: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1320: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1321: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1322: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

Line 1319: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

1315: l_trans_rec FA_API_TYPES.trans_rec_type;
1316: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1317: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1318: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1319: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1320: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1321: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1322: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1323: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

Line 1320: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

1316: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1317: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1318: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1319: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1320: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1321: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1322: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1323: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1324: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

Line 1321: l_inv_tbl FA_API_TYPES.inv_tbl_type;

1317: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1318: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1319: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1320: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1321: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1322: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1323: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1324: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1325: l_inv_rec FA_API_TYPES.inv_rec_type;

Line 1322: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

1318: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1319: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1320: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1321: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1322: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1323: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1324: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1325: l_inv_rec FA_API_TYPES.inv_rec_type;
1326: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 1323: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

1319: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1320: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1321: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1322: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1323: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1324: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1325: l_inv_rec FA_API_TYPES.inv_rec_type;
1326: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1327: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;

Line 1324: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

1320: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1321: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1322: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1323: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1324: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1325: l_inv_rec FA_API_TYPES.inv_rec_type;
1326: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1327: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1328:

Line 1325: l_inv_rec FA_API_TYPES.inv_rec_type;

1321: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1322: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1323: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1324: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1325: l_inv_rec FA_API_TYPES.inv_rec_type;
1326: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1327: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1328:
1329: l_asset_id NUMBER;

Line 1326: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

1322: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1323: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1324: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1325: l_inv_rec FA_API_TYPES.inv_rec_type;
1326: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1327: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1328:
1329: l_asset_id NUMBER;
1330: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;

Line 1327: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;

1323: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1324: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1325: l_inv_rec FA_API_TYPES.inv_rec_type;
1326: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1327: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1328:
1329: l_asset_id NUMBER;
1330: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;
1331:

Line 1336: l_fa_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

1332: l_mesg_len NUMBER;
1333: l_mesg Varchar2(2000);
1334:
1335: --Bug# 5946411: parameters for getting depreciation reserve
1336: l_fa_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1337: l_fa_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1338:
1339: --Bug# 6373605 begin
1340: l_fxhv_rec okl_sla_acc_sources_pvt.fxhv_rec_type;

Line 1337: l_fa_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

1333: l_mesg Varchar2(2000);
1334:
1335: --Bug# 5946411: parameters for getting depreciation reserve
1336: l_fa_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1337: l_fa_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1338:
1339: --Bug# 6373605 begin
1340: l_fxhv_rec okl_sla_acc_sources_pvt.fxhv_rec_type;
1341: l_fxlv_rec okl_sla_acc_sources_pvt.fxlv_rec_type;

Line 1891: x_asset_hdr_rec OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) is

1887: p_sla_asset_chr_id IN Number,
1888: --Bug# 6373605--SLA populate source
1889: --Bug# 4028371
1890: x_fa_trx_date OUT NOCOPY DATE,
1891: x_asset_hdr_rec OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) is
1892:
1893: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
1894: l_api_name CONSTANT varchar2(30) := 'FIXED_ASSET_ADD';
1895: l_api_version CONSTANT NUMBER := 1.0;

Line 1897: l_trans_rec FA_API_TYPES.trans_rec_type;

1893: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
1894: l_api_name CONSTANT varchar2(30) := 'FIXED_ASSET_ADD';
1895: l_api_version CONSTANT NUMBER := 1.0;
1896:
1897: l_trans_rec FA_API_TYPES.trans_rec_type;
1898: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1899: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1900: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1901: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 1898: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

1894: l_api_name CONSTANT varchar2(30) := 'FIXED_ASSET_ADD';
1895: l_api_version CONSTANT NUMBER := 1.0;
1896:
1897: l_trans_rec FA_API_TYPES.trans_rec_type;
1898: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1899: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1900: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1901: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1902: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 1899: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

1895: l_api_version CONSTANT NUMBER := 1.0;
1896:
1897: l_trans_rec FA_API_TYPES.trans_rec_type;
1898: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1899: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1900: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1901: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1902: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1903: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;

Line 1900: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

1896:
1897: l_trans_rec FA_API_TYPES.trans_rec_type;
1898: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1899: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1900: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1901: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1902: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1903: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
1904: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 1901: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

1897: l_trans_rec FA_API_TYPES.trans_rec_type;
1898: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1899: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1900: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1901: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1902: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1903: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
1904: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1905: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 1902: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

1898: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1899: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1900: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1901: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1902: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1903: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
1904: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1905: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1906: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;

Line 1903: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;

1899: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1900: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1901: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1902: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1903: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
1904: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1905: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1906: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
1907: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 1904: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

1900: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1901: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1902: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1903: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
1904: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1905: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1906: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
1907: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1908: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 1905: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

1901: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1902: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1903: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
1904: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1905: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1906: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
1907: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1908: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1909:

Line 1906: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;

1902: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1903: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
1904: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1905: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1906: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
1907: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1908: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1909:
1910: --Bug Fix # 2887948

Line 1907: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

1903: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
1904: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1905: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1906: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
1907: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1908: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1909:
1910: --Bug Fix # 2887948
1911: --CURSOR to fetch expense account id

Line 1908: l_inv_tbl FA_API_TYPES.inv_tbl_type;

1904: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1905: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1906: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
1907: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1908: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1909:
1910: --Bug Fix # 2887948
1911: --CURSOR to fetch expense account id
1912: CURSOR exp_act_csr (p_kle_id IN NUMBER) IS

Line 2392: x_asset_hdr_rec OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) is

2388: p_sla_asset_chr_id IN Number,
2389: --Bug# 6373605--SLA populate source
2390: --Bug# 4028371
2391: x_fa_trx_date OUT NOCOPY DATE,
2392: x_asset_hdr_rec OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) is
2393:
2394: Begin
2395:
2396: FIXED_ASSET_ADD(p_api_version => p_api_version,

Line 2468: l_trans_rec fa_api_types.trans_rec_type;

2464: l_api_name CONSTANT varchar2(30) := 'FIXED_ASSET_TRANSFER';
2465: l_api_version CONSTANT NUMBER := 1.0;
2466:
2467:
2468: l_trans_rec fa_api_types.trans_rec_type;
2469: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2470: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2471:
2472: --cursor to get the distributions

Line 2469: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

2465: l_api_version CONSTANT NUMBER := 1.0;
2466:
2467:
2468: l_trans_rec fa_api_types.trans_rec_type;
2469: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2470: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2471:
2472: --cursor to get the distributions
2473: cursor l_dist_curs(p_asset_id IN NUMBER,

Line 2470: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;

2466:
2467:
2468: l_trans_rec fa_api_types.trans_rec_type;
2469: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2470: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2471:
2472: --cursor to get the distributions
2473: cursor l_dist_curs(p_asset_id IN NUMBER,
2474: p_corporate_book IN VARCHAR2) is

Line 2678: l_trans_rec fa_api_types.trans_rec_type;

2674: l_api_name CONSTANT varchar2(30) := 'FIXED_ASSET_ADJUST_UNIT';
2675: l_api_version CONSTANT NUMBER := 1.0;
2676:
2677:
2678: l_trans_rec fa_api_types.trans_rec_type;
2679: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2680: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2681:
2682: l_units_to_adjust NUMBER;

Line 2679: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

2675: l_api_version CONSTANT NUMBER := 1.0;
2676:
2677:
2678: l_trans_rec fa_api_types.trans_rec_type;
2679: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2680: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2681:
2682: l_units_to_adjust NUMBER;
2683: i number;

Line 2680: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;

2676:
2677:
2678: l_trans_rec fa_api_types.trans_rec_type;
2679: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2680: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2681:
2682: l_units_to_adjust NUMBER;
2683: i number;
2684:

Line 2895: l_trans_rec fa_api_types.trans_rec_type;

2891: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
2892: l_api_name CONSTANT varchar2(30) := 'FIXED_ASSET_UPDATE_DESC';
2893: l_api_version CONSTANT NUMBER := 1.0;
2894:
2895: l_trans_rec fa_api_types.trans_rec_type;
2896: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2897: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
2898: l_asset_type_rec fa_api_types.asset_type_rec_type;
2899: l_asset_cat_rec fa_api_types.asset_cat_rec_type;

Line 2896: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

2892: l_api_name CONSTANT varchar2(30) := 'FIXED_ASSET_UPDATE_DESC';
2893: l_api_version CONSTANT NUMBER := 1.0;
2894:
2895: l_trans_rec fa_api_types.trans_rec_type;
2896: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2897: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
2898: l_asset_type_rec fa_api_types.asset_type_rec_type;
2899: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
2900:

Line 2897: l_asset_desc_rec fa_api_types.asset_desc_rec_type;

2893: l_api_version CONSTANT NUMBER := 1.0;
2894:
2895: l_trans_rec fa_api_types.trans_rec_type;
2896: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2897: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
2898: l_asset_type_rec fa_api_types.asset_type_rec_type;
2899: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
2900:
2901: begin

Line 2898: l_asset_type_rec fa_api_types.asset_type_rec_type;

2894:
2895: l_trans_rec fa_api_types.trans_rec_type;
2896: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2897: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
2898: l_asset_type_rec fa_api_types.asset_type_rec_type;
2899: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
2900:
2901: begin
2902: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2899: l_asset_cat_rec fa_api_types.asset_cat_rec_type;

2895: l_trans_rec fa_api_types.trans_rec_type;
2896: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2897: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
2898: l_asset_type_rec fa_api_types.asset_type_rec_type;
2899: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
2900:
2901: begin
2902: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2903: -- Call start_activity to create savepoint, check compatibility

Line 3161: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

3157: l_asset_number OKX_ASSETS_V.NAME%Type;
3158: l_asset_description OKX_ASSETS_V.Description%Type;
3159: l_fa_line_id Number;
3160: l_fin_ast_line_id Number;
3161: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3162: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3163: l_asst_count Number default 0;
3164:
3165: --parameters for rule apis

Line 3162: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

3158: l_asset_description OKX_ASSETS_V.Description%Type;
3159: l_fa_line_id Number;
3160: l_fin_ast_line_id Number;
3161: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3162: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3163: l_asst_count Number default 0;
3164:
3165: --parameters for rule apis
3166: l_rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE default G_TAX_OWNER_RGP_CODE;

Line 5289: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

5285: l_chk_cle_effective Varchar2(1) default '?';
5286:
5287: l_cost_delta Number;
5288: l_salvage_delta Number;
5289: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
5290: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
5291: l_adjust_yn Varchar2(1);
5292:
5293: --check if a new line exists on rbk copy contract

Line 5290: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

5286:
5287: l_cost_delta Number;
5288: l_salvage_delta Number;
5289: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
5290: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
5291: l_adjust_yn Varchar2(1);
5292:
5293: --check if a new line exists on rbk copy contract
5294: --select the fin asset and fixed asset line id

Line 5358: l_subsidy_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

5354:
5355: l_rebook_allowed_on_mg_book varchar2(1);
5356:
5357: --Bug# 3783518
5358: l_subsidy_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
5359:
5360: --Bug# 4028371
5361: l_fa_adj_date date;
5362: l_fa_sub_adj_date date;

Line 6569: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

6565: l_chk_cle_effective Varchar2(1) default '?';
6566:
6567: l_cost_delta Number;
6568: l_salvage_delta Number;
6569: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
6570: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
6571: l_adjust_yn Varchar2(1);
6572:
6573: --cursor to get tax owner rule

Line 6570: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

6566:
6567: l_cost_delta Number;
6568: l_salvage_delta Number;
6569: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
6570: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
6571: l_adjust_yn Varchar2(1);
6572:
6573: --cursor to get tax owner rule
6574: Cursor town_rul_csr (pchrid number) is

Line 7622: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

7618: okx_ast_rec okx_ast_csr%ROWTYPE;
7619:
7620: l_cost_delta Number;
7621: l_salvage_delta Number;
7622: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
7623: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
7624: l_adjust_yn Varchar2(1);
7625: l_dummy_amount NUMBER;
7626:

Line 7623: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

7619:
7620: l_cost_delta Number;
7621: l_salvage_delta Number;
7622: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
7623: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
7624: l_adjust_yn Varchar2(1);
7625: l_dummy_amount NUMBER;
7626:
7627: --cursor to get tax owner rule

Line 7820: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

7816:
7817: ast_corp_book_rec okx_ast_csr%ROWTYPE;
7818: ast_rep_book_rec okx_ast_csr%ROWTYPE;
7819: l_bk_dfs_rec bk_dfs_csr%ROWTYPE;
7820: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
7821: l_talv_rec talv_rec_type;
7822: l_no_data_found BOOLEAN;
7823: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
7824: l_adjust_cost NUMBER;

Line 7823: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

7819: l_bk_dfs_rec bk_dfs_csr%ROWTYPE;
7820: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
7821: l_talv_rec talv_rec_type;
7822: l_no_data_found BOOLEAN;
7823: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
7824: l_adjust_cost NUMBER;
7825: l_adj_salvage_value NUMBER;
7826: l_adj_percent_sv NUMBER;
7827:

Line 7844: l_subsidy_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

7840: WHERE cle.id = p_cle_id
7841: AND khr.id = cle.dnz_chr_id
7842: AND pdt.id = khr.pdt_id;
7843:
7844: l_subsidy_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
7845: l_orig_system_id1 NUMBER;
7846: l_orig_reporting_pdt_id NUMBER;
7847:
7848:

Line 7906: l_dummy_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

7902: --5261704
7903: l_depreciate_flag VARCHAR2(3);
7904:
7905: --Bug# 6373605 start
7906: l_dummy_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
7907: --Bug# 6373605 end
7908:
7909: BEGIN
7910: