DBA Data[Home] [Help]

APPS.MST_WB_UTIL dependencies on OE_SETS

Line 1440: from oe_sets os

1436: where med.exception_detail_id = p_exception_detail_id
1437: and med.plan_id=p_plan_id;
1438: -- Ship_set Name
1439: select set_name into l_temp
1440: from oe_sets os
1441: where os.set_id=l_id1;
1442: fnd_message.set_token('SHIP_SET', l_temp);
1443: l_message := fnd_message.get;
1444: END IF;

Line 1457: from oe_sets os

1453: where med.exception_detail_id = p_exception_detail_id
1454: and med.plan_id=p_plan_id;
1455: --Arrival_set Name
1456: select set_name into l_temp
1457: from oe_sets os
1458: where os.set_id=l_id1;
1459: fnd_message.set_token('ARRIVAL_SET', l_temp);
1460: l_message := fnd_message.get;
1461: END IF;

Line 4944: from oe_sets os

4940: AND exception_type = P_EXCEPTION_TYPE;
4941:
4942: -- Ship_set Name
4943: select set_name into l_str1
4944: from oe_sets os
4945: where os.set_id=l_id1;
4946: fnd_message.set_token('SHIP_SET', l_str1);
4947: l_message := fnd_message.get;
4948: END IF;

Line 4961: from oe_sets os

4957: AND exception_type = P_EXCEPTION_TYPE;
4958:
4959: -- Ship_set Name
4960: select set_name into l_str1
4961: from oe_sets os
4962: where os.set_id=l_id1;
4963: fnd_message.set_token('ARRIVAL_SET', l_str1);
4964: l_message := fnd_message.get;
4965: END IF;