APPS.MSC_ITEM_PKG dependencies on MSC_HUB_CALENDAR

Line 180: msc_hub_calendar.last_work_date(p_plan_id,mpb.sr_instance_id,

176: mpb.organization_id,
177: mpb.bkt_start_date,
178: mpb.bkt_end_date,
179: decode(mpb.bucket_type,1,mpb.bkt_start_date,
180: msc_hub_calendar.last_work_date(p_plan_id,mpb.sr_instance_id,
181: mpb.bucket_type,mpb.bkt_start_date,
182: mpb.bkt_end_date) )last_work_date,
183:
184: -- day bucket always has its self as last_work_date

Line 187: msc_hub_calendar.ss_date(p_plan_id,mpb.bkt_start_date,mpb.bkt_end_date) ss_date,

183:
184: -- day bucket always has its self as last_work_date
185: -- no matter it is actually a working day or not
186:
187: msc_hub_calendar.ss_date(p_plan_id,mpb.bkt_start_date,mpb.bkt_end_date) ss_date,
188:
189: decode(mpb.bucket_type,1,
190: msc_hub_calendar.working_day_bkt_start_date(p_plan_id,
191: mpb.sr_instance_id,

Line 190: msc_hub_calendar.working_day_bkt_start_date(p_plan_id,

186:
187: msc_hub_calendar.ss_date(p_plan_id,mpb.bkt_start_date,mpb.bkt_end_date) ss_date,
188:
189: decode(mpb.bucket_type,1,
190: msc_hub_calendar.working_day_bkt_start_date(p_plan_id,
191: mpb.sr_instance_id,
192: mpb.bucket_type,
193: mpb.bkt_start_date,
194: mpb.bkt_end_date) ,

Line 517: decode(sign(sd.organization_id), -1, msc_hub_calendar.get_item_org(p_plan_id, sd.inventory_item_id,

513: sd.sr_instance_id,
514: sd.organization_id,
515: sd.inventory_item_id,
516: sd.vmi_flag,
517: decode(sign(sd.organization_id), -1, msc_hub_calendar.get_item_org(p_plan_id, sd.inventory_item_id,
518: decode(sign(sd.sr_instance_id), -1, mp.sr_instance_id, sd.sr_instance_id)),
519: sd.organization_id),
520: decode(sign(sd.sr_instance_id), -1, mp.sr_instance_id, sd.sr_instance_id),
521: f.date1,

Line 590: decode(sign(sd.organization_id), -1, msc_hub_calendar.get_item_org(p_plan_id, sd.inventory_item_id,

586: sd.sr_instance_id,
587: sd.organization_id,
588: sd.inventory_item_id,
589: sd.vmi_flag,
590: decode(sign(sd.organization_id), -1, msc_hub_calendar.get_item_org(p_plan_id, sd.inventory_item_id,
591: decode(sign(sd.sr_instance_id), -1, mp.sr_instance_id, sd.sr_instance_id)),
592: sd.organization_id),
593: decode(sign(sd.sr_instance_id), -1, mp.sr_instance_id, sd.sr_instance_id),
594: l.date3

Line 1145: -1, msc_hub_calendar.get_item_org(p_plan_id, pab_tbl.inventory_item_id,

1141: decode(pab_tbl.organization_id, -1, -23453, pab_tbl.organization_id) organization_id,
1142:
1143: decode(sign(pab_tbl.sr_instance_id), -1, mp_tbl.sr_instance_id, pab_tbl.sr_instance_id) owing_inst_id,
1144: decode(sign(pab_tbl.organization_id),
1145: -1, msc_hub_calendar.get_item_org(p_plan_id, pab_tbl.inventory_item_id,
1146: decode(sign(pab_tbl.sr_instance_id), -1, mp_tbl.sr_instance_id, pab_tbl.sr_instance_id)),
1147: pab_tbl.organization_id) owing_inst_id,
1148:
1149: pab_tbl.inventory_item_id,

Line 1603: -1, msc_hub_calendar.get_item_org(p_plan_id, pab_tbl.inventory_item_id,

1599: decode(pab_tbl.organization_id, -1, -23453, pab_tbl.sr_instance_id),
1600: decode(pab_tbl.organization_id, -1, -23453, pab_tbl.organization_id),
1601: decode(sign(pab_tbl.sr_instance_id), -1, mp_tbl.sr_instance_id, pab_tbl.sr_instance_id),
1602: decode(sign(pab_tbl.organization_id),
1603: -1, msc_hub_calendar.get_item_org(p_plan_id, pab_tbl.inventory_item_id,
1604: decode(sign(pab_tbl.sr_instance_id), -1, mp_tbl.sr_instance_id, pab_tbl.sr_instance_id)),
1605: pab_tbl.organization_id),
1606: pab_tbl.inventory_item_id,
1607: pab_tbl.ship_method,

Line 1681: -23453,msc_hub_calendar.get_item_org(p_plan_id,order_tbl.inventory_item_id,

1677: order_tbl.sr_instance_id,
1678: order_tbl.organization_id,
1679: decode(order_tbl.sr_instance_id,-23453, mp_tbl.sr_instance_id,order_tbl.sr_instance_id) owing_inst_id,
1680: decode(order_tbl.organization_id,
1681: -23453,msc_hub_calendar.get_item_org(p_plan_id,order_tbl.inventory_item_id,
1682: decode(order_tbl.sr_instance_id,-23453,mp_tbl.sr_instance_id,
1683: order_tbl.sr_instance_id)),
1684: order_tbl.organization_id) owning_org_id,
1685: order_tbl.inventory_item_id,

Line 1893: -23453,msc_hub_calendar.get_item_org(p_plan_id,order_tbl.inventory_item_id,

1889: order_tbl.sr_instance_id,
1890: order_tbl.organization_id,
1891: decode(order_tbl.sr_instance_id,-23453, mp_tbl.sr_instance_id,order_tbl.sr_instance_id),
1892: decode(order_tbl.organization_id,
1893: -23453,msc_hub_calendar.get_item_org(p_plan_id,order_tbl.inventory_item_id,
1894: decode(order_tbl.sr_instance_id,-23453,mp_tbl.sr_instance_id,
1895: order_tbl.sr_instance_id)),
1896: order_tbl.organization_id) ,
1897: order_tbl.inventory_item_id,