APPS.WIP_SFCB_UTILITIES dependencies on WIP_INDICATORS_TEMP_S

Line 92: select wip_indicators_temp_s.nextval into x_main_group_id

88: End if ;
89:
90:
91: IF p_group_id IS NULL THEN
92: select wip_indicators_temp_s.nextval into x_main_group_id
93: from sys.dual ;
94: ELSE
95: x_main_group_id := p_group_id ;
96: END IF;

Line 109: select wip_indicators_temp_s.nextval into x_temp_group_id

105: p_resource_id) LOOP
106:
107: -- Generate the new Sequence for this
108: begin
109: select wip_indicators_temp_s.nextval into x_temp_group_id
110: from sys.dual ;
111: exception
112: when others then
113: x_phase := 'IV';

Line 209: select wip_indicators_temp_s.nextval into x_main_group_id

205: End if ;
206:
207:
208: IF p_group_id IS NULL THEN
209: select wip_indicators_temp_s.nextval into x_main_group_id
210: from sys.dual ;
211: ELSE
212: x_main_group_id := p_group_id ;
213: END IF;

Line 227: select wip_indicators_temp_s.nextval into x_temp_group_id

223: p_resource_id) LOOP
224:
225: -- Generate the new Sequence for this
226: begin
227: select wip_indicators_temp_s.nextval into x_temp_group_id
228: from sys.dual ;
229: exception
230: when others then
231: x_phase := 'IV';

Line 330: select wip_indicators_temp_s.nextval into x_main_group_id

326:
327:
328:
329: IF p_group_id IS NULL THEN
330: select wip_indicators_temp_s.nextval into x_main_group_id
331: from sys.dual ;
332: ELSE
333: x_main_group_id := p_group_id ;
334: END IF;

Line 347: select wip_indicators_temp_s.nextval into x_temp_group_id

343: p_resource_id) LOOP
344:
345: -- Generate the new Sequence for this
346: begin
347: select wip_indicators_temp_s.nextval into x_temp_group_id
348: from sys.dual ;
349: exception
350: when others then
351: x_phase := 'IV';

Line 459: select wip_indicators_temp_s.nextval into x_main_group_id

455: ***********************************************/
456:
457:
458: IF p_group_id IS NULL THEN
459: select wip_indicators_temp_s.nextval into x_main_group_id
460: from sys.dual ;
461: ELSE
462: x_main_group_id := p_group_id ;
463: END IF;

Line 476: select wip_indicators_temp_s.nextval into x_temp_group_id

472: p_resource_id) LOOP
473:
474: -- Generate the new Sequence for this
475: begin
476: select wip_indicators_temp_s.nextval into x_temp_group_id
477: from sys.dual ;
478: exception
479: when others then
480: x_phase := 'IV';

Line 858: select wip_indicators_temp_s.nextval into x_group_id

854: * a new group id from the sequence
855: ***********************************************/
856:
857: IF p_group_id IS NULL THEN
858: select wip_indicators_temp_s.nextval into x_group_id
859: from sys.dual ;
860: ELSE
861: x_group_id := p_group_id ;
862: END IF;

Line 1307: select wip_indicators_temp_s.nextval into x_group_id

1303: * a new group id from the sequence
1304: ***********************************************/
1305:
1306: IF p_group_id IS NULL THEN
1307: select wip_indicators_temp_s.nextval into x_group_id
1308: from sys.dual ;
1309: ELSE
1310: x_group_id := p_group_id ;
1311: END IF;