APPS.MSC_X_RECEIVE_CAPACITY_PKG dependencies on MSC_DESIGNATORS

Line 1712: l_mps_designator msc_designators.designator%type;

1708: p_capacity IN Number,
1709: p_refresh_number IN Number) IS
1710:
1711: l_mps_designator_id Number := -99;
1712: l_mps_designator msc_designators.designator%type;
1713: l_exist Number := 0;
1714:
1715:
1716: BEGIN

Line 1731: FROM msc_designators

1727:
1728: begin
1729: SELECT designator_id, designator
1730: INTO l_mps_designator_id, l_mps_designator
1731: FROM msc_designators
1732: WHERE sr_instance_id = p_sr_instance_id
1733: AND organization_id = p_mod_org_id
1734: AND designator_type = 2
1735: AND designator = l_mps_designator;

Line 1760: from msc_designators

1756: ELSE
1757: begin
1758: select designator
1759: into l_mps_designator
1760: from msc_designators
1761: where designator_id = p_mps_designator_id;
1762: exception
1763: when no_data_found then
1764: l_mps_designator_id := null;

Line 1808: l_desc msc_designators.description%type;

1804: l_user_id Number := fnd_global.user_id;
1805: l_refresh_number Number;
1806: l_supplier_name msc_trading_partners.partner_name%type;
1807: l_supplier_site_name msc_trading_partner_sites.tp_site_code%type;
1808: l_desc msc_designators.description%type;
1809: BEGIN
1810:
1811:
1812: LOG_MESSAGE('insert mps designator');

Line 1813: select msc_designators_s.nextval

1809: BEGIN
1810:
1811:
1812: LOG_MESSAGE('insert mps designator');
1813: select msc_designators_s.nextval
1814: into p_mps_designator_id
1815: from dual;
1816: LOG_MESSAGE('MPS Designator ' || p_mps_designator);
1817:

Line 1845: insert into msc_designators (

1841: fnd_message.set_name('MSC','MSC_PUB_MPS_DESIGNATOR');
1842: LOG_MESSAGE( fnd_message.get || ' ' || p_mps_designator || ' for supplier ' || l_desc);
1843:
1844:
1845: insert into msc_designators (
1846: designator_id,
1847: designator,
1848: organization_id,
1849: sr_instance_id,