eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 994: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) is

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

Line 1000: l_trans_rec FA_API_TYPES.trans_rec_type;

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

Line 1001: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

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

Line 1002: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

998: l_api_version CONSTANT NUMBER := 1.0;
999:
1000: l_trans_rec FA_API_TYPES.trans_rec_type;
1001: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1002: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1003: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1004: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1005: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1006: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 1003: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

999:
1000: l_trans_rec FA_API_TYPES.trans_rec_type;
1001: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1002: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1003: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1004: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1005: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1006: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1007: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

Line 1004: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

1000: l_trans_rec FA_API_TYPES.trans_rec_type;
1001: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1002: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1003: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1004: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1005: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1006: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1007: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1008: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

Line 1005: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

1001: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1002: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1003: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1004: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1005: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1006: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1007: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1008: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1009: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

Line 1006: l_inv_tbl FA_API_TYPES.inv_tbl_type;

1002: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1003: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1004: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1005: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1006: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1007: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1008: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1009: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1010: l_inv_rec FA_API_TYPES.inv_rec_type;

Line 1007: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

1003: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1004: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1005: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1006: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1007: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1008: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1009: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1010: l_inv_rec FA_API_TYPES.inv_rec_type;
1011: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 1008: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

1004: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1005: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1006: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1007: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1008: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1009: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1010: l_inv_rec FA_API_TYPES.inv_rec_type;
1011: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1012: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;

Line 1009: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

1005: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1006: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1007: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1008: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1009: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1010: l_inv_rec FA_API_TYPES.inv_rec_type;
1011: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1012: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1013:

Line 1010: l_inv_rec FA_API_TYPES.inv_rec_type;

1006: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1007: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1008: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1009: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1010: l_inv_rec FA_API_TYPES.inv_rec_type;
1011: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1012: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1013:
1014: l_asset_id NUMBER;

Line 1011: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

1007: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1008: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1009: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1010: l_inv_rec FA_API_TYPES.inv_rec_type;
1011: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1012: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1013:
1014: l_asset_id NUMBER;
1015: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;

Line 1012: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;

1008: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1009: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1010: l_inv_rec FA_API_TYPES.inv_rec_type;
1011: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1012: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1013:
1014: l_asset_id NUMBER;
1015: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;
1016: l_adjust_cost NUMBER;

Line 1023: l_fa_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

1019: --Bug# 2981308
1020: l_adj_percent_sv NUMBER;
1021:
1022: --Bug# 5946411: parameters for getting depreciation reserve
1023: l_fa_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1024: l_fa_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1025:
1026: --Bug# 6373605 begin
1027: l_fxhv_rec okl_sla_acc_sources_pvt.fxhv_rec_type;

Line 1024: l_fa_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

1020: l_adj_percent_sv NUMBER;
1021:
1022: --Bug# 5946411: parameters for getting depreciation reserve
1023: l_fa_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1024: l_fa_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1025:
1026: --Bug# 6373605 begin
1027: l_fxhv_rec okl_sla_acc_sources_pvt.fxhv_rec_type;
1028: l_fxlv_rec okl_sla_acc_sources_pvt.fxlv_rec_type;

Line 1295: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,

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

Line 1313: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) is

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

Line 1319: l_trans_rec FA_API_TYPES.trans_rec_type;

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

Line 1320: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

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

Line 1321: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

1317: l_api_version CONSTANT NUMBER := 1.0;
1318:
1319: l_trans_rec FA_API_TYPES.trans_rec_type;
1320: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1321: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1322: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1323: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1324: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1325: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 1322: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

1318:
1319: l_trans_rec FA_API_TYPES.trans_rec_type;
1320: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1321: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1322: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1323: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1324: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1325: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1326: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

Line 1323: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

1319: l_trans_rec FA_API_TYPES.trans_rec_type;
1320: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1321: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1322: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1323: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1324: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1325: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1326: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1327: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

Line 1324: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

1320: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1321: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1322: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1323: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1324: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1325: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1326: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1327: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1328: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

Line 1325: l_inv_tbl FA_API_TYPES.inv_tbl_type;

1321: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1322: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1323: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1324: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1325: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1326: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1327: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1328: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1329: l_inv_rec FA_API_TYPES.inv_rec_type;

Line 1326: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

1322: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1323: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1324: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1325: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1326: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1327: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1328: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1329: l_inv_rec FA_API_TYPES.inv_rec_type;
1330: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 1327: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

1323: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1324: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1325: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1326: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1327: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1328: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1329: l_inv_rec FA_API_TYPES.inv_rec_type;
1330: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1331: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;

Line 1328: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

1324: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1325: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1326: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1327: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1328: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1329: l_inv_rec FA_API_TYPES.inv_rec_type;
1330: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1331: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1332:

Line 1329: l_inv_rec FA_API_TYPES.inv_rec_type;

