APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_XNP_MSGS_TEMP

Line 3225: l_object_name := l_schema_name||'.csi_xnp_msgs_temp';

3221: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3222: RAISE fnd_api.g_exc_error;
3223: END IF;
3224:
3225: l_object_name := l_schema_name||'.csi_xnp_msgs_temp';
3226:
3227: truncate_table(l_object_name);
3228:
3229: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

Line 3258: INSERT INTO csi_xnp_msgs_temp(

3254: xnp_xml_utils.decode(l_msg_text, 'MTL_TRANSACTION_ID', l_source_id);
3255: l_source_type := 'MTL_TRANSACTION_ID';
3256: END IF;
3257:
3258: INSERT INTO csi_xnp_msgs_temp(
3259: msg_id,
3260: msg_code,
3261: msg_text,
3262: msg_status,

Line 3299: FROM csi_xnp_msgs_temp

3295: source_type,
3296: creation_date,
3297: description,
3298: process_flag
3299: FROM csi_xnp_msgs_temp
3300: WHERE source_type = 'MTL_TRANSACTION_ID'
3301: AND source_id is not null;
3302:
3303: l_release number;

Line 3479: FROM csi_xnp_msgs_temp

3475: SELECT 'Y' INTO l_pending_msg_found
3476: FROM sys.dual
3477: WHERE exists (
3478: SELECT '1'
3479: FROM csi_xnp_msgs_temp
3480: WHERE source_type = 'MTL_TRANSACTION_ID'
3481: AND source_id = wip_txn_rec.mtl_txn_id
3482: AND nvl(msg_status, 'READY') <> 'PROCESSED');
3483: l_in_queue := true;

Line 3638: FROM csi_xnp_msgs_temp

3634: SELECT 'Y' INTO l_pending_msg_found
3635: FROM sys.dual
3636: WHERE exists (
3637: SELECT '1'
3638: FROM csi_xnp_msgs_temp
3639: WHERE source_type = 'MTL_TRANSACTION_ID'
3640: AND source_id = all_txn_rec.mtl_txn_id
3641: AND nvl(msg_status, 'READY') <> 'PROCESSED');
3642: l_in_queue := true;

Line 9082: FROM csi_xnp_msgs_temp

9078: SELECT 'Y' INTO l_pending_msg_found
9079: FROM sys.dual
9080: WHERE exists (
9081: SELECT '1'
9082: FROM csi_xnp_msgs_temp
9083: WHERE source_type = 'MTL_TRANSACTION_ID'
9084: AND source_id = all_txn_rec.mtl_txn_id
9085: AND nvl(msg_status, 'READY') <> 'PROCESSED');
9086: