eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_GET_NAME dependencies on MSC_GET_NAME

Line 1: PACKAGE BODY Msc_get_name AS

1: PACKAGE BODY Msc_get_name AS
2: /* $Header: MSCGPRJB.pls 120.98.12020000.3 2012/09/20 23:34:12 pabram ship $*/
3:
4: g_plan_type number; -- Global variable to cache plan type
5:

Line 942: v_org_code := msc_get_name.org_code(arg_org_id, arg_instance_id);

938:
939: return null;
940: end if;
941:
942: v_org_code := msc_get_name.org_code(arg_org_id, arg_instance_id);
943:
944: select department_code || '/' || resource_code
945: into v_dept_resource_code
946: from msc_department_resources

Line 1110: return msc_get_name.org_code(l_org_id,arg_instance_id);

1106: from msc_interorg_ship_methods
1107: where transaction_id = arg_transaction_id
1108: and plan_id = arg_plan_id;
1109:
1110: return msc_get_name.org_code(l_org_id,arg_instance_id);
1111: end if;
1112: END;
1113:
1114: FUNCTION to_org(arg_plan_id IN NUMBER,

Line 1128: return msc_get_name.org_code(l_org_id,arg_instance_id);

1124: from msc_interorg_ship_methods
1125: where transaction_id = arg_transaction_id
1126: and plan_id = arg_plan_id;
1127:
1128: return msc_get_name.org_code(l_org_id,arg_instance_id);
1129: end if;
1130: END to_org;
1131:
1132: FUNCTION from_org_id(arg_plan_id IN NUMBER,

Line 1456: msc_get_name.action('MSC_SUPPLIES', msi.bom_item_type,

1452:
1453: CURSOR internal_sales(p_plan_id number,
1454: p_tran_id number, p_inst_id number) IS
1455: select ms.disposition_status_type,
1456: msc_get_name.action('MSC_SUPPLIES', msi.bom_item_type,
1457: msi.base_item_id, msi.wip_supply_type, ms.order_type,
1458: DECODE(ms.firm_planned_type,1,1,ms.reschedule_flag),
1459: ms.disposition_status_type,
1460: ms.new_schedule_date, ms.old_schedule_date,

Line 1598: return msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1594: IF arg_lots_exist = 2 and
1595: arg_order_type =5 and
1596: arg_quantity_rate <> 0 then
1597: -- plan generated planned order from supply schedule
1598: return msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1599: END IF;
1600:
1601: IF NVL(arg_release_time_fence_code,-1) = 7 THEN
1602: -- Shikyu item

Line 1603: return msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1599: END IF;
1600:
1601: IF NVL(arg_release_time_fence_code,-1) = 7 THEN
1602: -- Shikyu item
1603: return msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1604: END IF;
1605:
1606: IF arg_base_item_id IS NOT NULL
1607: OR arg_wip_supply_type = 6 THEN

Line 1629: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1625: arg_order_type IN (7, 14, 15, 16, 17, 18, 19, 27, 28)
1626: THEN
1627:
1628: -- Model Option Class
1629: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1630:
1631: ELSE
1632:
1633: IF arg_rescheduled_flag = 1 and arg_order_type not in (5,51) THEN

Line 1636: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1632:
1633: IF arg_rescheduled_flag = 1 and arg_order_type not in (5,51) THEN
1634:
1635: -- already took action
1636: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1637:
1638: ELSIF arg_disposition_status_type = 2 THEN
1639: -- Cancel order
1640: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',1);

Line 1640: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',1);

1636: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1637:
1638: ELSIF arg_disposition_status_type = 2 THEN
1639: -- Cancel order
1640: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',1);
1641:
1642: --pabram.srp.changes.added 76,77,78
1643: ELSIF arg_order_type in (5,51,13,76,77,78,79) THEN
1644: IF (NVL(arg_implemented_quantity, 0) +

Line 1652: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1648:
1649: -- nvl(arg_firm_quantity, is added for partial release
1650: -- Planned order has been released
1651: -- set action to none
1652: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1653:
1654: ELSIF arg_order_type = 51 and
1655: nvl(arg_part_condition,1) = 2 THEN
1656: -- 6676007, defective part, set action to none

Line 1657: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1653:
1654: ELSIF arg_order_type = 51 and
1655: nvl(arg_part_condition,1) = 2 THEN
1656: -- 6676007, defective part, set action to none
1657: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1658:
1659: -- we should only allow the release of defective as long as it is not
1660: -- move-in line transfer . Bug 10434727
1661: OPEN transfer_order_ok_to_release;

Line 1665: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',4);

1661: OPEN transfer_order_ok_to_release;
1662: FETCH transfer_order_ok_to_release INTO l_transfer_ok_to_release;
1663: CLOSE transfer_order_ok_to_release;
1664: if l_transfer_ok_to_release = 1 then
1665: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',4);
1666: else
1667: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1668: end if;
1669:

Line 1667: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1663: CLOSE transfer_order_ok_to_release;
1664: if l_transfer_ok_to_release = 1 then
1665: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',4);
1666: else
1667: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1668: end if;
1669:
1670: ELSE
1671: -- Release

Line 1672: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',4);

1668: end if;
1669:
1670: ELSE
1671: -- Release
1672: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',4);
1673:
1674: END IF;
1675:
1676: ELSIF nvl(arg_reschedule_days,0) <> 0 THEN

Line 1680: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1676: ELSIF nvl(arg_reschedule_days,0) <> 0 THEN
1677: --bug#1979161, new_due_date might differ from old_due_date due to nonworking
1678: -- day issue
1679: IF (arg_order_type in (8,11,12) ) then
1680: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1681: ELSE
1682: --bug5984599, need to check if they are in same planning bucket
1683: OPEN bkt_c(trunc(arg_new_due_date));
1684: FETCH bkt_c INTO p_new_date_index;

Line 1693: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1689: CLOSE bkt_c;
1690:
1691: IF p_new_date_index = p_old_date_index THEN
1692:
1693: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1694:
1695: ELSIF trunc(arg_new_due_date) > trunc(arg_old_due_date) THEN
1696: -- p_old_date_index could be null, if so, use old logic
1697:

Line 1699: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',3);

1695: ELSIF trunc(arg_new_due_date) > trunc(arg_old_due_date) THEN
1696: -- p_old_date_index could be null, if so, use old logic
1697:
1698: -- Reschedule out
1699: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',3);
1700:
1701: ELSIF trunc(arg_new_due_date) < trunc(arg_old_due_date) THEN
1702:
1703: -- Reschedule in

Line 1704: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',2);

1700:
1701: ELSIF trunc(arg_new_due_date) < trunc(arg_old_due_date) THEN
1702:
1703: -- Reschedule in
1704: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',2);
1705: ELSE
1706: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1707: END IF;
1708: END IF;

Line 1706: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1702:
1703: -- Reschedule in
1704: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',2);
1705: ELSE
1706: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1707: END IF;
1708: END IF;
1709: ELSIF arg_order_type in (4,13) THEN
1710: IF arg_bom_item_type IN (1, 2, 3, 5) THEN

Line 1713: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1709: ELSIF arg_order_type in (4,13) THEN
1710: IF arg_bom_item_type IN (1, 2, 3, 5) THEN
1711:
1712: -- Model option class
1713: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1714:
1715: ELSE
1716:
1717: -- Release

Line 1718: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',4);

1714:
1715: ELSE
1716:
1717: -- Release
1718: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',4);
1719: END IF;
1720: ELSE
1721:
1722: -- Action is not required.

Line 1723: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1719: END IF;
1720: ELSE
1721:
1722: -- Action is not required.
1723: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1724: END IF;
1725: END IF;
1726: -- action should be set to NONE for the critical components
1727: -- Plan type = MPS, item attribute <>( MPS planning or MPS/DRP planning),

Line 1739: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1735:
1736: IF l_plan_type = 2 and -- MPS
1737: arg_mrp_planning_code not in (4,8 ) THEN
1738:
1739: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1740:
1741: ELSIF l_plan_type = 3 and -- DRP
1742: arg_mrp_planning_code NOT in (9, 7, 8) THEN
1743:

Line 1744: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1740:
1741: ELSIF l_plan_type = 3 and -- DRP
1742: arg_mrp_planning_code NOT in (9, 7, 8) THEN
1743:
1744: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1745:
1746: END IF;
1747: END IF;
1748:

Line 1762: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1758: fetch duplicate_comp into l_duplicates;
1759: close duplicate_comp;
1760:
1761: if l_duplicates > 1 then
1762: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1763: else
1764: -- ok to release Repair work order
1765: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',4);
1766: end if;

Line 1765: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',4);

1761: if l_duplicates > 1 then
1762: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1763: else
1764: -- ok to release Repair work order
1765: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',4);
1766: end if;
1767: ELSE
1768: -- do not release Repair work order
1769: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

Line 1769: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1765: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',4);
1766: end if;
1767: ELSE
1768: -- do not release Repair work order
1769: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1770: END IF;
1771: END IF;
1772: ELSE
1773:

Line 1775: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1771: END IF;
1772: ELSE
1773:
1774: -- This record does note come from MSC_SUPPLIES
1775: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1776: IF NVL(arg_release_time_fence_code,-1) = 7 THEN
1777: -- Shikyu item
1778: RETURN l_action;
1779: END IF;

Line 1791: -- l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',1);

1787: FETCH internal_sales INTO v_temp, v_ir_action;
1788: CLOSE internal_sales;
1789: -- IRproject
1790: --if v_temp = 2 then -- cancel
1791: -- l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',1);
1792: if arg_bom_item_type in ( 5, 1) and -- plan_type
1793: v_ir_action is not null then -- use action from related IR
1794: l_action := v_ir_action;
1795: if arg_rescheduled_flag = 1 then -- already reschedule

Line 1797: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1793: v_ir_action is not null then -- use action from related IR
1794: l_action := v_ir_action;
1795: if arg_rescheduled_flag = 1 then -- already reschedule
1796: -- none
1797: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1798: end if;
1799:
1800: else
1801: if arg_rescheduled_flag = 1 then -- already reschedule

Line 1803: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1799:
1800: else
1801: if arg_rescheduled_flag = 1 then -- already reschedule
1802: -- none
1803: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1804: elsif (arg_bom_item_type >100) and (arg_implemented_quantity is not null) then
1805: --original demand_id
1806: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1807: /*elsif arg_quantity_rate <>

Line 1806: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1802: -- none
1803: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1804: elsif (arg_bom_item_type >100) and (arg_implemented_quantity is not null) then
1805: --original demand_id
1806: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1807: /*elsif arg_quantity_rate <>
1808: nvl(arg_firm_quantity, -- old_demand_qty
1809: arg_quantity_rate) then
1810: -- can not release split so, bug6122088

Line 1812: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1808: nvl(arg_firm_quantity, -- old_demand_qty
1809: arg_quantity_rate) then
1810: -- can not release split so, bug6122088
1811: -- none
1812: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1813: */
1814: elsif arg_release_time_fence_code <> -- inventory_item_id
1815: arg_reschedule_days and
1816: arg_reschedule_days <> 0 then -- original_item_id

Line 1819: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',4);

1815: arg_reschedule_days and
1816: arg_reschedule_days <> 0 then -- original_item_id
1817: -- release, bug5972090
1818: -- item_id <> original_item_id and not split
1819: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',4);
1820: else
1821: if arg_bom_item_type = 5 then -- plan_type
1822: if nvl(arg_implemented_quantity,2) =1 or --sales_order_line_split
1823: nvl(arg_quantity_in_process,2) =1 then --fill_kill_flag

Line 1824: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1820: else
1821: if arg_bom_item_type = 5 then -- plan_type
1822: if nvl(arg_implemented_quantity,2) =1 or --sales_order_line_split
1823: nvl(arg_quantity_in_process,2) =1 then --fill_kill_flag
1824: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1825: return l_action;
1826: end if;
1827: end if;
1828: v_temp :=0;

Line 1836: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',4);

1832: CLOSE excp_exist;
1833:
1834: if v_temp = 1 then -- Sales Order changes excp exists
1835: -- release
1836: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',4);
1837: else
1838: -- none
1839: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1840: end if;

Line 1839: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);

1835: -- release
1836: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',4);
1837: else
1838: -- none
1839: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1840: end if;
1841: end if; -- if arg_rescheduled_flag = 1
1842: end if; -- if v_temp = 2 then -- cancel
1843: end if; -- if arg_source_table = 'MSC_DEMANDS'

Line 2519: 3, msc_get_name.job_name(dem.disposition_id, dem.plan_id, dem.sr_instance_id),

2515:
2516: cursor c_demand_order_number is
2517: SELECT NVL(dem.order_number,
2518: decode(dem.origination_type,1, to_char(dem.disposition_id),
2519: 3, msc_get_name.job_name(dem.disposition_id, dem.plan_id, dem.sr_instance_id),
2520: 22, to_char(dem.disposition_id),
2521: 29,decode(dem.plan_id, -11, msc_get_name.designator(dem.schedule_designator_id) ,
2522: decode(msi.in_source_plan,1,msc_get_name.designator(dem.schedule_designator_id,
2523: dem.forecast_set_id ),

Line 2521: 29,decode(dem.plan_id, -11, msc_get_name.designator(dem.schedule_designator_id) ,

2517: SELECT NVL(dem.order_number,
2518: decode(dem.origination_type,1, to_char(dem.disposition_id),
2519: 3, msc_get_name.job_name(dem.disposition_id, dem.plan_id, dem.sr_instance_id),
2520: 22, to_char(dem.disposition_id),
2521: 29,decode(dem.plan_id, -11, msc_get_name.designator(dem.schedule_designator_id) ,
2522: decode(msi.in_source_plan,1,msc_get_name.designator(dem.schedule_designator_id,
2523: dem.forecast_set_id ),
2524: msc_get_name.scenario_designator(dem.forecast_set_id, dem.plan_id, dem.organization_id, dem.sr_instance_id)
2525: || decode(msc_get_name.designator(dem.schedule_designator_id,dem.forecast_set_id ), null, null, '/'||msc_get_name.designator(dem.schedule_designator_id,dem.forecast_set_id )))),

Line 2522: decode(msi.in_source_plan,1,msc_get_name.designator(dem.schedule_designator_id,

2518: decode(dem.origination_type,1, to_char(dem.disposition_id),
2519: 3, msc_get_name.job_name(dem.disposition_id, dem.plan_id, dem.sr_instance_id),
2520: 22, to_char(dem.disposition_id),
2521: 29,decode(dem.plan_id, -11, msc_get_name.designator(dem.schedule_designator_id) ,
2522: decode(msi.in_source_plan,1,msc_get_name.designator(dem.schedule_designator_id,
2523: dem.forecast_set_id ),
2524: msc_get_name.scenario_designator(dem.forecast_set_id, dem.plan_id, dem.organization_id, dem.sr_instance_id)
2525: || decode(msc_get_name.designator(dem.schedule_designator_id,dem.forecast_set_id ), null, null, '/'||msc_get_name.designator(dem.schedule_designator_id,dem.forecast_set_id )))),
2526: msc_get_name.designator(dem.schedule_designator_id))) order_number

Line 2524: msc_get_name.scenario_designator(dem.forecast_set_id, dem.plan_id, dem.organization_id, dem.sr_instance_id)

2520: 22, to_char(dem.disposition_id),
2521: 29,decode(dem.plan_id, -11, msc_get_name.designator(dem.schedule_designator_id) ,
2522: decode(msi.in_source_plan,1,msc_get_name.designator(dem.schedule_designator_id,
2523: dem.forecast_set_id ),
2524: msc_get_name.scenario_designator(dem.forecast_set_id, dem.plan_id, dem.organization_id, dem.sr_instance_id)
2525: || decode(msc_get_name.designator(dem.schedule_designator_id,dem.forecast_set_id ), null, null, '/'||msc_get_name.designator(dem.schedule_designator_id,dem.forecast_set_id )))),
2526: msc_get_name.designator(dem.schedule_designator_id))) order_number
2527: from msc_demands dem, msc_system_items msi
2528: where dem.plan_id = p_plan_id

Line 2525: || decode(msc_get_name.designator(dem.schedule_designator_id,dem.forecast_set_id ), null, null, '/'||msc_get_name.designator(dem.schedule_designator_id,dem.forecast_set_id )))),

2521: 29,decode(dem.plan_id, -11, msc_get_name.designator(dem.schedule_designator_id) ,
2522: decode(msi.in_source_plan,1,msc_get_name.designator(dem.schedule_designator_id,
2523: dem.forecast_set_id ),
2524: msc_get_name.scenario_designator(dem.forecast_set_id, dem.plan_id, dem.organization_id, dem.sr_instance_id)
2525: || decode(msc_get_name.designator(dem.schedule_designator_id,dem.forecast_set_id ), null, null, '/'||msc_get_name.designator(dem.schedule_designator_id,dem.forecast_set_id )))),
2526: msc_get_name.designator(dem.schedule_designator_id))) order_number
2527: from msc_demands dem, msc_system_items msi
2528: where dem.plan_id = p_plan_id
2529: and dem.sr_instance_id = p_inst_id

Line 2526: msc_get_name.designator(dem.schedule_designator_id))) order_number

2522: decode(msi.in_source_plan,1,msc_get_name.designator(dem.schedule_designator_id,
2523: dem.forecast_set_id ),
2524: msc_get_name.scenario_designator(dem.forecast_set_id, dem.plan_id, dem.organization_id, dem.sr_instance_id)
2525: || decode(msc_get_name.designator(dem.schedule_designator_id,dem.forecast_set_id ), null, null, '/'||msc_get_name.designator(dem.schedule_designator_id,dem.forecast_set_id )))),
2526: msc_get_name.designator(dem.schedule_designator_id))) order_number
2527: from msc_demands dem, msc_system_items msi
2528: where dem.plan_id = p_plan_id
2529: and dem.sr_instance_id = p_inst_id
2530: and dem.demand_id = p_demand_id

Line 2698: 29, msc_get_name.scenario_designator(

2694: cursor demand_c is
2695: select nvl(order_number,
2696: decode(origination_type,
2697: 1,to_char(disposition_id),
2698: 29, msc_get_name.scenario_designator(
2699: forecast_set_id,plan_id,organization_id,sr_instance_id),
2700: msc_get_name.designator(schedule_designator_id)
2701: )
2702: )

Line 2700: msc_get_name.designator(schedule_designator_id)

2696: decode(origination_type,
2697: 1,to_char(disposition_id),
2698: 29, msc_get_name.scenario_designator(
2699: forecast_set_id,plan_id,organization_id,sr_instance_id),
2700: msc_get_name.designator(schedule_designator_id)
2701: )
2702: )
2703: from msc_demands
2704: where plan_id = p_plan_id

Line 3908: decode(substr(msc_get_name.get_order_number( l_sr_instance_id,

3904: to_char(l_transaction_id),
3905: l_order_number||' '||to_char(l_transaction_id)) ,
3906: 14, decode(l_plan_id,
3907: -1, l_order_number,
3908: decode(substr(msc_get_name.get_order_number( l_sr_instance_id,
3909: l_plan_id, l_disposition_id, 1),1,240),
3910: null, to_char(l_disposition_id),
3911: substr(msc_get_name.get_order_number(l_sr_instance_id, l_plan_id,
3912: l_disposition_id, 1),1,240)||' ' || to_char(l_disposition_id))),

Line 3911: substr(msc_get_name.get_order_number(l_sr_instance_id, l_plan_id,

3907: -1, l_order_number,
3908: decode(substr(msc_get_name.get_order_number( l_sr_instance_id,
3909: l_plan_id, l_disposition_id, 1),1,240),
3910: null, to_char(l_disposition_id),
3911: substr(msc_get_name.get_order_number(l_sr_instance_id, l_plan_id,
3912: l_disposition_id, 1),1,240)||' ' || to_char(l_disposition_id))),
3913: 17, decode(substr(msc_get_name.get_order_number(
3914: l_sr_instance_id,
3915: l_plan_id,

Line 3913: 17, decode(substr(msc_get_name.get_order_number(

3909: l_plan_id, l_disposition_id, 1),1,240),
3910: null, to_char(l_disposition_id),
3911: substr(msc_get_name.get_order_number(l_sr_instance_id, l_plan_id,
3912: l_disposition_id, 1),1,240)||' ' || to_char(l_disposition_id))),
3913: 17, decode(substr(msc_get_name.get_order_number(
3914: l_sr_instance_id,
3915: l_plan_id,
3916: l_disposition_id,
3917: 1),1,240), null, to_char(l_disposition_id),

Line 3918: substr(msc_get_name.get_order_number(

3914: l_sr_instance_id,
3915: l_plan_id,
3916: l_disposition_id,
3917: 1),1,240), null, to_char(l_disposition_id),
3918: substr(msc_get_name.get_order_number(
3919: l_sr_instance_id,
3920: l_plan_id,
3921: l_disposition_id,
3922: 1),1,240)||' ' || to_char(l_disposition_id)),

Line 4035: l_order_num_temp:= substr(msc_get_name.get_order_number

4031: else
4032: l_order_num := p_order_number||' '||to_char(p_transaction_id);
4033: end if;
4034: Elsif p_order_type in (14, 17) THEN
4035: l_order_num_temp:= substr(msc_get_name.get_order_number
4036: (p_sr_instance_id,
4037: p_plan_id,
4038: p_disposition_id, 1), 1, 240);
4039: if l_order_num_temp is null then

Line 4533: l_supply_order_number := msc_get_name.supply_order_number(l_order_type,

4529: open curr_supply(p_plan_id,p_inst_id ,p_trans_id) ;
4530: fetch curr_supply into l_order_number ,l_order_type ,l_disposition_id;
4531: close curr_supply;
4532:
4533: l_supply_order_number := msc_get_name.supply_order_number(l_order_type,
4534: l_order_number,
4535: p_plan_id ,
4536: p_inst_id,
4537: p_trans_id ,

Line 4563: l_supply_item := msc_get_name.item_name(l_inventory_item_id,

4559: open curr_supply(p_plan_id,p_inst_id ,p_trans_id) ;
4560: fetch curr_supply into l_inventory_item_id ,l_organization_id;
4561: close curr_supply;
4562:
4563: l_supply_item := msc_get_name.item_name(l_inventory_item_id,
4564: l_organization_id,
4565: p_trans_id,
4566: p_inst_id);
4567: return l_supply_item ;

Line 4579: select msc_get_name.org_code(organization_id , sr_instance_id )

4575: is
4576: l_supply_org_code varchar2(100);
4577:
4578: cursor curr_supply(p_curr_plan_id number , p_curr_inst_id number , p_curr_trans_id number) is
4579: select msc_get_name.org_code(organization_id , sr_instance_id )
4580: from msc_supplies
4581: where plan_id = p_curr_plan_id
4582: and sr_instance_id = p_curr_inst_id
4583: and transaction_id = p_curr_trans_id;

Line 5079: msc_get_name.check_cfm(

5075: IF p_cfm_routing_flag IS NULL and
5076: ((p_order_type = 5 and p_implement_as = 3) or
5077: p_order_type = 3) THEN
5078: v_cfm_routing_flag :=
5079: msc_get_name.check_cfm(
5080: p_plan_id,
5081: p_organization_id,
5082: p_sr_instance_id,
5083: p_item_id,

Line 5835: msc_get_name.action_id('MSC_SUPPLIES', msi.bom_item_type,

5831:
5832: CURSOR internal_sales(p_plan_id number,
5833: p_tran_id number, p_inst_id number) IS
5834: select ms.disposition_status_type,
5835: msc_get_name.action_id('MSC_SUPPLIES', msi.bom_item_type,
5836: msi.base_item_id, msi.wip_supply_type, ms.order_type,
5837: DECODE(ms.firm_planned_type,1,1,ms.reschedule_flag),
5838: ms.disposition_status_type,
5839: ms.new_schedule_date, ms.old_schedule_date,

Line 6073: -- l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',1);

6069: FETCH internal_sales INTO v_temp, v_ir_action;
6070: CLOSE internal_sales;
6071: -- IRproject
6072: --if v_temp = 2 then -- cancel
6073: -- l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',1);
6074: if arg_bom_item_type in ( 5, 1) and -- plan_type
6075: v_ir_action is not null then -- use action from related IR
6076: l_action := v_ir_action;
6077: else

Line 6402: return msc_get_name.lookup_meaning('MSC_MAINTENANCE_PLAN_TYPES', 1);

6398:
6399: if l_maint_source is null then
6400: return null;
6401: elsif l_maint_source = 1 then
6402: return msc_get_name.lookup_meaning('MSC_MAINTENANCE_PLAN_TYPES', 1);
6403: elsif l_maint_source = 2 then
6404: return msc_get_name.lookup_meaning('MSC_MAINTENANCE_PLAN_TYPES', 1);
6405: end if;
6406:

Line 6404: return msc_get_name.lookup_meaning('MSC_MAINTENANCE_PLAN_TYPES', 1);

6400: return null;
6401: elsif l_maint_source = 1 then
6402: return msc_get_name.lookup_meaning('MSC_MAINTENANCE_PLAN_TYPES', 1);
6403: elsif l_maint_source = 2 then
6404: return msc_get_name.lookup_meaning('MSC_MAINTENANCE_PLAN_TYPES', 1);
6405: end if;
6406:
6407: end if;
6408:

Line 6463: END Msc_get_name;

6459: return var_ship_set_name;
6460:
6461: END ship_set_name;
6462:
6463: END Msc_get_name;