88: RETURN;
89: END IF;
90:
91: IF (l_debug = 'Y') THEN
92: gmd_debug.log_initialize('GMDGMEInt');
93: END IF;
94:
95: IF (l_debug = 'Y') THEN
96: gmd_debug.put_line('recipe ID ' || p_recipeid);
92: gmd_debug.log_initialize('GMDGMEInt');
93: END IF;
94:
95: IF (l_debug = 'Y') THEN
96: gmd_debug.put_line('recipe ID ' || p_recipeid);
97: gmd_debug.put_line('routing ID ' || p_routingid);
98: gmd_debug.put_line('routing step ID ' || p_routingstepid);
99: END IF;
100:
93: END IF;
94:
95: IF (l_debug = 'Y') THEN
96: gmd_debug.put_line('recipe ID ' || p_recipeid);
97: gmd_debug.put_line('routing ID ' || p_routingid);
98: gmd_debug.put_line('routing step ID ' || p_routingstepid);
99: END IF;
100:
101: /* For a given recipe id, routing id, routingstepid combination */
94:
95: IF (l_debug = 'Y') THEN
96: gmd_debug.put_line('recipe ID ' || p_recipeid);
97: gmd_debug.put_line('routing ID ' || p_routingid);
98: gmd_debug.put_line('routing step ID ' || p_routingstepid);
99: END IF;
100:
101: /* For a given recipe id, routing id, routingstepid combination */
102: OPEN C1(p_routingid,p_routingstepid,p_recipeid);
141: l_wip_spec.formulaline_id := l_formulaline_id; --Bug#6379386
142: l_step_id := l_routingstepid;
143:
144: IF (l_debug = 'Y') THEN
145: gmd_debug.put_line('Checking if WIP Spec exists ');
146: END IF;
147:
148: IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(
149: p_wip_spec_rec => l_wip_spec,
152: x_return_status => l_return_status,
153: x_message_data => l_msg_data) THEN
154:
155: IF (l_debug = 'Y') THEN
156: gmd_debug.put_line('WIP Spec exists ');
157: END IF;
158:
159: p_resultout:='S';
160: EXIT;
170: p_resultout:='F';
171: end if ;
172:
173: IF (l_debug = 'Y') THEN
174: gmd_debug.put_line('p_resultout ' || p_resultout);
175: END IF;
176:
177:
178: EXCEPTION