[Home] [Help]
244: IF NOT (l_reference_found) THEN
245:
246: SELECT decode(p_reference_type,'P','Parent','N','Non Source','S','Source')
247: INTO l_reference_code
248: FROM sys.dual;
249:
250: fnd_message.set_name('CSI','CSI_TXN_SRC_REF_NOT_FOUND');
251: fnd_message.set_token('REF_TYPE',l_reference_code);
252: fnd_msg_pub.add;
3441: /* check if the returned item is a nonserial item which has children */
3442: BEGIN
3443: SELECT 'Y'
3444: INTO l_config_return
3445: FROM sys.dual
3446: WHERE exists (SELECT relationship_id
3447: FROM csi_ii_relationships
3448: WHERE object_id = l_u_instance_rec.instance_id
3449: AND relationship_type_code = 'COMPONENT-OF');