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_GANTT_DATA dependencies on MSC_GET_GANTT_DATA

Line 1: PACKAGE BODY Msc_Get_GANTT_DATA AS

1: PACKAGE BODY Msc_Get_GANTT_DATA AS
2: /* $Header: MSCGNTDB.pls 120.1 2005/06/17 15:35:48 appldev $ */
3:
4: field_seperator varchar2(5) := '|';
5: record_seperator varchar2(5) := '&';

Line 172: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,

168: FIRM_START_RES,
169: mrr.firm_start_date + (mrr.end_date - mrr.start_date),
170: nvl(mrr.firm_end_date, mrr.end_date)),mrr.start_date)),
171: format_mask) end_date,
172: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
173: ms.plan_id, ms.sr_instance_id,
174: ms.transaction_id, ms.disposition_id)
175: ||'/'||
176: msi.item_name

Line 230: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,

226: FIRM_START_RES,
227: mrr.firm_start_date + (mrr.end_date - mrr.start_date),
228: nvl(mrr.firm_end_date, mrr.end_date))),
229: format_mask) end_date,
230: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
231: ms.plan_id, ms.sr_instance_id,
232: ms.transaction_id, ms.disposition_id)
233: ||'/'||
234: msi.item_name

Line 1822: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,

1818: ms.transaction_id,
1819: ms.organization_id,
1820: msc_get_name.org_code(mdr.organization_id, mdr.sr_instance_id) org,
1821: mdr.department_code,
1822: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
1823: ms.plan_id, ms.sr_instance_id,
1824: ms.transaction_id, ms.disposition_id) job_name,
1825: mrr.assigned_units,
1826: nvl(msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',

Line 3037: ' msc_get_gantt_data.get_start_date( ' ||

3033: ' mrr.supply_id transaction_id, ' ||
3034: ' ms.inventory_item_id, ' ||
3035: ' decode(sign(ms.new_schedule_date '||
3036: '- (ms.need_by_date+1)),1,1,2) late_order, '||
3037: ' msc_get_gantt_data.get_start_date( ' ||
3038: 'mrr.plan_id, mrr.transaction_id, ' ||
3039: ' mrr.sr_instance_id) start_date, '||
3040: ' msc_get_gantt_data.get_end_date( ' ||
3041: 'mrr.plan_id, mrr.transaction_id, ' ||

Line 3040: ' msc_get_gantt_data.get_end_date( ' ||

3036: '- (ms.need_by_date+1)),1,1,2) late_order, '||
3037: ' msc_get_gantt_data.get_start_date( ' ||
3038: 'mrr.plan_id, mrr.transaction_id, ' ||
3039: ' mrr.sr_instance_id) start_date, '||
3040: ' msc_get_gantt_data.get_end_date( ' ||
3041: 'mrr.plan_id, mrr.transaction_id, ' ||
3042: ' mrr.sr_instance_id) end_date '||
3043: ' FROM msc_resource_requirements mrr, ' ||
3044: ' msc_supplies ms, ' ||

Line 3072: ' msc_get_gantt_data.get_start_date( ' ||

3068: ' mrr.resource_id, '||
3069: ' mrr.transaction_id r_transaction_id, ' ||
3070: ' mrr.supply_id transaction_id, ' ||
3071: ' ms.inventory_item_id, ' ||
3072: ' msc_get_gantt_data.get_start_date( ' ||
3073: 'mrr.plan_id, mrr.transaction_id, ' ||
3074: ' mrr.sr_instance_id) start_date, '||
3075: ' msc_get_gantt_data.get_end_date( ' ||
3076: 'mrr.plan_id, mrr.transaction_id, ' ||

Line 3075: ' msc_get_gantt_data.get_end_date( ' ||

3071: ' ms.inventory_item_id, ' ||
3072: ' msc_get_gantt_data.get_start_date( ' ||
3073: 'mrr.plan_id, mrr.transaction_id, ' ||
3074: ' mrr.sr_instance_id) start_date, '||
3075: ' msc_get_gantt_data.get_end_date( ' ||
3076: 'mrr.plan_id, mrr.transaction_id, ' ||
3077: ' mrr.sr_instance_id) end_date '||
3078: ' FROM msc_resource_requirements mrr, ' ||
3079: ' msc_supplies ms, ' ||

Line 3761: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,

3757: Cursor peg_data_cur IS
3758: select distinct ms.organization_id,
3759: ms.transaction_id,
3760: ms.sr_instance_id,
3761: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
3762: ms.plan_id, ms.sr_instance_id,
3763: ms.transaction_id, ms.disposition_id) ||' for '||
3764: msi.item_name ||
3765: ' in ' ||mtp.organization_code ||'('||

