APPS.MSC_DRP_HORI_PLAN dependencies on MSC_DRP_HORI_PLAN

Line 1: PACKAGE BODY MSC_DRP_HORI_PLAN AS

1: PACKAGE BODY MSC_DRP_HORI_PLAN AS
2: /* $Header: MSCDRPHB.pls 120.19.12020000.2 2012/08/10 16:17:49 snilagir ship $ */
3:
4: PURCHASE_ORDER CONSTANT INTEGER := 1; /* supply type lookup */
5: PURCH_REQ CONSTANT INTEGER := 2;

Line 1077: INSERT INTO msc_drp_hori_plans(

1073: row_detail(bkt + (a-1)*(g_num_of_buckets+1)).volume;
1074: END LOOP;
1075:
1076: FORALL bkt IN 1..g_num_of_buckets
1077: INSERT INTO msc_drp_hori_plans(
1078: query_id,
1079: organization_id,
1080: sr_instance_id,
1081: inventory_item_id,

Line 1136: INSERT INTO msc_drp_hori_plans(

1132: sub_row_detail(bkt +(a-1)*(g_num_of_buckets)).volume;
1133: END LOOP;
1134:
1135: FORALL bkt IN 1..g_num_of_buckets
1136: INSERT INTO msc_drp_hori_plans(
1137: query_id,
1138: organization_id,
1139: sr_instance_id,
1140: inventory_item_id,

Line 1174: INSERT INTO msc_drp_hori_plans(

1170: g_error_stmt := 'Debug - flush_item_plan - 80';
1171:
1172: -- insert enterprise data
1173: FORALL a in 1 .. nvl(etp_bkt_quantity.last, 0)
1174: INSERT INTO msc_drp_hori_plans(
1175: query_id,
1176: organization_id,
1177: sr_instance_id,
1178: inventory_item_id,

Line 1746: END MSC_DRP_HORI_PLAN;

1742: end loop;
1743:
1744: END dem_priority;
1745:
1746: END MSC_DRP_HORI_PLAN;