DBA Data[Home] [Help]

APPS.OE_SCHEDULE_UTIL dependencies on OE_SCHEDULE_LINES_TEMP

Line 2655: from oe_schedule_lines_temp

2651: --For MRP ROLLBACK logic
2652: --Only fetch new line ID
2653: CURSOR c_mrp_rollback(c_line_id number) is
2654: select line_id , schedule_action_code
2655: from oe_schedule_lines_temp
2656: where line_id = c_line_id;
2657: BEGIN
2658:
2659: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3273: for l_rec in (select * from oe_schedule_lines_temp)

3269: END IF;
3270:
3271: /*
3272: IF l_debug_level > 0 THEN
3273: for l_rec in (select * from oe_schedule_lines_temp)
3274: LOOP
3275: oe_debug_pub.add('check_split_needed() GLOBAL TEMP TABLE : ' || l_rec.line_id || ' : ' || l_rec.schedule_action_code,1);
3276: END LOOP;
3277: END IF;

Line 5297: insert into oe_schedule_lines_temp

5293: IF l_debug_level > 0 THEN
5294: oe_debug_pub.add( '6378240 : inserted the line_id into temp table '||p_x_line_rec.line_id ||' ' ||p_x_line_rec.schedule_action_code);
5295: END IF;
5296: BEGIN
5297: insert into oe_schedule_lines_temp
5298: (LINE_ID ,
5299: SCHEDULE_ACTION_CODE)
5300: values(p_x_line_rec.line_id,p_x_line_rec.schedule_action_code);
5301: EXCEPTION

Line 6688: insert into oe_schedule_lines_temp

6684: /* 8731703: Code moved to Load_Results_From_rec
6685: -- Added the following 10 lines to fix the bug 6378240
6686: oe_debug_pub.add( '6378240 : inserted the line_id into temp table '||p_x_line_rec.line_id ||' ' ||p_x_line_rec.schedule_action_code);
6687: BEGIN
6688: insert into oe_schedule_lines_temp
6689: (LINE_ID ,
6690: SCHEDULE_ACTION_CODE)
6691: values(p_x_line_rec.line_id,p_x_line_rec.schedule_action_code);
6692: EXCEPTION

Line 18526: from oe_schedule_lines_temp;

18522:
18523: l_status VARCHAR2(1);
18524: CURSOR C1 is
18525: select line_id , schedule_action_code
18526: from oe_schedule_lines_temp;
18527:
18528: BEGIN
18529:
18530: oe_debug_pub.add( '6015417,6053872 : in call_mrp_rollback ');