1060: EXCEPTION
1061: WHEN no_data_found THEN
1062: l_return := 'Y';
1063: END ;
1064: -- For checking resource transaction use wip_cost_txn_interface.
1065:
1066: select count(*) into l_tx_count from dual
1067: where EXISTS (SELECT transaction_id FROM wip_cost_txn_interface
1068: WHERE wip_entity_id = p_wip_entity_id
1063: END ;
1064: -- For checking resource transaction use wip_cost_txn_interface.
1065:
1066: select count(*) into l_tx_count from dual
1067: where EXISTS (SELECT transaction_id FROM wip_cost_txn_interface
1068: WHERE wip_entity_id = p_wip_entity_id
1069: AND operation_seq_num = p_op_seq_num);
1070:
1071: IF l_tx_count > 0 THEN