DBA Data[Home] [Help]

APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_ITEM_INSTANCE_PUB

Line 1139: csi_item_instance_pub.get_item_instance_details (

1135: g_inst_rec.instance_id := fs_rec.instance_id;
1136:
1137: log('time stamp for old fetch : '||to_char(fs_rec.date_time_stamp, 'dd-mon-yyyy hh24:mi:ss'));
1138:
1139: csi_item_instance_pub.get_item_instance_details (
1140: p_api_version => 1.0,
1141: p_commit => fnd_api.g_false,
1142: p_init_msg_list => fnd_api.g_true,
1143: p_validation_level => fnd_api.g_valid_level_full,

Line 1183: csi_item_instance_pub.get_version_labels(

1179:
1180: g_vl_qry_rec.instance_id := g_inst_rec.instance_id;
1181:
1182: -- get the version label on that day
1183: csi_item_instance_pub.get_version_labels(
1184: p_api_version => 1.0,
1185: p_commit => fnd_api.g_false,
1186: p_init_msg_list => fnd_api.g_true,
1187: p_validation_level => fnd_api.g_valid_level_full,

Line 1214: csi_item_instance_pub.update_item_instance(

1210: x_return_status => l_return_status);
1211:
1212: l_csi_txn_rec.inv_material_transaction_id := fs_rec.mtl_txn_id;
1213:
1214: csi_item_instance_pub.update_item_instance(
1215: p_api_version => 1.0,
1216: p_commit => fnd_api.g_false,
1217: p_init_msg_list => fnd_api.g_true,
1218: p_validation_level => fnd_api.g_valid_level_full,

Line 1248: csi_item_instance_pub.update_version_label(

1244: FROM csi_i_version_labels
1245: WHERE version_label_id = l_vl_tbl(l_ind).version_label_id;
1246: END LOOP;
1247:
1248: csi_item_instance_pub.update_version_label(
1249: p_api_version => 1.0,
1250: p_commit => fnd_api.g_false,
1251: p_init_msg_list => fnd_api.g_true,
1252: p_validation_level => fnd_api.g_valid_level_full,

Line 1468: csi_item_instance_pub.get_item_instance_details (

1464: p_instance_rec.instance_id := p_instance_id;
1465: l_char_ins_id := to_char(p_instance_id);
1466:
1467: -- Call Get API with the time stamp
1468: csi_item_instance_pub.get_item_instance_details (
1469: p_api_version => 1.0,
1470: p_commit => fnd_api.g_false,
1471: p_init_msg_list => fnd_api.g_true,
1472: p_validation_level => fnd_api.g_valid_level_full,

Line 1731: csi_item_instance_pub.get_version_labels (

1727: END IF;
1728:
1729: -- Add version Label. Use Get_Version_Label API
1730: p_ver_label_query_rec.instance_id := p_instance_id;
1731: csi_item_instance_pub.get_version_labels (
1732: p_api_version => 1.0,
1733: p_commit => fnd_api.g_false,
1734: p_init_msg_list => l_init_msg_list,
1735: p_validation_level => fnd_api.g_valid_level_full,

Line 6140: csi_item_instance_pub.create_item_instance(

6136: FROM mtl_system_items
6137: WHERE inventory_item_id = l_instance_rec.inventory_item_id
6138: AND organization_id = l_instance_rec.vld_organization_id;
6139:
6140: csi_item_instance_pub.create_item_instance(
6141: p_api_version => 1.0,
6142: p_commit => fnd_api.g_false,
6143: p_init_msg_list => fnd_api.g_true,
6144: p_validation_level => fnd_api.g_valid_level_full,

Line 6300: csi_item_instance_pub.update_item_instance(

6296: INTO l_instance_rec.object_version_number
6297: FROM csi_item_instances
6298: WHERE instance_id = l_instance_rec.instance_id;
6299:
6300: csi_item_instance_pub.update_item_instance(
6301: p_api_version => 1.0,
6302: p_commit => fnd_api.g_false,
6303: p_init_msg_list => fnd_api.g_true,
6304: p_validation_level => fnd_api.g_valid_level_full,

Line 6662: csi_item_instance_pub.update_item_instance(

6658: l_instance_rec.object_version_number := l_object_version_number;
6659: l_instance_rec.active_end_date := null;
6660: l_instance_rec.instance_status_id := 3;
6661:
6662: csi_item_instance_pub.update_item_instance(
6663: p_api_version => 1.0,
6664: p_commit => fnd_api.g_false,
6665: p_init_msg_list => fnd_api.g_true,
6666: p_validation_level => fnd_api.g_valid_level_full,

Line 6717: csi_item_instance_pub.create_item_instance(

6713: l_parties_tbl(1).relationship_type_code := 'OWNER';
6714: l_parties_tbl(1).contact_flag := 'N';
6715: l_parties_tbl(1).object_version_number := 1.0;
6716:
6717: csi_item_instance_pub.create_item_instance(
6718: p_api_version => 1.0,
6719: p_commit => fnd_api.g_false,
6720: p_init_msg_list => fnd_api.g_true,
6721: p_validation_level => fnd_api.g_valid_level_full,

Line 7746: csi_item_instance_pub.update_item_instance(

7742:
7743: l_instance_rec.active_end_date := null;
7744: l_instance_rec.instance_status_id := 3;
7745:
7746: csi_item_instance_pub.update_item_instance(
7747: p_api_version => 1.0,
7748: p_commit => fnd_api.g_false,
7749: p_init_msg_list => fnd_api.g_true,
7750: p_validation_level => fnd_api.g_valid_level_full,

Line 8062: csi_item_instance_pub.update_item_instance(

8058:
8059: l_instance_rec.active_end_date := null;
8060: l_instance_rec.instance_status_id := 3;
8061:
8062: csi_item_instance_pub.update_item_instance(
8063: p_api_version => 1.0,
8064: p_commit => fnd_api.g_false,
8065: p_init_msg_list => fnd_api.g_true,
8066: p_validation_level => fnd_api.g_valid_level_full,

Line 8341: csi_item_instance_pub.update_item_instance(

8337: l_instance_rec.object_version_number := l_object_version_number;
8338: l_instance_rec.active_end_date := null;
8339: l_instance_rec.instance_status_id := 3;
8340:
8341: csi_item_instance_pub.update_item_instance(
8342: p_api_version => 1.0,
8343: p_commit => fnd_api.g_false,
8344: p_init_msg_list => fnd_api.g_true,
8345: p_validation_level => fnd_api.g_valid_level_full,

Line 8398: csi_item_instance_pub.create_item_instance(

8394: l_parties_tbl(1).relationship_type_code := 'OWNER';
8395: l_parties_tbl(1).contact_flag := 'N';
8396: l_parties_tbl(1).object_version_number := 1.0;
8397:
8398: csi_item_instance_pub.create_item_instance(
8399: p_api_version => 1.0,
8400: p_commit => fnd_api.g_false,
8401: p_init_msg_list => fnd_api.g_true,
8402: p_validation_level => fnd_api.g_valid_level_full,

Line 9202: log(' csi_item_instance_pub.update_item_instance');

9198: INTO l_instance_rec.object_version_number
9199: FROM csi_item_instances
9200: WHERE instance_id = l_instance_rec.instance_id;
9201:
9202: log(' csi_item_instance_pub.update_item_instance');
9203:
9204: csi_item_instance_pub.update_item_instance(
9205: p_api_version => 1.0,
9206: p_commit => fnd_api.g_false,

Line 9204: csi_item_instance_pub.update_item_instance(

9200: WHERE instance_id = l_instance_rec.instance_id;
9201:
9202: log(' csi_item_instance_pub.update_item_instance');
9203:
9204: csi_item_instance_pub.update_item_instance(
9205: p_api_version => 1.0,
9206: p_commit => fnd_api.g_false,
9207: p_init_msg_list => fnd_api.g_true,
9208: p_validation_level => fnd_api.g_valid_level_full,

Line 9230: log(' csi_item_instance_pub.create_item_instance');

9226: END IF;
9227:
9228: ELSE -- instance not found
9229:
9230: log(' csi_item_instance_pub.create_item_instance');
9231:
9232: csi_item_instance_pub.create_item_instance(
9233: p_api_version => 1.0,
9234: p_commit => fnd_api.g_false,

Line 9232: csi_item_instance_pub.create_item_instance(

9228: ELSE -- instance not found
9229:
9230: log(' csi_item_instance_pub.create_item_instance');
9231:
9232: csi_item_instance_pub.create_item_instance(
9233: p_api_version => 1.0,
9234: p_commit => fnd_api.g_false,
9235: p_init_msg_list => fnd_api.g_true,
9236: p_validation_level => fnd_api.g_valid_level_full,