APPS.MSC_SUPPLY_PKG dependencies on MSC_SUPPLY_PKG

Line 1: package body msc_supply_pkg as

1: package body msc_supply_pkg as
2: /* $Header: MSCHBSUB.pls 120.28.12010000.4 2008/09/03 14:43:37 wexia ship $ */
3: /*
4: create table msc_supplies_f (
5: plan_id number not null,

Line 237: 5,decode(msc_supply_pkg.implement_code(ms.source_organization_id,ms.organization_id,

233: -- make planned order
234: -- 3,4,5,7,13,14,15,16,17,27,28,30
235: ---------------------------------------------------------------------------
236: sum(decode(ms.order_type,3, nvl(ms.NEW_SCHEDULE_DATE,null)-nvl(ms.new_wip_start_date,null),
237: 5,decode(msc_supply_pkg.implement_code(ms.source_organization_id,ms.organization_id,
238: msi.repetitive_type,ms.source_supplier_id,
239: msi.planning_make_buy_code,msi.build_in_wip_flag),
240: 3,nvl(ms.NEW_SCHEDULE_DATE,null)-nvl(ms.new_wip_start_date,null),
241: 4,nvl(ms.NEW_SCHEDULE_DATE,null)- nvl(ms.FIRST_UNIT_START_DATE,null),

Line 257: 5,decode(msc_supply_pkg.implement_code(ms.source_organization_id,ms.organization_id,

253: 88,nvl(ms.NEW_SCHEDULE_DATE,null)- nvl(ms.FIRST_UNIT_START_DATE,null),
254: to_number(null))) work_order_leadtime,
255:
256: sum(decode(ms.order_type,3,1,
257: 5,decode(msc_supply_pkg.implement_code(ms.source_organization_id,ms.organization_id,
258: msi.repetitive_type,ms.source_supplier_id,
259: msi.planning_make_buy_code,msi.build_in_wip_flag),
260: 3,1,0),
261: 7,1,

Line 278: 5, decode(msc_supply_pkg.implement_code(ms.source_organization_id,ms.organization_id,

274: 3, decode(msi.base_item_id,null,
275: decode(ms.disposition_status_type,2, 0,
276: decode(ms.last_unit_completion_date,null, ms.new_order_quantity,ms.daily_rate) ),
277: decode(ms.last_unit_completion_date,null, ms.new_order_quantity,ms.daily_rate) ),
278: 5, decode(msc_supply_pkg.implement_code(ms.source_organization_id,ms.organization_id,
279: msi.repetitive_type,ms.source_supplier_id,
280: msi.planning_make_buy_code,msi.build_in_wip_flag),
281: 3,decode(msi.base_item_id,null,
282: decode(ms.disposition_status_type,2, 0,

Line 665: 5, decode(msc_supply_pkg.implement_code(ms.source_organization_id,ms.organization_id,

661: 3, decode(msi.base_item_id,null,
662: decode(ms.disposition_status_type,2, 0,
663: decode(ms.last_unit_completion_date,null, ms.new_order_quantity,ms.daily_rate) ),
664: decode(ms.last_unit_completion_date,null, ms.new_order_quantity,ms.daily_rate) ),
665: 5, decode(msc_supply_pkg.implement_code(ms.source_organization_id,ms.organization_id,
666: msi.repetitive_type,ms.source_supplier_id,
667: msi.planning_make_buy_code,msi.build_in_wip_flag),
668: 3,decode(msi.base_item_id,null,
669: decode(ms.disposition_status_type,2, 0,

Line 709: 17,decode(msc_supply_pkg.implement_code(ms.source_organization_id,ms.organization_id,

705: 16,decode(msi.base_item_id,null,
706: decode(ms.disposition_status_type,2, 0,
707: decode(ms.last_unit_completion_date,null, ms.new_order_quantity,ms.daily_rate) ),
708: decode(ms.last_unit_completion_date,null, ms.new_order_quantity,ms.daily_rate) ),
709: 17,decode(msc_supply_pkg.implement_code(ms.source_organization_id,ms.organization_id,
710: msi.repetitive_type,ms.source_supplier_id,
711: msi.planning_make_buy_code,msi.build_in_wip_flag),
712: 3,decode(msi.base_item_id,null,
713: decode(ms.disposition_status_type,2, 0,

Line 1199: end msc_supply_pkg;

1195: else return 2;
1196: end if;
1197: end implement_code;
1198:
1199: end msc_supply_pkg;