APPS.CSI_WIP_TRXS_PKG dependencies on WIP_ENTITIES

Line 223: FROM wip_entities

219: SELECT wip_entity_name,
220: entity_type
221: INTO l_txn_ref.wip_entity_name,
222: l_txn_ref.wip_entity_type
223: FROM wip_entities
224: WHERE wip_entity_id = l_txn_ref.wip_entity_id
225: AND organization_id = l_txn_ref.organization_id;
226:
227: BEGIN

Line 4225: FROM wip_entities

4221: api_log('delink_replacerebuilds');
4222:
4223: SELECT entity_type
4224: INTO l_entity_type
4225: FROM wip_entities
4226: WHERE wip_entity_id = p_wip_entity_id
4227: AND organization_id = p_organization_id;
4228:
4229: --Added if condition for bug 7363267, EAM_Utility_Grp.Get_ReplacedRebuilds

Line 6561: FROM wip_entities

6557: debug(' wip_entity_id :'||p_wip_entity_id);
6558:
6559: SELECT wip_entity_name
6560: INTO l_wip_entity_name
6561: FROM wip_entities
6562: WHERE wip_entity_id = p_wip_entity_id;
6563:
6564: debug(' wip_entity_name :'||l_wip_entity_name);
6565:

Line 6568: l_tl_query_rec.source_transaction_table := 'WIP_ENTITIES';

6564: debug(' wip_entity_name :'||l_wip_entity_name);
6565:
6566: x_return_status := fnd_api.g_ret_sts_success;
6567:
6568: l_tl_query_rec.source_transaction_table := 'WIP_ENTITIES';
6569: l_tl_query_rec.source_transaction_id := p_wip_entity_id;
6570: l_tld_query_rec.processing_status := 'UNPROCESSED';
6571:
6572: --get_transaction_details

Line 6781: FROM wip_entities

6777: l_csi_txn_rec.source_header_ref_id := p_wip_entity_id;
6778:
6779: SELECT wip_entity_name
6780: INTO l_csi_txn_rec.source_header_ref
6781: FROM wip_entities
6782: WHERE wip_entity_id = p_wip_entity_id
6783: AND organization_id = p_organization_id;
6784:
6785: l_csi_txn_rec.transaction_status_code := 'PENDING';

Line 6924: FROM wip_entities

6920: l_csi_txn_rec.source_header_ref_id := p_wip_entity_id;
6921:
6922: SELECT wip_entity_name
6923: INTO l_csi_txn_rec.source_header_ref
6924: FROM wip_entities
6925: WHERE wip_entity_id = p_wip_entity_id
6926: AND organization_id = p_organization_id;
6927:
6928: l_csi_txn_rec.transaction_status_code := 'PENDING';