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.CSI_FA_INSTANCE_GRP dependencies on CSI_DATASTRUCTURES_PUB

Line 45: px_inst_asset_rec IN OUT nocopy csi_datastructures_pub.instance_asset_rec,

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

Line 230: p_instance_rec IN csi_datastructures_pub.instance_rec,

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,

Line 374: p_instance_rec IN csi_datastructures_pub.instance_rec,

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,

Line 376: p_party_tbl IN csi_datastructures_pub.party_tbl,

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,

Line 377: p_party_account_tbl IN csi_datastructures_pub.party_account_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,

Line 378: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_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,
382: x_error_message OUT nocopy varchar2)

Line 379: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,

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

Line 380: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_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
384:

Line 397: l_instance_tbl csi_datastructures_pub.instance_tbl;

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;

Line 398: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_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;

Line 399: l_party_tbl csi_datastructures_pub.party_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;

Line 400: l_account_tbl csi_datastructures_pub.party_account_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;

Line 401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_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;

Line 402: l_org_assignments_tbl csi_datastructures_pub.organization_units_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:

Line 403: l_instance_asset_tbl csi_datastructures_pub.instance_asset_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:
407:

Line 404: l_csi_txn_tbl csi_datastructures_pub.transaction_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:
408: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 405: l_grp_error_tbl csi_datastructures_pub.grp_error_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;
409: l_msg_count number;

Line 788: p_instance_rec IN csi_datastructures_pub.instance_rec,

784: END create_item_instance;
785:
786: PROCEDURE copy_item_instance(
787: p_fixed_asset_rec IN fixed_asset_rec,
788: p_instance_rec IN csi_datastructures_pub.instance_rec,
789: p_instance_serial_tbl IN instance_serial_tbl,
790: p_eam_rec IN eam_rec,
791: p_copy_parties IN varchar2,
792: p_copy_accounts IN varchar2,

Line 799: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

795: p_copy_asset_assignments IN varchar2,
796: p_copy_pricing_attribs IN varchar2,
797: p_copy_ext_attribs IN varchar2,
798: p_copy_inst_children IN varchar2,
799: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
800: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
801: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
802: x_return_status OUT nocopy varchar2,
803: x_error_message OUT nocopy varchar2)

Line 800: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,

796: p_copy_pricing_attribs IN varchar2,
797: p_copy_ext_attribs IN varchar2,
798: p_copy_inst_children IN varchar2,
799: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
800: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
801: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
802: x_return_status OUT nocopy varchar2,
803: x_error_message OUT nocopy varchar2)
804: IS

Line 801: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,

797: p_copy_ext_attribs IN varchar2,
798: p_copy_inst_children IN varchar2,
799: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
800: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
801: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
802: x_return_status OUT nocopy varchar2,
803: x_error_message OUT nocopy varchar2)
804: IS
805:

Line 818: l_instance_rec csi_datastructures_pub.instance_rec;

814: copy_inst_children varchar2(1));
815:
816: l_fa_flow varchar2(1);
817: l_copy_flags_rec copy_flags_rec;
818: l_instance_rec csi_datastructures_pub.instance_rec;
819:
820: l_miss_num number := fnd_api.g_miss_num;
821: l_miss_char varchar2(200) := fnd_api.g_miss_char;
822:

Line 823: l_instance_tbl csi_datastructures_pub.instance_tbl;

819:
820: l_miss_num number := fnd_api.g_miss_num;
821: l_miss_char varchar2(200) := fnd_api.g_miss_char;
822:
823: l_instance_tbl csi_datastructures_pub.instance_tbl;
824:
825: o_ind binary_integer := 0;
826: o_instance_tbl csi_datastructures_pub.instance_tbl;
827:

Line 826: o_instance_tbl csi_datastructures_pub.instance_tbl;

822:
823: l_instance_tbl csi_datastructures_pub.instance_tbl;
824:
825: o_ind binary_integer := 0;
826: o_instance_tbl csi_datastructures_pub.instance_tbl;
827:
828: ia_ind binary_integer := 0;
829: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
830:

Line 829: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;

825: o_ind binary_integer := 0;
826: o_instance_tbl csi_datastructures_pub.instance_tbl;
827:
828: ia_ind binary_integer := 0;
829: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
830:
831: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
832: l_msg_count number;
833: l_msg_data varchar2(4000);

Line 847: p_instance_rec IN csi_datastructures_pub.instance_rec,

843: --l_area_id number;
844:
845: PROCEDURE do_copy(
846: p_fa_flow IN varchar2,
847: p_instance_rec IN csi_datastructures_pub.instance_rec,
848: p_copy_flags_rec IN copy_flags_rec,
849: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
850: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
851: x_return_status OUT nocopy varchar2)

Line 849: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

845: PROCEDURE do_copy(
846: p_fa_flow IN varchar2,
847: p_instance_rec IN csi_datastructures_pub.instance_rec,
848: p_copy_flags_rec IN copy_flags_rec,
849: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
850: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
851: x_return_status OUT nocopy varchar2)
852: IS
853: l_instance_tbl csi_datastructures_pub.instance_tbl;

Line 850: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,

846: p_fa_flow IN varchar2,
847: p_instance_rec IN csi_datastructures_pub.instance_rec,
848: p_copy_flags_rec IN copy_flags_rec,
849: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
850: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
851: x_return_status OUT nocopy varchar2)
852: IS
853: l_instance_tbl csi_datastructures_pub.instance_tbl;
854: l_internal_party_id number;

Line 853: l_instance_tbl csi_datastructures_pub.instance_tbl;

849: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
850: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
851: x_return_status OUT nocopy varchar2)
852: IS
853: l_instance_tbl csi_datastructures_pub.instance_tbl;
854: l_internal_party_id number;
855:
856: l_instance_rec csi_datastructures_pub.instance_rec;
857: l_party_tbl csi_datastructures_pub.party_tbl;

Line 856: l_instance_rec csi_datastructures_pub.instance_rec;

852: IS
853: l_instance_tbl csi_datastructures_pub.instance_tbl;
854: l_internal_party_id number;
855:
856: l_instance_rec csi_datastructures_pub.instance_rec;
857: l_party_tbl csi_datastructures_pub.party_tbl;
858: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
859: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
860: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 857: l_party_tbl csi_datastructures_pub.party_tbl;

853: l_instance_tbl csi_datastructures_pub.instance_tbl;
854: l_internal_party_id number;
855:
856: l_instance_rec csi_datastructures_pub.instance_rec;
857: l_party_tbl csi_datastructures_pub.party_tbl;
858: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
859: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
860: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
861: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 858: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;

854: l_internal_party_id number;
855:
856: l_instance_rec csi_datastructures_pub.instance_rec;
857: l_party_tbl csi_datastructures_pub.party_tbl;
858: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
859: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
860: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
861: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
862: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 859: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

855:
856: l_instance_rec csi_datastructures_pub.instance_rec;
857: l_party_tbl csi_datastructures_pub.party_tbl;
858: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
859: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
860: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
861: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
862: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
863: l_inst_id_lst csi_datastructures_pub.id_tbl;

Line 860: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

856: l_instance_rec csi_datastructures_pub.instance_rec;
857: l_party_tbl csi_datastructures_pub.party_tbl;
858: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
859: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
860: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
861: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
862: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
863: l_inst_id_lst csi_datastructures_pub.id_tbl;
864:

Line 861: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

857: l_party_tbl csi_datastructures_pub.party_tbl;
858: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
859: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
860: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
861: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
862: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
863: l_inst_id_lst csi_datastructures_pub.id_tbl;
864:
865: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 862: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

858: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
859: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
860: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
861: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
862: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
863: l_inst_id_lst csi_datastructures_pub.id_tbl;
864:
865: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
866: l_msg_count number;

Line 863: l_inst_id_lst csi_datastructures_pub.id_tbl;