1325: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1326: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1327: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1328: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1329: l_inv_rec FA_API_TYPES.inv_rec_type;
1330: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1331: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1332:
1333: l_asset_id NUMBER;

Line 1330: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

1326: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1327: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1328: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1329: l_inv_rec FA_API_TYPES.inv_rec_type;
1330: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1331: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1332:
1333: l_asset_id NUMBER;
1334: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;

Line 1331: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;

1327: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1328: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1329: l_inv_rec FA_API_TYPES.inv_rec_type;
1330: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1331: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1332:
1333: l_asset_id NUMBER;
1334: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;
1335:

Line 1340: l_fa_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

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

Line 1341: l_fa_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

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

Line 1895: x_asset_hdr_rec OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) is

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

Line 1901: l_trans_rec FA_API_TYPES.trans_rec_type;

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

Line 1902: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

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

Line 1903: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

1899: l_api_version CONSTANT NUMBER := 1.0;
1900:
1901: l_trans_rec FA_API_TYPES.trans_rec_type;
1902: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1903: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1904: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1905: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1906: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1907: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;

Line 1904: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

1900:
1901: l_trans_rec FA_API_TYPES.trans_rec_type;
1902: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1903: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1904: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1905: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1906: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1907: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
1908: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 1905: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

1901: l_trans_rec FA_API_TYPES.trans_rec_type;
1902: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1903: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1904: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1905: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1906: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1907: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
1908: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1909: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 1906: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

1902: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1903: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1904: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1905: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1906: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1907: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
1908: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1909: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1910: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;

Line 1907: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;

1903: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1904: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1905: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1906: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1907: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
1908: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1909: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1910: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
1911: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 1908: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

1904: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1905: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1906: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1907: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
1908: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1909: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1910: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
1911: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1912: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 1909: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

1905: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1906: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1907: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
1908: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1909: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1910: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
1911: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1912: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1913:

Line 1910: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;

1906: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1907: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
1908: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1909: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1910: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
1911: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1912: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1913:
1914: --Bug Fix # 2887948

Line 1911: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

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

Line 1912: l_inv_tbl FA_API_TYPES.inv_tbl_type;

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

Line 2396: x_asset_hdr_rec OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) is

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

Line 2472: l_trans_rec fa_api_types.trans_rec_type;

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

Line 2473: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