Line 3770: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,

3766: ms.new_order_quantity||')',
3767: nvl(ms.firm_planned_type,2),
3768: nvl(ms.status, 0),
3769: nvl(ms.applied,0),
3770: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,
3771: ms.organization_id,ms.inventory_item_id,ms.transaction_id),
3772: msc_get_gantt_data.actualStartDate(ms.order_type,
3773: msi.planning_make_buy_code,
3774: ms.organization_id,

Line 3772: msc_get_gantt_data.actualStartDate(ms.order_type,

3768: nvl(ms.status, 0),
3769: nvl(ms.applied,0),
3770: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,
3771: ms.organization_id,ms.inventory_item_id,ms.transaction_id),
3772: msc_get_gantt_data.actualStartDate(ms.order_type,
3773: msi.planning_make_buy_code,
3774: ms.organization_id,
3775: ms.source_organization_id,
3776: ms.new_dock_date,

Line 3796: msc_get_gantt_data.isCriticalSupply(p_plan_id,g_end_demand_id,

3792: nvl(to_char(ms.UEPCD,format_mask),'null')),
3793: decode(g_end_demand_id, null, 'null',
3794: nvl(to_char(ms.MIN_START_DATE,format_mask), 'null')),
3795: decode(g_end_demand_id, null, 0,
3796: msc_get_gantt_data.isCriticalSupply(p_plan_id,g_end_demand_id,
3797: ms.transaction_id, ms.sr_instance_id)),
3798: msc_get_gantt_data.supplyType(ms.order_type,
3799: msi.planning_make_buy_code,
3800: ms.organization_id,

Line 3798: msc_get_gantt_data.supplyType(ms.order_type,

3794: nvl(to_char(ms.MIN_START_DATE,format_mask), 'null')),
3795: decode(g_end_demand_id, null, 0,
3796: msc_get_gantt_data.isCriticalSupply(p_plan_id,g_end_demand_id,
3797: ms.transaction_id, ms.sr_instance_id)),
3798: msc_get_gantt_data.supplyType(ms.order_type,
3799: msi.planning_make_buy_code,
3800: ms.organization_id,
3801: ms.source_organization_id),
3802: mtp.organization_code||':'||msi.item_name,

Line 3881: to_char(msc_get_gantt_data.get_start_date(

3877: ||to_char(mrr.resource_seq_num)||
3878: '('||msc_get_name.department_resource_code(mrr.resource_id,
3879: mrr.department_id, mrr.organization_id,
3880: mrr.plan_id, mrr.sr_instance_id)||')',
3881: to_char(msc_get_gantt_data.get_start_date(
3882: mrr.plan_id, mrr.transaction_id, mrr.sr_instance_id),
3883: format_mask),
3884: to_char(nvl(msc_get_gantt_data.get_end_date(
3885: mrr.plan_id, mrr.transaction_id, mrr.sr_instance_id),

Line 3884: to_char(nvl(msc_get_gantt_data.get_end_date(

3880: mrr.plan_id, mrr.sr_instance_id)||')',
3881: to_char(msc_get_gantt_data.get_start_date(
3882: mrr.plan_id, mrr.transaction_id, mrr.sr_instance_id),
3883: format_mask),
3884: to_char(nvl(msc_get_gantt_data.get_end_date(
3885: mrr.plan_id, mrr.transaction_id, mrr.sr_instance_id),
3886: mrr.start_date),
3887: format_mask),
3888: mrr.transaction_id,

Line 3894: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,

3890: nvl(mrr.resource_id, 0),
3891: nvl(mrr.status, 0),
3892: nvl(mrr.applied, 0),
3893: nvl(mrr.firm_flag, 0),
3894: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,
3895: ms.organization_id,ms.inventory_item_id,ms.transaction_id),
3896: decode(g_end_demand_id, null, 'null',
3897: nvl(to_char(mrr.EARLIEST_START_DATE,format_mask),'null')),
3898: decode(g_end_demand_id, null, 'null',

Line 3911: msc_get_gantt_data.isCriticalRes(p_plan_id,g_end_demand_id,

3907: nvl(to_char(mrr.UEPCD,format_mask),'null')),
3908: decode(g_end_demand_id, null, 'null',
3909: nvl(to_char(ms.MIN_START_DATE,format_mask), 'null')),
3910: decode(g_end_demand_id, null, 0,
3911: msc_get_gantt_data.isCriticalRes(p_plan_id,g_end_demand_id,
3912: ms.transaction_id, ms.sr_instance_id,
3913: mrr.operation_seq_num, mrr.routing_sequence_id))
3914: from msc_resource_requirements mrr,
3915: msc_supplies ms

Line 4247: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,

4243: ms.inventory_item_id,
4244: nvl(ms.firm_planned_type,2),
4245: nvl(ms.status, 0),
4246: nvl(ms.applied,0),
4247: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,
4248: ms.organization_id,ms.inventory_item_id,ms.transaction_id),
4249: ms.new_order_quantity,
4250: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
4251: ms.plan_id, ms.sr_instance_id,

Line 4250: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,

4246: nvl(ms.applied,0),
4247: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,
4248: ms.organization_id,ms.inventory_item_id,ms.transaction_id),
4249: ms.new_order_quantity,
4250: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
4251: ms.plan_id, ms.sr_instance_id,
4252: ms.transaction_id, ms.disposition_id),
4253: msc_get_gantt_data.actualStartDate(ms.order_type,
4254: msi.planning_make_buy_code,

Line 4253: msc_get_gantt_data.actualStartDate(ms.order_type,

4249: ms.new_order_quantity,
4250: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
4251: ms.plan_id, ms.sr_instance_id,
4252: ms.transaction_id, ms.disposition_id),
4253: msc_get_gantt_data.actualStartDate(ms.order_type,
4254: msi.planning_make_buy_code,
4255: ms.organization_id,
4256: ms.source_organization_id,
4257: ms.new_dock_date,

Line 4270: msc_get_gantt_data.supplyType(ms.order_type,

4266: nvl(to_char(ms.MIN_START_DATE,format_mask), 'null'),
4267: nvl(to_char(ms.UEPSD,format_mask),'null'),
4268: nvl(to_char(ms.UEPCD,format_mask),'null'),
4269: 1,
4270: msc_get_gantt_data.supplyType(ms.order_type,
4271: msi.planning_make_buy_code,
4272: ms.organization_id,
4273: ms.source_organization_id),
4274: ms.inventory_item_id,

Line 4358: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,

4354: ms.inventory_item_id,
4355: nvl(ms.firm_planned_type,2),
4356: nvl(ms.status, 0),
4357: nvl(ms.applied,0),
4358: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,
4359: ms.organization_id,ms.inventory_item_id,ms.transaction_id),
4360: ms.new_order_quantity,
4361: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
4362: ms.plan_id, ms.sr_instance_id,

Line 4361: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,

4357: nvl(ms.applied,0),
4358: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,
4359: ms.organization_id,ms.inventory_item_id,ms.transaction_id),
4360: ms.new_order_quantity,
4361: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
4362: ms.plan_id, ms.sr_instance_id,
4363: ms.transaction_id, ms.disposition_id),
4364: msc_get_gantt_data.actualStartDate(ms.order_type,
4365: msi.planning_make_buy_code,

Line 4364: msc_get_gantt_data.actualStartDate(ms.order_type,

4360: ms.new_order_quantity,
4361: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
4362: ms.plan_id, ms.sr_instance_id,
4363: ms.transaction_id, ms.disposition_id),
4364: msc_get_gantt_data.actualStartDate(ms.order_type,
4365: msi.planning_make_buy_code,
4366: ms.organization_id,
4367: ms.source_organization_id,
4368: ms.new_dock_date,

Line 4388: msc_get_gantt_data.isCriticalSupply(p_plan_id,g_end_demand_id,

4384: nvl(to_char(ms.UEPSD,format_mask),'null')),
4385: decode(g_end_demand_id, null, 'null',
4386: nvl(to_char(ms.UEPCD,format_mask),'null')),
4387: decode(g_end_demand_id, null, 0,
4388: msc_get_gantt_data.isCriticalSupply(p_plan_id,g_end_demand_id,
4389: ms.transaction_id, ms.sr_instance_id)),
4390: msc_get_gantt_data.supplyType(ms.order_type,
4391: msi.planning_make_buy_code,
4392: ms.organization_id,

Line 4390: msc_get_gantt_data.supplyType(ms.order_type,

4386: nvl(to_char(ms.UEPCD,format_mask),'null')),
4387: decode(g_end_demand_id, null, 0,
4388: msc_get_gantt_data.isCriticalSupply(p_plan_id,g_end_demand_id,
4389: ms.transaction_id, ms.sr_instance_id)),
4390: msc_get_gantt_data.supplyType(ms.order_type,
4391: msi.planning_make_buy_code,
4392: ms.organization_id,
4393: ms.source_organization_id),
4394: ms.inventory_item_id,

Line 4796: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,

4792:
4793: CURSOR end_peg_cur IS
4794: select distinct ms.organization_id,
4795: ms.transaction_id, ms.sr_instance_id,
4796: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
4797: ms.plan_id, ms.sr_instance_id,
4798: ms.transaction_id, ms.disposition_id) ||' for '||
4799: msi.item_name ||
4800: ' in ' || mtp.organization_code,

Line 4802: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,

4798: ms.transaction_id, ms.disposition_id) ||' for '||
4799: msi.item_name ||
4800: ' in ' || mtp.organization_code,
4801: 1, -- mfp1.pegging_id,
4802: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,
4803: ms.organization_id,ms.inventory_item_id,ms.transaction_id),
4804: msc_get_gantt_data.actualStartDate(ms.order_type,
4805: msi.planning_make_buy_code,
4806: ms.organization_id,

Line 4804: msc_get_gantt_data.actualStartDate(ms.order_type,

4800: ' in ' || mtp.organization_code,
4801: 1, -- mfp1.pegging_id,
4802: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,
4803: ms.organization_id,ms.inventory_item_id,ms.transaction_id),
4804: msc_get_gantt_data.actualStartDate(ms.order_type,
4805: msi.planning_make_buy_code,
4806: ms.organization_id,
4807: ms.source_organization_id,
4808: ms.new_dock_date,

Line 4813: msc_get_gantt_data.supplyType(ms.order_type,

4809: ms.new_wip_start_date,
4810: ms.new_ship_date,
4811: ms.new_schedule_date),
4812: nvl(to_char(ms.new_schedule_date,format_mask),'null'),
4813: msc_get_gantt_data.supplyType(ms.order_type,
4814: msi.planning_make_buy_code,
4815: ms.organization_id,
4816: ms.source_organization_id)
4817: from msc_full_pegging mfp1,

Line 4845: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,

4841:
4842: CURSOR peg_cur IS
4843: select distinct ms.organization_id,
4844: ms.transaction_id, ms.sr_instance_id,
4845: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
4846: ms.plan_id, ms.sr_instance_id,
4847: ms.transaction_id, ms.disposition_id)||' for '||
4848: msi.item_name ||
4849: ' in ' || mtp.organization_code,

Line 4851: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,

4847: ms.transaction_id, ms.disposition_id)||' for '||
4848: msi.item_name ||
4849: ' in ' || mtp.organization_code,
4850: 1, -- mfp1.pegging_id,
4851: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,
4852: ms.organization_id,ms.inventory_item_id,ms.transaction_id),
4853: msc_get_gantt_data.actualStartDate(ms.order_type,
4854: msi.planning_make_buy_code,
4855: ms.organization_id,

Line 4853: msc_get_gantt_data.actualStartDate(ms.order_type,

4849: ' in ' || mtp.organization_code,
4850: 1, -- mfp1.pegging_id,
4851: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,
4852: ms.organization_id,ms.inventory_item_id,ms.transaction_id),
4853: msc_get_gantt_data.actualStartDate(ms.order_type,
4854: msi.planning_make_buy_code,
4855: ms.organization_id,
4856: ms.source_organization_id,
4857: ms.new_dock_date,

Line 4862: msc_get_gantt_data.supplyType(ms.order_type,

4858: ms.new_wip_start_date,
4859: ms.new_ship_date,
4860: ms.new_schedule_date),
4861: nvl(to_char(ms.new_schedule_date,format_mask),'null'),
4862: msc_get_gantt_data.supplyType(ms.order_type,
4863: msi.planning_make_buy_code,
4864: ms.organization_id,
4865: ms.source_organization_id)
4866: from msc_full_pegging mfp2,

Line 5017: msc_get_gantt_data.init;

5013:
5014: -- the format of supply_list is
5015: -- (instance_id, transaction_id),(ins_id, transaction_id)
5016:
5017: msc_get_gantt_data.init;
5018:
5019: if g_current_block is null then
5020: g_current_block := 1;
5021: end if;

Line 5085: msc_get_gantt_data.explode_children(p_plan_id);

5081: END LOOP;
5082: end if; -- if p_patch_type is null
5083:
5084: get_end_pegging(p_plan_id);
5085: msc_get_gantt_data.explode_children(p_plan_id);
5086:
5087: END fetchSupplyData;
5088:
5089: Procedure get_property(p_plan_id number, p_instance_id number,

Line 5111: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,

5107: ms.organization_id,
5108: ms.plan_id,
5109: ms.sr_instance_id),'null') task,
5110: msc_get_name.org_code(ms.organization_id, ms.sr_instance_id) org,
5111: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
5112: ms.plan_id, ms.sr_instance_id,
5113: ms.transaction_id, ms.disposition_id) job_name,
5114: ms.firm_planned_type,
5115: nvl(ms.alternate_bom_designator, 'null') alternate_bom_designator,

Line 5121: decode(msc_get_gantt_data.supplyType(ms.order_type,

5117: alternate_routing_designator,
5118: ms.organization_id org_id,
5119: nvl(to_char(msi.planning_time_fence_date, format_mask),' ') time_fence,
5120: msc_get_name.supply_type(ms.transaction_id, p_plan_id) supply_type,
5121: decode(msc_get_gantt_data.supplyType(ms.order_type,
5122: msi.planning_make_buy_code,
5123: ms.organization_id,
5124: ms.source_organization_id),
5125: BUY_SUPPLY, g_buy_text,

Line 5749: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,

5745:
5746: CURSOR end_peg_cur IS
5747: select distinct ms.organization_id,
5748: ms.transaction_id, ms.sr_instance_id,
5749: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
5750: ms.plan_id, ms.sr_instance_id,
5751: ms.transaction_id, ms.disposition_id)||' for '||
5752: msi.item_name ||
5753: ' in ' || mtp.organization_code ||'('||

Line 5755: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,

5751: ms.transaction_id, ms.disposition_id)||' for '||
5752: msi.item_name ||
5753: ' in ' || mtp.organization_code ||'('||
5754: ms.new_order_quantity||')',
5755: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,
5756: ms.organization_id,ms.inventory_item_id,ms.transaction_id),
5757: msc_get_gantt_data.actualStartDate(ms.order_type,
5758: msi.planning_make_buy_code,
5759: ms.organization_id,

Line 5757: msc_get_gantt_data.actualStartDate(ms.order_type,

5753: ' in ' || mtp.organization_code ||'('||
5754: ms.new_order_quantity||')',
5755: msc_get_gantt_data.isSupplyLate(ms.plan_id,ms.sr_instance_id,
5756: ms.organization_id,ms.inventory_item_id,ms.transaction_id),
5757: msc_get_gantt_data.actualStartDate(ms.order_type,
5758: msi.planning_make_buy_code,
5759: ms.organization_id,
5760: ms.source_organization_id,
5761: ms.new_dock_date,

Line 5773: msc_get_gantt_data.isCriticalSupply(p_plan_id,g_end_demand_id,

5769: nvl(to_char(ms.ULPCD,format_mask),'null'),
5770: nvl(to_char(ms.UEPSD,format_mask),'null'),
5771: nvl(to_char(ms.UEPCD,format_mask),'null'),
5772: nvl(to_char(ms.MIN_START_DATE,format_mask), 'null'),
5773: msc_get_gantt_data.isCriticalSupply(p_plan_id,g_end_demand_id,
5774: ms.transaction_id, ms.sr_instance_id),
5775: msc_get_gantt_data.supplyType(ms.order_type,
5776: msi.planning_make_buy_code,
5777: ms.organization_id,

Line 5775: msc_get_gantt_data.supplyType(ms.order_type,

5771: nvl(to_char(ms.UEPCD,format_mask),'null'),
5772: nvl(to_char(ms.MIN_START_DATE,format_mask), 'null'),
5773: msc_get_gantt_data.isCriticalSupply(p_plan_id,g_end_demand_id,
5774: ms.transaction_id, ms.sr_instance_id),
5775: msc_get_gantt_data.supplyType(ms.order_type,
5776: msi.planning_make_buy_code,
5777: ms.organization_id,
5778: ms.source_organization_id),
5779: mtp.organization_code ||':'||msi.item_name,

Line 5823: msc_get_gantt_data.init;

5819: curr_item_id number_arr;
5820: curr_org_code char_arr;
5821: BEGIN
5822:
5823: msc_get_gantt_data.init;
5824: g_end_demand_id := p_demand_id;
5825:
5826: -- for order centric view
5827: if g_supply_query_id is not null then

Line 5964: msc_get_gantt_data.explode_children(p_plan_id, p_critical);

5960:
5961: end if;
5962: END LOOP;
5963: the_index := i;
5964: msc_get_gantt_data.explode_children(p_plan_id, p_critical);
5965:
5966: END fetchLateDemandData;
5967:
5968:

Line 6196: msc_get_gantt_data.get_dmd_priority(

6192: p_end_date := p_end_date +1;
6193: end if;
6194: -- supplier requirements
6195: select decode(ms.firm_planned_type, 1, -1,
6196: msc_get_gantt_data.get_dmd_priority(
6197: ms.plan_id, ms.sr_instance_id, ms.transaction_id)),
6198: ms.new_order_quantity
6199: bulk collect into v_id,v_qty
6200: from msc_supplies ms

Line 6264: msc_get_gantt_data.get_dmd_priority(

6260: v_bkt_size := p_end_date - p_start_date;
6261: end if;
6262: -- requirements
6263: select decode(ms.firm_planned_type, 1, -1,
6264: msc_get_gantt_data.get_dmd_priority(
6265: mrr.plan_id, mrr.sr_instance_id, mrr.supply_id)),
6266: mrr.resource_hours/24/v_bkt_size
6267: bulk collect into v_id,v_qty
6268: from msc_resource_requirements mrr,

Line 6394: msc_get_gantt_data.modify_parent_path(i) ||field_seperator ||

6390: while i is not null and i > 0 loop
6391:
6392: v_one_record := i||field_seperator ||
6393: peg_data.parent_index(i) ||field_seperator ||
6394: msc_get_gantt_data.modify_parent_path(i) ||field_seperator ||
6395: print_one_record(i);
6396: if v_return_data is null then
6397: v_return_data := v_one_record;
6398: else

Line 6411: v_one_record := msc_get_gantt_data.modify_parent_path(

6407: record_seperator || v_return_data;
6408: g_supply_rec_count := g_supply_rec_count +1;
6409:
6410: if g_current_block >1 then -- add prev node
6411: v_one_record := msc_get_gantt_data.modify_parent_path(
6412: start_index)
6413: || field_seperator ||
6414: PREV_NODE || field_seperator ||
6415: -1 ||field_seperator ||