182: WHERE list_header_id = p_hold_entity_id;
183:
184: CURSOR transaction_type_value_cur IS
185: select name
186: from oe_transaction_types
187: WHERE transaction_type_id = p_hold_entity_id;
188:
189: CURSOR source_type_value_cur IS
190: select meaning
2476: WHERE list_header_id = p_hold_source_rec.hold_entity_id;
2477: ELSIF p_hold_source_rec.hold_entity_code = 'OT' THEN
2478: SELECT 'Valid Entity'
2479: INTO l_dummy
2480: FROM oe_transaction_types
2481: WHERE transaction_type_id = p_hold_source_rec.hold_entity_id;
2482: ELSIF p_hold_source_rec.hold_entity_code = 'P' THEN
2483: SELECT 'Valid Entity'
2484: INTO l_dummy
2608: AND site_use_code = 'DELIVER_TO';
2609: ELSIF p_hold_source_rec.hold_entity_code2 in ('LT','OT') THEN
2610: SELECT 'Valid Entity'
2611: INTO l_dummy
2612: FROM oe_transaction_types
2613: WHERE transaction_type_id = p_hold_source_rec.hold_entity_id2;
2614: ELSIF p_hold_source_rec.hold_entity_code2 = 'OI' THEN
2615: SELECT 'Valid Entity'
2616: INTO l_dummy