838: p_quote_accpt_date IN DATE DEFAULT NULL -- rmunjulu EDAT
839: ) IS
840:
841:
842: l_trans_rec FA_API_TYPES.trans_rec_type;
843: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
844: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
845: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
846: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
839: ) IS
840:
841:
842: l_trans_rec FA_API_TYPES.trans_rec_type;
843: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
844: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
845: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
846: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
847: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
840:
841:
842: l_trans_rec FA_API_TYPES.trans_rec_type;
843: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
844: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
845: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
846: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
847: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
848: l_inv_tbl FA_API_TYPES.inv_tbl_type;
841:
842: l_trans_rec FA_API_TYPES.trans_rec_type;
843: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
844: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
845: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
846: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
847: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
848: l_inv_tbl FA_API_TYPES.inv_tbl_type;
849:
842: l_trans_rec FA_API_TYPES.trans_rec_type;
843: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
844: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
845: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
846: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
847: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
848: l_inv_tbl FA_API_TYPES.inv_tbl_type;
849:
850: -- SECHAWLA 21-NOV-03 3262519: New Declarations
843: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
844: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
845: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
846: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
847: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
848: l_inv_tbl FA_API_TYPES.inv_tbl_type;
849:
850: -- SECHAWLA 21-NOV-03 3262519: New Declarations
851: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
844: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
845: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
846: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
847: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
848: l_inv_tbl FA_API_TYPES.inv_tbl_type;
849:
850: -- SECHAWLA 21-NOV-03 3262519: New Declarations
851: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
852: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
847: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
848: l_inv_tbl FA_API_TYPES.inv_tbl_type;
849:
850: -- SECHAWLA 21-NOV-03 3262519: New Declarations
851: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
852: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
853: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
854: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
855: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
848: l_inv_tbl FA_API_TYPES.inv_tbl_type;
849:
850: -- SECHAWLA 21-NOV-03 3262519: New Declarations
851: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
852: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
853: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
854: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
855: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
856: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
849:
850: -- SECHAWLA 21-NOV-03 3262519: New Declarations
851: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
852: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
853: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
854: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
855: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
856: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
857:
850: -- SECHAWLA 21-NOV-03 3262519: New Declarations
851: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
852: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
853: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
854: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
855: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
856: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
857:
858: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
851: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
852: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
853: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
854: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
855: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
856: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
857:
858: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
859: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
852: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
853: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
854: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
855: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
856: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
857:
858: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
859: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
860: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
854: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
855: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
856: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
857:
858: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
859: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
860: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
861: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
862: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
855: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
856: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
857:
858: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
859: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
860: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
861: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
862: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
863:
856: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
857:
858: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
859: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
860: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
861: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
862: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
863:
864:
857:
858: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
859: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
860: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
861: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
862: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
863:
864:
865: -- SECHAWLA 21-NOV-03 3262519: end
858: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
859: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
860: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
861: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
862: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
863:
864:
865: -- SECHAWLA 21-NOV-03 3262519: end
866:
1134:
1135: ) IS
1136:
1137:
1138: l_trans_rec FA_API_TYPES.trans_rec_type;
1139: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1140: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1141: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1142: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1135: ) IS
1136:
1137:
1138: l_trans_rec FA_API_TYPES.trans_rec_type;
1139: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1140: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1141: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1142: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1143: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1136:
1137:
1138: l_trans_rec FA_API_TYPES.trans_rec_type;
1139: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1140: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1141: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1142: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1143: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1144: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1137:
1138: l_trans_rec FA_API_TYPES.trans_rec_type;
1139: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1140: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1141: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1142: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1143: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1144: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1145:
1138: l_trans_rec FA_API_TYPES.trans_rec_type;
1139: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1140: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1141: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1142: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1143: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1144: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1145:
1146: -- SECHAWLA 21-NOV-03 3262519: New Declarations
1139: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1140: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1141: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1142: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1143: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1144: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1145:
1146: -- SECHAWLA 21-NOV-03 3262519: New Declarations
1147: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
1140: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1141: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1142: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1143: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1144: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1145:
1146: -- SECHAWLA 21-NOV-03 3262519: New Declarations
1147: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
1148: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1143: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1144: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1145:
1146: -- SECHAWLA 21-NOV-03 3262519: New Declarations
1147: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
1148: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1149: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
1150: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1151: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1144: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1145:
1146: -- SECHAWLA 21-NOV-03 3262519: New Declarations
1147: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
1148: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1149: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
1150: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1151: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1152: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1145:
1146: -- SECHAWLA 21-NOV-03 3262519: New Declarations
1147: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
1148: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1149: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
1150: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1151: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1152: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1153:
1146: -- SECHAWLA 21-NOV-03 3262519: New Declarations
1147: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
1148: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1149: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
1150: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1151: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1152: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1153:
1154: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1147: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
1148: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1149: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
1150: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1151: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1152: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1153:
1154: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1155: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1148: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1149: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
1150: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1151: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1152: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1153:
1154: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1155: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1156: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1150: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1151: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1152: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1153:
1154: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1155: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1156: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1157: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1158: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1151: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1152: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1153:
1154: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1155: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1156: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1157: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1158: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1159: -- SECHAWLA 21-NOV-03 3262519: end
1152: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1153:
1154: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1155: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1156: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1157: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1158: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1159: -- SECHAWLA 21-NOV-03 3262519: end
1160:
1153:
1154: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1155: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1156: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1157: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1158: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1159: -- SECHAWLA 21-NOV-03 3262519: end
1160:
1161: --SECHAWLA 10-FEB-06 5016156
1154: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1155: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1156: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1157: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1158: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1159: -- SECHAWLA 21-NOV-03 3262519: end
1160:
1161: --SECHAWLA 10-FEB-06 5016156
1162: l_adj_error EXCEPTION;
1415: ) IS
1416:
1417:
1418:
1419: l_trans_rec FA_API_TYPES.trans_rec_type;
1420: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1421: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1422: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1423: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1416:
1417:
1418:
1419: l_trans_rec FA_API_TYPES.trans_rec_type;
1420: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1421: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1422: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1423: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1424: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1417:
1418:
1419: l_trans_rec FA_API_TYPES.trans_rec_type;
1420: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1421: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1422: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1423: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1424: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1425: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1418:
1419: l_trans_rec FA_API_TYPES.trans_rec_type;
1420: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1421: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1422: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1423: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1424: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1425: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1426: i NUMBER;
1419: l_trans_rec FA_API_TYPES.trans_rec_type;
1420: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1421: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1422: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1423: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1424: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1425: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1426: i NUMBER;
1427:
1420: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1421: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1422: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1423: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1424: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1425: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1426: i NUMBER;
1427:
1428: -- SECHAWLA 21-NOV-03 3262519: New Declarations
1421: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1422: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1423: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1424: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1425: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1426: i NUMBER;
1427:
1428: -- SECHAWLA 21-NOV-03 3262519: New Declarations
1429: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
1425: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1426: i NUMBER;
1427:
1428: -- SECHAWLA 21-NOV-03 3262519: New Declarations
1429: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
1430: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1431: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
1432: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1433: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1426: i NUMBER;
1427:
1428: -- SECHAWLA 21-NOV-03 3262519: New Declarations
1429: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
1430: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1431: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
1432: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1433: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1434: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1427:
1428: -- SECHAWLA 21-NOV-03 3262519: New Declarations
1429: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
1430: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1431: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
1432: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1433: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1434: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1435:
1428: -- SECHAWLA 21-NOV-03 3262519: New Declarations
1429: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
1430: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1431: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
1432: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1433: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1434: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1435:
1436: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1429: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
1430: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1431: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
1432: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1433: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1434: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1435:
1436: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1437: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1430: l_adj_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1431: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
1432: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1433: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1434: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1435:
1436: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1437: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1438: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1432: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1433: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1434: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1435:
1436: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1437: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1438: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1439: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1440: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1433: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1434: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1435:
1436: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1437: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1438: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1439: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1440: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1441: -- SECHAWLA 21-NOV-03 3262519: end
1434: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1435:
1436: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1437: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1438: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1439: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1440: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1441: -- SECHAWLA 21-NOV-03 3262519: end
1442:
1435:
1436: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1437: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1438: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1439: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1440: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1441: -- SECHAWLA 21-NOV-03 3262519: end
1442:
1443: --SECHAWLA 10-FEB-06 5016156
1436: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1437: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1438: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1439: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1440: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1441: -- SECHAWLA 21-NOV-03 3262519: end
1442:
1443: --SECHAWLA 10-FEB-06 5016156
1444: l_adj_error EXCEPTION;
1924: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
1925:
1926: --SECHAWLA 05-FEB-03 Bug # 2781557 : new declarations
1927: l_fiscal_year_name VARCHAR2(30);
1928: l_period_rec FA_API_TYPES.period_rec_type;
1929: l_count NUMBER;
1930: l_period_of_addition VARCHAR2(1);
1931:
1932: --SECHAWLA 11-MAR-03 New Declarations
3745: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
3746:
3747: --SECHAWLA 05-FEB-03 Bug # 2781557 : new declarations
3748: l_fiscal_year_name VARCHAR2(30);
3749: l_period_rec FA_API_TYPES.period_rec_type;
3750: l_count NUMBER;
3751: l_period_of_addition VARCHAR2(1);
3752:
3753: -- RMUNJULU 3061751
5220: x_msg_count OUT NOCOPY NUMBER,
5221: x_msg_data OUT NOCOPY VARCHAR2,
5222: p_retirement_id IN NUMBER) IS
5223:
5224: l_trans_rec FA_API_TYPES.trans_rec_type;
5225: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5226: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5227: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5228: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5221: x_msg_data OUT NOCOPY VARCHAR2,
5222: p_retirement_id IN NUMBER) IS
5223:
5224: l_trans_rec FA_API_TYPES.trans_rec_type;
5225: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5226: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5227: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5228: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5229: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5222: p_retirement_id IN NUMBER) IS
5223:
5224: l_trans_rec FA_API_TYPES.trans_rec_type;
5225: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5226: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5227: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5228: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5229: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5230: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5223:
5224: l_trans_rec FA_API_TYPES.trans_rec_type;
5225: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5226: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5227: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5228: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5229: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5230: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5231: l_api_name CONSTANT VARCHAR2(30) := 'undo_retirement';
5224: l_trans_rec FA_API_TYPES.trans_rec_type;
5225: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5226: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5227: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5228: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5229: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5230: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5231: l_api_name CONSTANT VARCHAR2(30) := 'undo_retirement';
5232: l_api_version CONSTANT NUMBER := 1;
5225: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5226: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5227: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5228: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5229: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5230: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5231: l_api_name CONSTANT VARCHAR2(30) := 'undo_retirement';
5232: l_api_version CONSTANT NUMBER := 1;
5233: l_dummy VARCHAR2(1);