APPS.CSI_WIP_TRXS_PKG dependencies on WIP_ENTITIES

Line 225: FROM wip_entities

221: SELECT substr(wip_entity_name,1,50) wip_entity_name,
222: entity_type
223: INTO l_txn_ref.wip_entity_name,
224: l_txn_ref.wip_entity_type
225: FROM wip_entities
226: WHERE wip_entity_id = l_txn_ref.wip_entity_id
227: AND organization_id = l_txn_ref.organization_id;
228:
229: BEGIN

Line 4360: FROM wip_entities

4356: api_log('delink_replacerebuilds');
4357:
4358: SELECT entity_type
4359: INTO l_entity_type
4360: FROM wip_entities
4361: WHERE wip_entity_id = p_wip_entity_id
4362: AND organization_id = p_organization_id;
4363:
4364: --Added if condition for bug 7363267, EAM_Utility_Grp.Get_ReplacedRebuilds

Line 6767: FROM wip_entities

6763: debug(' wip_entity_id :'||p_wip_entity_id);
6764:
6765: SELECT wip_entity_name
6766: INTO l_wip_entity_name
6767: FROM wip_entities
6768: WHERE wip_entity_id = p_wip_entity_id;
6769:
6770: debug(' wip_entity_name :'||l_wip_entity_name);
6771:

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

6770: debug(' wip_entity_name :'||l_wip_entity_name);
6771:
6772: x_return_status := fnd_api.g_ret_sts_success;
6773:
6774: l_tl_query_rec.source_transaction_table := 'WIP_ENTITIES';
6775: l_tl_query_rec.source_transaction_id := p_wip_entity_id;
6776: l_tld_query_rec.processing_status := 'UNPROCESSED';
6777:
6778: --get_transaction_details

Line 6987: FROM wip_entities

6983: l_csi_txn_rec.source_header_ref_id := p_wip_entity_id;
6984:
6985: SELECT wip_entity_name
6986: INTO l_csi_txn_rec.source_header_ref
6987: FROM wip_entities
6988: WHERE wip_entity_id = p_wip_entity_id
6989: AND organization_id = p_organization_id;
6990:
6991: l_csi_txn_rec.transaction_status_code := 'PENDING';

Line 7130: FROM wip_entities

7126: l_csi_txn_rec.source_header_ref_id := p_wip_entity_id;
7127:
7128: SELECT wip_entity_name
7129: INTO l_csi_txn_rec.source_header_ref
7130: FROM wip_entities
7131: WHERE wip_entity_id = p_wip_entity_id
7132: AND organization_id = p_organization_id;
7133:
7134: l_csi_txn_rec.transaction_status_code := 'PENDING';