859: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
860: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
861: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
862: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
863: l_inst_id_lst csi_datastructures_pub.id_tbl;
864:
865: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
866: l_msg_count number;
867: l_msg_data varchar2(4000);

Line 899: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

895: END IF;
896:
897: IF nvl(p_fa_flow, 'N') = 'Y' THEN
898:
899: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
900: csi_gen_utility_pvt.populate_install_param_rec;
901: END IF;
902:
903: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

Line 903: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

899: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
900: csi_gen_utility_pvt.populate_install_param_rec;
901: END IF;
902:
903: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
904:
905: l_party_tbl.delete;
906:
907: SELECT instance_party_id,

Line 1213: p_instance_tbl IN csi_datastructures_pub.instance_tbl,

1209:
1210: --
1211: PROCEDURE associate_item_instance(
1212: p_fixed_asset_rec IN fixed_asset_rec,
1213: p_instance_tbl IN csi_datastructures_pub.instance_tbl,
1214: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1215: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
1216: x_return_status OUT nocopy varchar2,
1217: x_error_message OUT nocopy varchar2)

Line 1214: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

1210: --
1211: PROCEDURE associate_item_instance(
1212: p_fixed_asset_rec IN fixed_asset_rec,
1213: p_instance_tbl IN csi_datastructures_pub.instance_tbl,
1214: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1215: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
1216: x_return_status OUT nocopy varchar2,
1217: x_error_message OUT nocopy varchar2)
1218: IS

Line 1215: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,

1211: PROCEDURE associate_item_instance(
1212: p_fixed_asset_rec IN fixed_asset_rec,
1213: p_instance_tbl IN csi_datastructures_pub.instance_tbl,
1214: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1215: x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
1216: x_return_status OUT nocopy varchar2,
1217: x_error_message OUT nocopy varchar2)
1218: IS
1219:

Line 1224: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;

1220: l_fa_location_id number;
1221: l_fa_quantity number;
1222: l_fa_book_type_code varchar2(30);
1223:
1224: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1225: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1226: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1227: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1228: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

Line 1341: p_instance_asset_tbl IN csi_datastructures_pub.instance_asset_tbl,

1337: x_error_message := dump_error_stack;
1338: END associate_item_instance;
1339:
1340: PROCEDURE update_asset_association(
1341: p_instance_asset_tbl IN csi_datastructures_pub.instance_asset_tbl,
1342: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1343: x_return_status OUT nocopy varchar2,
1344: x_error_message OUT nocopy varchar2)
1345: IS

Line 1342: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

1338: END associate_item_instance;
1339:
1340: PROCEDURE update_asset_association(
1341: p_instance_asset_tbl IN csi_datastructures_pub.instance_asset_tbl,
1342: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1343: x_return_status OUT nocopy varchar2,
1344: x_error_message OUT nocopy varchar2)
1345: IS
1346:

Line 1347: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;

1343: x_return_status OUT nocopy varchar2,
1344: x_error_message OUT nocopy varchar2)
1345: IS
1346:
1347: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
1348: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1349: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1350: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1351: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

Line 1431: px_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,

1427: x_error_message := dump_error_stack;
1428: END update_asset_association;
1429:
1430: PROCEDURE create_instance_assets(
1431: px_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,
1432: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1433: x_return_status OUT nocopy varchar2,
1434: x_error_message OUT nocopy varchar2)
1435: IS

Line 1432: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

1428: END update_asset_association;
1429:
1430: PROCEDURE create_instance_assets(
1431: px_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,
1432: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1433: x_return_status OUT nocopy varchar2,
1434: x_error_message OUT nocopy varchar2)
1435: IS
1436:

Line 1438: l_instance_rec csi_datastructures_pub.instance_rec;

1434: x_error_message OUT nocopy varchar2)
1435: IS
1436:
1437: l_fixed_asset_rec fixed_asset_rec;
1438: l_instance_rec csi_datastructures_pub.instance_rec;
1439: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1440: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1441: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1442: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;