2469: l_api_version CONSTANT NUMBER := 1.0;
2470:
2471:
2472: l_trans_rec fa_api_types.trans_rec_type;
2473: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2474: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2475:
2476: --cursor to get the distributions
2477: cursor l_dist_curs(p_asset_id IN NUMBER,

Line 2474: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;

2470:
2471:
2472: l_trans_rec fa_api_types.trans_rec_type;
2473: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2474: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2475:
2476: --cursor to get the distributions
2477: cursor l_dist_curs(p_asset_id IN NUMBER,
2478: p_corporate_book IN VARCHAR2) is

Line 2682: l_trans_rec fa_api_types.trans_rec_type;

2678: l_api_name CONSTANT varchar2(30) := 'FIXED_ASSET_ADJUST_UNIT';
2679: l_api_version CONSTANT NUMBER := 1.0;
2680:
2681:
2682: l_trans_rec fa_api_types.trans_rec_type;
2683: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2684: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2685:
2686: l_units_to_adjust NUMBER;

Line 2683: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

2679: l_api_version CONSTANT NUMBER := 1.0;
2680:
2681:
2682: l_trans_rec fa_api_types.trans_rec_type;
2683: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2684: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2685:
2686: l_units_to_adjust NUMBER;
2687: i number;

Line 2684: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;

2680:
2681:
2682: l_trans_rec fa_api_types.trans_rec_type;
2683: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2684: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2685:
2686: l_units_to_adjust NUMBER;
2687: i number;
2688:

Line 2901: l_trans_rec fa_api_types.trans_rec_type;

2897: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
2898: l_api_name CONSTANT varchar2(30) := 'FIXED_ASSET_UPDATE_DESC';
2899: l_api_version CONSTANT NUMBER := 1.0;
2900:
2901: l_trans_rec fa_api_types.trans_rec_type;
2902: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2903: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
2904: l_asset_type_rec fa_api_types.asset_type_rec_type;
2905: l_asset_cat_rec fa_api_types.asset_cat_rec_type;

Line 2902: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

2898: l_api_name CONSTANT varchar2(30) := 'FIXED_ASSET_UPDATE_DESC';
2899: l_api_version CONSTANT NUMBER := 1.0;
2900:
2901: l_trans_rec fa_api_types.trans_rec_type;
2902: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2903: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
2904: l_asset_type_rec fa_api_types.asset_type_rec_type;
2905: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
2906:

Line 2903: l_asset_desc_rec fa_api_types.asset_desc_rec_type;

2899: l_api_version CONSTANT NUMBER := 1.0;
2900:
2901: l_trans_rec fa_api_types.trans_rec_type;
2902: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2903: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
2904: l_asset_type_rec fa_api_types.asset_type_rec_type;
2905: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
2906:
2907: begin

Line 2904: l_asset_type_rec fa_api_types.asset_type_rec_type;

2900:
2901: l_trans_rec fa_api_types.trans_rec_type;
2902: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2903: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
2904: l_asset_type_rec fa_api_types.asset_type_rec_type;
2905: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
2906:
2907: begin
2908: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2905: l_asset_cat_rec fa_api_types.asset_cat_rec_type;

2901: l_trans_rec fa_api_types.trans_rec_type;
2902: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2903: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
2904: l_asset_type_rec fa_api_types.asset_type_rec_type;
2905: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
2906:
2907: begin
2908: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2909: -- Call start_activity to create savepoint, check compatibility

Line 3170: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

3166: l_asset_number OKX_ASSETS_V.NAME%Type;
3167: l_asset_description OKX_ASSETS_V.Description%Type;
3168: l_fa_line_id Number;
3169: l_fin_ast_line_id Number;
3170: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3171: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3172: l_asst_count Number default 0;
3173:
3174: --parameters for rule apis

Line 3171: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

3167: l_asset_description OKX_ASSETS_V.Description%Type;
3168: l_fa_line_id Number;
3169: l_fin_ast_line_id Number;
3170: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3171: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3172: l_asst_count Number default 0;
3173:
3174: --parameters for rule apis
3175: l_rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE default G_TAX_OWNER_RGP_CODE;

Line 5249: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

5245: l_chk_cle_effective Varchar2(1) default '?';
5246:
5247: l_cost_delta Number;
5248: l_salvage_delta Number;
5249: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
5250: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
5251: l_adjust_yn Varchar2(1);
5252:
5253: --check if a new line exists on rbk copy contract

Line 5250: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

5246:
5247: l_cost_delta Number;
5248: l_salvage_delta Number;
5249: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
5250: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
5251: l_adjust_yn Varchar2(1);
5252:
5253: --check if a new line exists on rbk copy contract
5254: --select the fin asset and fixed asset line id

Line 5318: l_subsidy_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

5314:
5315: l_rebook_allowed_on_mg_book varchar2(1);
5316:
5317: --Bug# 3783518
5318: l_subsidy_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
5319:
5320: --Bug# 4028371
5321: l_fa_adj_date date;
5322: l_fa_sub_adj_date date;

Line 6491: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

6487: l_chk_cle_effective Varchar2(1) default '?';
6488:
6489: l_cost_delta Number;
6490: l_salvage_delta Number;
6491: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
6492: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
6493: l_adjust_yn Varchar2(1);
6494:
6495: --cursor to get tax owner rule

Line 6492: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

6488:
6489: l_cost_delta Number;
6490: l_salvage_delta Number;
6491: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
6492: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
6493: l_adjust_yn Varchar2(1);
6494:
6495: --cursor to get tax owner rule
6496: Cursor town_rul_csr (pchrid number) is

Line 7347: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

7343: okx_ast_rec okx_ast_csr%ROWTYPE;
7344:
7345: l_cost_delta Number;
7346: l_salvage_delta Number;
7347: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
7348: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
7349: l_adjust_yn Varchar2(1);
7350: l_dummy_amount NUMBER;
7351:

Line 7348: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

7344:
7345: l_cost_delta Number;
7346: l_salvage_delta Number;
7347: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
7348: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
7349: l_adjust_yn Varchar2(1);
7350: l_dummy_amount NUMBER;
7351:
7352: --cursor to get tax owner rule

Line 7545: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

7541:
7542: ast_corp_book_rec okx_ast_csr%ROWTYPE;
7543: ast_rep_book_rec okx_ast_csr%ROWTYPE;
7544: l_bk_dfs_rec bk_dfs_csr%ROWTYPE;
7545: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
7546: l_talv_rec talv_rec_type;
7547: l_no_data_found BOOLEAN;
7548: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
7549: l_adjust_cost NUMBER;

Line 7548: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

7544: l_bk_dfs_rec bk_dfs_csr%ROWTYPE;
7545: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
7546: l_talv_rec talv_rec_type;
7547: l_no_data_found BOOLEAN;
7548: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
7549: l_adjust_cost NUMBER;
7550: l_adj_salvage_value NUMBER;
7551: l_adj_percent_sv NUMBER;
7552:

Line 7569: l_subsidy_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

7565: WHERE cle.id = p_cle_id
7566: AND khr.id = cle.dnz_chr_id
7567: AND pdt.id = khr.pdt_id;
7568:
7569: l_subsidy_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
7570: l_orig_system_id1 NUMBER;
7571: l_orig_reporting_pdt_id NUMBER;
7572:
7573:

Line 7631: l_dummy_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

7627: --5261704
7628: l_depreciate_flag VARCHAR2(3);
7629:
7630: --Bug# 6373605 start
7631: l_dummy_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
7632: --Bug# 6373605 end
7633:
7634: BEGIN
7635: