APPS.OE_SCHEDULE_UTIL dependencies on OE_SETS

Line 1382: FROM oe_sets

1378: END IF;
1379:
1380: SELECT set_type
1381: INTO l_set_type
1382: FROM oe_sets
1383: WHERE set_id = p_set_id;
1384:
1385: OE_delayed_requests_Pvt.log_request(
1386: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

Line 1498: From oe_sets

1494: set_status, set_type
1495: Into l_schedule_ship_date,l_ship_to_org_id,l_ship_from_org_id,
1496: l_schedule_arrival_date,l_shipping_method_code,
1497: l_set_status, l_set_type
1498: From oe_sets
1499: Where set_id = nvl(p_line_rec.ship_set_id,p_line_rec.arrival_set_id);
1500:
1501: IF l_debug_level > 0 THEN
1502: oe_debug_pub.add( 'SET SCHEDULE DATE'|| L_SCHEDULE_SHIP_DATE , 1 ) ;

Line 4900: FROM OE_SETS

4896: IF p_x_line_rec.ship_set_id is not null THEN
4897: BEGIN
4898: SELECT SET_NAME
4899: INTO l_ship_set_name
4900: FROM OE_SETS
4901: WHERE set_id = p_x_line_rec.ship_set_id;
4902: EXCEPTION
4903: WHEN NO_DATA_FOUND THEN
4904: l_ship_set_name := null;

Line 4911: FROM OE_SETS

4907: IF p_x_line_rec.arrival_set_id is not null THEN
4908: BEGIN
4909: SELECT SET_NAME
4910: INTO l_arrival_set_name
4911: FROM OE_SETS
4912: WHERE set_id = p_x_line_rec.arrival_set_id;
4913: EXCEPTION
4914: WHEN NO_DATA_FOUND THEN
4915: l_arrival_set_name := null;

Line 5188: FROM OE_SETS

5184: IF p_x_line_rec.ship_set_id is not null THEN
5185: BEGIN
5186: SELECT SET_NAME
5187: INTO l_ship_set_name
5188: FROM OE_SETS
5189: WHERE set_id = p_x_line_rec.ship_set_id;
5190: EXCEPTION
5191: WHEN NO_DATA_FOUND THEN
5192: l_ship_set_name := null;

Line 5200: FROM OE_SETS

5196: IF p_x_line_rec.arrival_set_id is not null THEN
5197: BEGIN
5198: SELECT SET_NAME
5199: INTO l_arrival_set_name
5200: FROM OE_SETS
5201: WHERE set_id = p_x_line_rec.arrival_set_id;
5202: EXCEPTION
5203: WHEN NO_DATA_FOUND THEN
5204: l_arrival_set_name := null;

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

9682: p_set_id => nvl(l_old_line_rec.ship_set_id,l_old_line_rec.arrival_set_id),
9683: x_return_status => x_return_status);
9684:
9685: IF l_debug_level > 0 THEN
9686: oe_debug_pub.add( 'AFTER Inserting data in OE_SETS_HISTORY table ' || x_return_status , 1 ) ;
9687: END IF;
9688:
9689: Log_Delete_Set_Request
9690: (p_header_id => p_x_line_rec.header_id,

Line 17662: FROM OE_SETS

17658: l_ship_set_id_1 := l_ship_set_id;
17659: BEGIN
17660: SELECT SET_NAME
17661: INTO l_ship_set_name
17662: FROM OE_SETS
17663: WHERE set_id = l_ship_set_id;
17664: EXCEPTION
17665: WHEN NO_DATA_FOUND THEN
17666: l_ship_set_name := null;

Line 17684: FROM OE_SETS

17680: THEN
17681: BEGIN
17682: SELECT SET_NAME
17683: INTO l_arrival_set_name
17684: FROM OE_SETS
17685: WHERE set_id = l_arrival_set_id;
17686: EXCEPTION
17687: WHEN NO_DATA_FOUND THEN
17688: l_arrival_set_name := null;

Line 17984: FROM OE_SETS

17980: THEN
17981: BEGIN
17982: SELECT SET_NAME
17983: INTO l_ship_set_name
17984: FROM OE_SETS
17985: WHERE set_id = l_ship_set_id;
17986: EXCEPTION
17987: WHEN NO_DATA_FOUND THEN
17988: l_ship_set_name := null;

Line 17997: FROM OE_SETS

17993: THEN
17994: BEGIN
17995: SELECT SET_NAME
17996: INTO l_arrival_set_name
17997: FROM OE_SETS
17998: WHERE set_id = l_arrival_set_id;
17999: EXCEPTION
18000: WHEN NO_DATA_FOUND THEN
18001: l_arrival_set_name := null;

Line 18859: FROM oe_sets

18855: SELECT schedule_ship_date,
18856: schedule_arrival_date
18857: INTO l_ship_date,
18858: l_arrival_date
18859: FROM oe_sets
18860: WHERE set_id=p_set_id;
18861:
18862: x_set_exists := TRUE ;
18863: IF l_ship_date IS NULL