DBA Data[Home] [Help]

APPS.CSI_ML_UTIL_PVT dependencies on CSI_ITEM_INSTANCE_PVT

Line 1831: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

1827: l_upd_obj_id NUMBER;
1828:
1829: l_instance_rec csi_datastructures_pub.instance_rec;
1830: l_instance_id_lst csi_datastructures_pub.id_tbl;
1831: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
1832: l_location_tbl csi_item_instance_pvt.location_tbl;
1833: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
1834: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
1835: l_party_tbl csi_datastructures_pub.party_tbl;

Line 1832: l_location_tbl csi_item_instance_pvt.location_tbl;

1828:
1829: l_instance_rec csi_datastructures_pub.instance_rec;
1830: l_instance_id_lst csi_datastructures_pub.id_tbl;
1831: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
1832: l_location_tbl csi_item_instance_pvt.location_tbl;
1833: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
1834: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
1835: l_party_tbl csi_datastructures_pub.party_tbl;
1836: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 1833: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

1829: l_instance_rec csi_datastructures_pub.instance_rec;
1830: l_instance_id_lst csi_datastructures_pub.id_tbl;
1831: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
1832: l_location_tbl csi_item_instance_pvt.location_tbl;
1833: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
1834: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
1835: l_party_tbl csi_datastructures_pub.party_tbl;
1836: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1837: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 1834: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

1830: l_instance_id_lst csi_datastructures_pub.id_tbl;
1831: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
1832: l_location_tbl csi_item_instance_pvt.location_tbl;
1833: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
1834: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
1835: l_party_tbl csi_datastructures_pub.party_tbl;
1836: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1837: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
1838: l_txn_rec csi_datastructures_pub.transaction_rec;

Line 1837: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

1833: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
1834: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
1835: l_party_tbl csi_datastructures_pub.party_tbl;
1836: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1837: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
1838: l_txn_rec csi_datastructures_pub.transaction_rec;
1839: l_ii_relationship_rec_tab csi_ml_util_pvt.ii_relationship_rec_tab;
1840: l_rel_hist_tbl csi_diagnostics_pkg.T_NUM;
1841: l_txn_id_tbl csi_diagnostics_pkg.T_NUM;

Line 2049: IF csi_item_instance_pvt.check_item_instance_lock

2045: l_iface_error_text := substr(x_msg_data,1,2000);
2046: RAISE SKIP_ERROR;
2047: END;
2048: -- 2.1 Validate MACD lock functionality for object_id
2049: IF csi_item_instance_pvt.check_item_instance_lock
2050: ( p_instance_id => r_id.object_id)
2051: THEN
2052: fnd_message.set_name('CSI','CSI_LOCKED_INSTANCE');
2053: fnd_message.set_token('INSTANCE_ID',r_id.object_id);

Line 2111: IF csi_item_instance_pvt.check_item_instance_lock

2107: l_iface_error_text := substr(x_msg_data,1,2000);
2108: RAISE SKIP_ERROR;
2109: END;
2110: -- 3.1 Validate MACD lock functionality for subject_id
2111: IF csi_item_instance_pvt.check_item_instance_lock
2112: ( p_instance_id => r_id.subject_id)
2113: THEN
2114: fnd_message.set_name('CSI','CSI_LOCKED_INSTANCE');
2115: fnd_message.set_token('INSTANCE_ID',r_id.subject_id);

Line 2461: csi_item_instance_pvt.update_item_instance

2457: l_txn_rec.transaction_type_id := csi_ml_util_pvt.get_txn_type_id('OPEN_INTERFACE','CSI');
2458: l_txn_rec.transaction_date := sysdate;
2459: l_txn_rec.source_transaction_date := sysdate;
2460:
2461: csi_item_instance_pvt.update_item_instance
2462: (p_api_version => 1.0
2463: ,p_commit => fnd_api.g_false
2464: ,p_init_msg_list => fnd_api.g_false
2465: ,p_validation_level => fnd_api.g_valid_level_full

Line 2615: csi_item_instance_pvt.update_item_instance

2611: l_txn_rec.transaction_type_id := csi_ml_util_pvt.get_txn_type_id('OPEN_INTERFACE','CSI');
2612: l_txn_rec.transaction_date := sysdate;
2613: l_txn_rec.source_transaction_date := sysdate;
2614:
2615: csi_item_instance_pvt.update_item_instance
2616: (p_api_version => 1.0
2617: ,p_commit => fnd_api.g_false
2618: ,p_init_msg_list => fnd_api.g_false
2619: ,p_validation_level => fnd_api.g_valid_level_full