DBA Data[Home] [Help]

APPS.OE_ORDER_SCH_UTIL dependencies on OE_SETS

Line 7521: FROM OE_SETS

7517: IF l_line_rec.ship_set_id is not null THEN
7518: BEGIN
7519: SELECT SET_NAME
7520: INTO l_ship_set_name
7521: FROM OE_SETS
7522: WHERE set_id = l_line_rec.ship_set_id;
7523: EXCEPTION
7524: WHEN NO_DATA_FOUND THEN
7525: l_ship_set_name := null;

Line 7533: FROM OE_SETS

7529: IF l_line_rec.arrival_set_id is not null THEN
7530: BEGIN
7531: SELECT SET_NAME
7532: INTO l_arrival_set_name
7533: FROM OE_SETS
7534: WHERE set_id = l_line_rec.arrival_set_id;
7535: EXCEPTION
7536: WHEN NO_DATA_FOUND THEN
7537: l_arrival_set_name := null;

Line 7631: FROM OE_SETS

7627: IF l_line_rec.ship_set_id is not null THEN
7628: BEGIN
7629: SELECT SET_NAME
7630: INTO l_ship_set_name
7631: FROM OE_SETS
7632: WHERE set_id = l_line_rec.ship_set_id;
7633: EXCEPTION
7634: WHEN NO_DATA_FOUND THEN
7635: l_ship_set_name := null;

Line 7643: FROM OE_SETS

7639: IF l_line_rec.arrival_set_id is not null THEN
7640: BEGIN
7641: SELECT SET_NAME
7642: INTO l_arrival_set_name
7643: FROM OE_SETS
7644: WHERE set_id = l_line_rec.arrival_set_id;
7645: EXCEPTION
7646: WHEN NO_DATA_FOUND THEN
7647: l_arrival_set_name := null;