APPS.OE_SCHEDULE_UTIL dependencies on OE_SETS

Line 1335: FROM oe_sets

1331: END IF;
1332:
1333: SELECT set_type
1334: INTO l_set_type
1335: FROM oe_sets
1336: WHERE set_id = p_set_id;
1337:
1338: OE_delayed_requests_Pvt.log_request(
1339: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

Line 1450: From oe_sets

1446: set_status, set_type
1447: Into l_schedule_ship_date,l_ship_to_org_id,l_ship_from_org_id,
1448: l_schedule_arrival_date,l_shipping_method_code,
1449: l_set_status, l_set_type
1450: From oe_sets
1451: Where set_id = nvl(p_line_rec.ship_set_id,p_line_rec.arrival_set_id);
1452:
1453: IF l_debug_level > 0 THEN
1454: oe_debug_pub.add( 'SET SCHEDULE DATE'|| L_SCHEDULE_SHIP_DATE , 1 ) ;

Line 3919: FROM OE_SETS

3915: IF p_x_line_rec.ship_set_id is not null THEN
3916: BEGIN
3917: SELECT SET_NAME
3918: INTO l_ship_set_name
3919: FROM OE_SETS
3920: WHERE set_id = p_x_line_rec.ship_set_id;
3921: EXCEPTION
3922: WHEN NO_DATA_FOUND THEN
3923: l_ship_set_name := null;

Line 3930: FROM OE_SETS

3926: IF p_x_line_rec.arrival_set_id is not null THEN
3927: BEGIN
3928: SELECT SET_NAME
3929: INTO l_arrival_set_name
3930: FROM OE_SETS
3931: WHERE set_id = p_x_line_rec.arrival_set_id;
3932: EXCEPTION
3933: WHEN NO_DATA_FOUND THEN
3934: l_arrival_set_name := null;

Line 4204: FROM OE_SETS

4200: IF p_x_line_rec.ship_set_id is not null THEN
4201: BEGIN
4202: SELECT SET_NAME
4203: INTO l_ship_set_name
4204: FROM OE_SETS
4205: WHERE set_id = p_x_line_rec.ship_set_id;
4206: EXCEPTION
4207: WHEN NO_DATA_FOUND THEN
4208: l_ship_set_name := null;

Line 4216: FROM OE_SETS

4212: IF p_x_line_rec.arrival_set_id is not null THEN
4213: BEGIN
4214: SELECT SET_NAME
4215: INTO l_arrival_set_name
4216: FROM OE_SETS
4217: WHERE set_id = p_x_line_rec.arrival_set_id;
4218: EXCEPTION
4219: WHEN NO_DATA_FOUND THEN
4220: l_arrival_set_name := null;

Line 8338: oe_debug_pub.add( 'AFTER Inserting data in OE_SETS_HISTORY table ' || x_return_status , 1 ) ;

8334: p_set_id => nvl(l_old_line_rec.ship_set_id,l_old_line_rec.arrival_set_id),
8335: x_return_status => x_return_status);
8336:
8337: IF l_debug_level > 0 THEN
8338: oe_debug_pub.add( 'AFTER Inserting data in OE_SETS_HISTORY table ' || x_return_status , 1 ) ;
8339: END IF;
8340:
8341: Log_Delete_Set_Request
8342: (p_header_id => p_x_line_rec.header_id,

Line 15115: FROM OE_SETS

15111: l_ship_set_id_1 := l_ship_set_id;
15112: BEGIN
15113: SELECT SET_NAME
15114: INTO l_ship_set_name
15115: FROM OE_SETS
15116: WHERE set_id = l_ship_set_id;
15117: EXCEPTION
15118: WHEN NO_DATA_FOUND THEN
15119: l_ship_set_name := null;

Line 15137: FROM OE_SETS

15133: THEN
15134: BEGIN
15135: SELECT SET_NAME
15136: INTO l_arrival_set_name
15137: FROM OE_SETS
15138: WHERE set_id = l_arrival_set_id;
15139: EXCEPTION
15140: WHEN NO_DATA_FOUND THEN
15141: l_arrival_set_name := null;

Line 15437: FROM OE_SETS

15433: THEN
15434: BEGIN
15435: SELECT SET_NAME
15436: INTO l_ship_set_name
15437: FROM OE_SETS
15438: WHERE set_id = l_ship_set_id;
15439: EXCEPTION
15440: WHEN NO_DATA_FOUND THEN
15441: l_ship_set_name := null;

Line 15450: FROM OE_SETS

15446: THEN
15447: BEGIN
15448: SELECT SET_NAME
15449: INTO l_arrival_set_name
15450: FROM OE_SETS
15451: WHERE set_id = l_arrival_set_id;
15452: EXCEPTION
15453: WHEN NO_DATA_FOUND THEN
15454: l_arrival_set_name := null;