41: RETURN x_msg_data;
42: END dump_error_stack;
43:
44: PROCEDURE validate_inst_asset(
45: px_inst_asset_rec IN OUT nocopy csi_datastructures_pub.instance_asset_rec,
46: x_return_status OUT nocopy varchar2)
47: IS
48: l_acct_class_code varchar2(30);
49: l_location_type_code varchar2(30);
226: x_return_status := fnd_api.g_ret_sts_error;
227: END validate_inst_asset;
228:
229: PROCEDURE derive_fa_missing_values(
230: p_instance_rec IN csi_datastructures_pub.instance_rec,
231: p_fixed_asset_rec IN fixed_asset_rec,
232: x_fa_location_id OUT nocopy number,
233: x_fa_quantity OUT nocopy number,
234: x_fa_book_type_code OUT nocopy varchar2,
370:
371: PROCEDURE create_item_instance(
372: p_fixed_asset_rec IN fixed_asset_rec,
373: p_eam_rec IN eam_rec,
374: p_instance_rec IN csi_datastructures_pub.instance_rec,
375: p_instance_serial_tbl IN instance_serial_tbl,
376: p_party_tbl IN csi_datastructures_pub.party_tbl,
377: p_party_account_tbl IN csi_datastructures_pub.party_account_tbl,
378: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
372: p_fixed_asset_rec IN fixed_asset_rec,
373: p_eam_rec IN eam_rec,
374: p_instance_rec IN csi_datastructures_pub.instance_rec,
375: p_instance_serial_tbl IN instance_serial_tbl,
376: p_party_tbl IN csi_datastructures_pub.party_tbl,
377: p_party_account_tbl IN csi_datastructures_pub.party_account_tbl,
378: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
379: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
380: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
373: p_eam_rec IN eam_rec,
374: p_instance_rec IN csi_datastructures_pub.instance_rec,
375: p_instance_serial_tbl IN instance_serial_tbl,
376: p_party_tbl IN csi_datastructures_pub.party_tbl,
377: p_party_account_tbl IN csi_datastructures_pub.party_account_tbl,
378: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
379: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
380: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
381: x_return_status OUT nocopy varchar2,
374: p_instance_rec IN csi_datastructures_pub.instance_rec,
375: p_instance_serial_tbl IN instance_serial_tbl,
376: p_party_tbl IN csi_datastructures_pub.party_tbl,
377: p_party_account_tbl IN csi_datastructures_pub.party_account_tbl,
378: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
379: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
380: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
381: x_return_status OUT nocopy varchar2,
382: x_error_message OUT nocopy varchar2)
375: p_instance_serial_tbl IN instance_serial_tbl,
376: p_party_tbl IN csi_datastructures_pub.party_tbl,
377: p_party_account_tbl IN csi_datastructures_pub.party_account_tbl,
378: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
379: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
380: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
381: x_return_status OUT nocopy varchar2,
382: x_error_message OUT nocopy varchar2)
383: IS
376: p_party_tbl IN csi_datastructures_pub.party_tbl,
377: p_party_account_tbl IN csi_datastructures_pub.party_account_tbl,
378: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
379: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
380: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
381: x_return_status OUT nocopy varchar2,
382: x_error_message OUT nocopy varchar2)
383: IS
384:
393: l_eam_item_type number;
394: l_eam_item boolean := FALSE;
395:
396: -- group create_item_instance variables
397: l_instance_tbl csi_datastructures_pub.instance_tbl;
398: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
399: l_party_tbl csi_datastructures_pub.party_tbl;
400: l_account_tbl csi_datastructures_pub.party_account_tbl;
401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
394: l_eam_item boolean := FALSE;
395:
396: -- group create_item_instance variables
397: l_instance_tbl csi_datastructures_pub.instance_tbl;
398: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
399: l_party_tbl csi_datastructures_pub.party_tbl;
400: l_account_tbl csi_datastructures_pub.party_account_tbl;
401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
402: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
395:
396: -- group create_item_instance variables
397: l_instance_tbl csi_datastructures_pub.instance_tbl;
398: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
399: l_party_tbl csi_datastructures_pub.party_tbl;
400: l_account_tbl csi_datastructures_pub.party_account_tbl;
401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
402: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
403: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
396: -- group create_item_instance variables
397: l_instance_tbl csi_datastructures_pub.instance_tbl;
398: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
399: l_party_tbl csi_datastructures_pub.party_tbl;
400: l_account_tbl csi_datastructures_pub.party_account_tbl;
401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
402: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
403: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
404: l_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
397: l_instance_tbl csi_datastructures_pub.instance_tbl;
398: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
399: l_party_tbl csi_datastructures_pub.party_tbl;
400: l_account_tbl csi_datastructures_pub.party_account_tbl;
401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
402: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
403: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
404: l_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
405: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
398: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
399: l_party_tbl csi_datastructures_pub.party_tbl;
400: l_account_tbl csi_datastructures_pub.party_account_tbl;
401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
402: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
403: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
404: l_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
405: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
406:
399: l_party_tbl csi_datastructures_pub.party_tbl;
400: l_account_tbl csi_datastructures_pub.party_account_tbl;
401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
402: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
403: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
404: l_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
405: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
406:
407:
400: l_account_tbl csi_datastructures_pub.party_account_tbl;
401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
402: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
403: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
404: l_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
405: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
406:
407:
408: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
402: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
403: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
404: l_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
405: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
406:
407:
408: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
409: l_msg_count number;
761: END create_item_instance;
762:
763: PROCEDURE copy_item_instance(
764: p_fixed_asset_rec IN fixed_asset_rec,
765: p_instance_rec IN csi_datastructures_pub.instance_rec,
766: p_instance_serial_tbl IN instance_serial_tbl,
767: p_eam_rec IN eam_rec,
768: p_copy_parties IN varchar2,
769: p_copy_accounts IN varchar2,
772: p_copy_asset_assignments IN varchar2,
773: p_copy_pricing_attribs IN varchar2,
774: p_copy_ext_attribs IN varchar2,
775: p_copy_inst_children IN varchar2,
776: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
777: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
778: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
779: x_return_status OUT nocopy varchar2,
780: x_error_message OUT nocopy varchar2)
773: p_copy_pricing_attribs IN varchar2,
774: p_copy_ext_attribs IN varchar2,
775: p_copy_inst_children IN varchar2,
776: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
777: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
778: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
779: x_return_status OUT nocopy varchar2,
780: x_error_message OUT nocopy varchar2)
781: IS
774: p_copy_ext_attribs IN varchar2,
775: p_copy_inst_children IN varchar2,
776: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
777: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
778: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
779: x_return_status OUT nocopy varchar2,
780: x_error_message OUT nocopy varchar2)
781: IS
782:
791: copy_inst_children varchar2(1));
792:
793: l_fa_flow varchar2(1);
794: l_copy_flags_rec copy_flags_rec;
795: l_instance_rec csi_datastructures_pub.instance_rec;
796:
797: l_miss_num number := fnd_api.g_miss_num;
798: l_miss_char varchar2(200) := fnd_api.g_miss_char;
799:
796:
797: l_miss_num number := fnd_api.g_miss_num;
798: l_miss_char varchar2(200) := fnd_api.g_miss_char;
799:
800: l_instance_tbl csi_datastructures_pub.instance_tbl;
801:
802: o_ind binary_integer := 0;
803: o_instance_tbl csi_datastructures_pub.instance_tbl;
804:
799:
800: l_instance_tbl csi_datastructures_pub.instance_tbl;
801:
802: o_ind binary_integer := 0;
803: o_instance_tbl csi_datastructures_pub.instance_tbl;
804:
805: ia_ind binary_integer := 0;
806: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
807:
802: o_ind binary_integer := 0;
803: o_instance_tbl csi_datastructures_pub.instance_tbl;
804:
805: ia_ind binary_integer := 0;
806: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
807:
808: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
809: l_msg_count number;
810: l_msg_data varchar2(4000);
819: l_area_id number;
820:
821: PROCEDURE do_copy(
822: p_fa_flow IN varchar2,
823: p_instance_rec IN csi_datastructures_pub.instance_rec,
824: p_copy_flags_rec IN copy_flags_rec,
825: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
826: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
827: x_return_status OUT nocopy varchar2)
821: PROCEDURE do_copy(
822: p_fa_flow IN varchar2,
823: p_instance_rec IN csi_datastructures_pub.instance_rec,
824: p_copy_flags_rec IN copy_flags_rec,
825: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
826: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
827: x_return_status OUT nocopy varchar2)
828: IS
829: l_instance_tbl csi_datastructures_pub.instance_tbl;
822: p_fa_flow IN varchar2,
823: p_instance_rec IN csi_datastructures_pub.instance_rec,
824: p_copy_flags_rec IN copy_flags_rec,
825: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
826: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
827: x_return_status OUT nocopy varchar2)
828: IS
829: l_instance_tbl csi_datastructures_pub.instance_tbl;
830: l_internal_party_id number;
825: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
826: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
827: x_return_status OUT nocopy varchar2)
828: IS
829: l_instance_tbl csi_datastructures_pub.instance_tbl;
830: l_internal_party_id number;
831:
832: l_instance_rec csi_datastructures_pub.instance_rec;
833: l_party_tbl csi_datastructures_pub.party_tbl;
828: IS
829: l_instance_tbl csi_datastructures_pub.instance_tbl;
830: l_internal_party_id number;
831:
832: l_instance_rec csi_datastructures_pub.instance_rec;
833: l_party_tbl csi_datastructures_pub.party_tbl;
834: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
835: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
836: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
829: l_instance_tbl csi_datastructures_pub.instance_tbl;
830: l_internal_party_id number;
831:
832: l_instance_rec csi_datastructures_pub.instance_rec;
833: l_party_tbl csi_datastructures_pub.party_tbl;
834: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
835: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
836: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
837: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
830: l_internal_party_id number;
831:
832: l_instance_rec csi_datastructures_pub.instance_rec;
833: l_party_tbl csi_datastructures_pub.party_tbl;
834: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
835: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
836: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
837: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
838: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
831:
832: l_instance_rec csi_datastructures_pub.instance_rec;
833: l_party_tbl csi_datastructures_pub.party_tbl;
834: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
835: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
836: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
837: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
838: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
839: l_inst_id_lst csi_datastructures_pub.id_tbl;
832: l_instance_rec csi_datastructures_pub.instance_rec;
833: l_party_tbl csi_datastructures_pub.party_tbl;
834: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
835: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
836: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
837: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
838: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
839: l_inst_id_lst csi_datastructures_pub.id_tbl;
840:
833: l_party_tbl csi_datastructures_pub.party_tbl;
834: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
835: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
836: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
837: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
838: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
839: l_inst_id_lst csi_datastructures_pub.id_tbl;
840:
841: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
834: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
835: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
836: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
837: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
838: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
839: l_inst_id_lst csi_datastructures_pub.id_tbl;
840:
841: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
842: l_msg_count number;
835: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
836: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
837: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
838: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
839: l_inst_id_lst csi_datastructures_pub.id_tbl;
840:
841: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
842: l_msg_count number;
843: l_msg_data varchar2(4000);
871: END IF;
872:
873: IF nvl(p_fa_flow, 'N') = 'Y' THEN
874:
875: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
876: csi_gen_utility_pvt.populate_install_param_rec;
877: END IF;
878:
879: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
875: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
876: csi_gen_utility_pvt.populate_install_param_rec;
877: END IF;
878:
879: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
880:
881: l_party_tbl.delete;
882:
883: SELECT instance_party_id,
1184:
1185: --
1186: PROCEDURE associate_item_instance(
1187: p_fixed_asset_rec IN fixed_asset_rec,
1188: p_instance_tbl IN csi_datastructures_pub.instance_tbl,
1189: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1190: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
1191: x_return_status OUT nocopy varchar2,
1192: x_error_message OUT nocopy varchar2)
1185: --
1186: PROCEDURE associate_item_instance(
1187: p_fixed_asset_rec IN fixed_asset_rec,
1188: p_instance_tbl IN csi_datastructures_pub.instance_tbl,
1189: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1190: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
1191: x_return_status OUT nocopy varchar2,
1192: x_error_message OUT nocopy varchar2)
1193: IS
1186: PROCEDURE associate_item_instance(
1187: p_fixed_asset_rec IN fixed_asset_rec,
1188: p_instance_tbl IN csi_datastructures_pub.instance_tbl,
1189: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1190: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
1191: x_return_status OUT nocopy varchar2,
1192: x_error_message OUT nocopy varchar2)
1193: IS
1194:
1195: l_fa_location_id number;
1196: l_fa_quantity number;
1197: l_fa_book_type_code varchar2(30);
1198:
1199: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1200: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1201: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1202: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1203: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1312: x_error_message := dump_error_stack;
1313: END associate_item_instance;
1314:
1315: PROCEDURE update_asset_association(
1316: p_instance_asset_tbl IN csi_datastructures_pub.instance_asset_tbl,
1317: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1318: x_return_status OUT nocopy varchar2,
1319: x_error_message OUT nocopy varchar2)
1320: IS
1313: END associate_item_instance;
1314:
1315: PROCEDURE update_asset_association(
1316: p_instance_asset_tbl IN csi_datastructures_pub.instance_asset_tbl,
1317: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1318: x_return_status OUT nocopy varchar2,
1319: x_error_message OUT nocopy varchar2)
1320: IS
1321:
1318: x_return_status OUT nocopy varchar2,
1319: x_error_message OUT nocopy varchar2)
1320: IS
1321:
1322: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
1323: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1324: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1325: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1326: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1402: x_error_message := dump_error_stack;
1403: END update_asset_association;
1404:
1405: PROCEDURE create_instance_assets(
1406: px_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,
1407: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1408: x_return_status OUT nocopy varchar2,
1409: x_error_message OUT nocopy varchar2)
1410: IS
1403: END update_asset_association;
1404:
1405: PROCEDURE create_instance_assets(
1406: px_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,
1407: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1408: x_return_status OUT nocopy varchar2,
1409: x_error_message OUT nocopy varchar2)
1410: IS
1411:
1409: x_error_message OUT nocopy varchar2)
1410: IS
1411:
1412: l_fixed_asset_rec fixed_asset_rec;
1413: l_instance_rec csi_datastructures_pub.instance_rec;
1414: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1415: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1416: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1417: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;