[Home] [Help]
1403:
1404: END Find_PF_Bucketed_Demands;
1405:
1406: /*--Add_PF_Rollup_Supplies--------------------------------------------------
1407: | o This procedure adds rollup supplies in msc_alloc_supplies table.
1408: | o If the supply is after ATF then it adds rollup supplies to family,
1409: | else to member item.
1410: +-------------------------------------------------------------------------*/
1411: PROCEDURE Add_PF_Rollup_Supplies(
1434: -- Initializing API return code
1435: x_return_status := FND_API.G_RET_STS_SUCCESS;
1436:
1437: IF p_schedule_date <= p_atf_date THEN
1438: INSERT INTO MSC_ALLOC_SUPPLIES(
1439: PLAN_ID,
1440: INVENTORY_ITEM_ID,
1441: ORGANIZATION_ID,
1442: SR_INSTANCE_ID,
1485: msc_sch_wb.atp_debug('* Date = ' ||to_char(p_schedule_date));
1486: msc_sch_wb.atp_debug('**************************************');
1487: END IF;
1488: ELSE
1489: INSERT INTO MSC_ALLOC_SUPPLIES(
1490: PLAN_ID,
1491: INVENTORY_ITEM_ID,
1492: ORGANIZATION_ID,
1493: SR_INSTANCE_ID,
1584: -- Initializing API return code
1585: x_return_status := FND_API.G_RET_STS_SUCCESS;
1586:
1587: IF p_date is NULL THEN
1588: UPDATE msc_alloc_supplies
1589: SET old_supply_date = supply_date, -- why do we populate old_supply_date and qty??
1590: old_allocated_quantity = allocated_quantity, --??
1591: allocated_quantity = NVL(p_quantity, allocated_quantity),
1592: supply_quantity = NVL(p_quantity, supply_quantity), -- Bug 3779200
1594: LAST_UPDATE_DATE = l_sysdate
1595: WHERE plan_id = p_plan_id
1596: AND parent_transaction_id = p_parent_transaction_id;
1597: ELSIF p_date <= p_atf_date THEN
1598: UPDATE msc_alloc_supplies
1599: SET old_supply_date = supply_date, -- why do we populate old_supply_date and qty??
1600: old_allocated_quantity = allocated_quantity, --??
1601: supply_date = NVL(p_date, supply_date),
1602: allocated_quantity = NVL(p_quantity, allocated_quantity),
1606: LAST_UPDATE_DATE = l_sysdate
1607: WHERE plan_id = p_plan_id
1608: AND parent_transaction_id = p_parent_transaction_id;
1609: ELSE
1610: UPDATE msc_alloc_supplies
1611: SET old_supply_date = supply_date, -- why do we populate old_supply_date and qty??
1612: old_allocated_quantity = allocated_quantity, --??
1613: supply_date = NVL(p_date, supply_date),
1614: allocated_quantity = NVL(p_quantity, allocated_quantity),
1695: --SELECT msc_supplies_s.nextval into p_transaction_id from dual;
1696:
1697: IF p_mem_stealing_quantity > 0 THEN
1698: IF PG_DEBUG in ('Y', 'C') THEN
1699: msc_sch_wb.atp_debug('Add_PF_Stealing_Supply_Details: ' || 'before insert into msc_alloc_supplies-Stealing Info');
1700: END IF;
1701:
1702: -- Add Member item
1703: INSERT INTO MSC_ALLOC_SUPPLIES
1699: msc_sch_wb.atp_debug('Add_PF_Stealing_Supply_Details: ' || 'before insert into msc_alloc_supplies-Stealing Info');
1700: END IF;
1701:
1702: -- Add Member item
1703: INSERT INTO MSC_ALLOC_SUPPLIES
1704: (plan_id, inventory_item_id, organization_id, sr_instance_id,
1705: demand_class, supply_date, parent_transaction_id,
1706: allocated_quantity, order_type, sales_order_line_id,demand_source_type,stealing_flag,--cmro
1707: supply_quantity, original_item_id, original_order_type,
1723: l_rows_proc := SQL%ROWCOUNT;
1724:
1725: -- Next add the Stolen Data.
1726: IF PG_DEBUG in ('Y', 'C') THEN
1727: msc_sch_wb.atp_debug('Add_PF_Stealing_Supply_Details: ' || 'before insert into msc_alloc_supplies-Stolen Info');
1728: END IF;
1729:
1730: INSERT INTO MSC_ALLOC_SUPPLIES
1731: (plan_id, inventory_item_id, organization_id, sr_instance_id,
1726: IF PG_DEBUG in ('Y', 'C') THEN
1727: msc_sch_wb.atp_debug('Add_PF_Stealing_Supply_Details: ' || 'before insert into msc_alloc_supplies-Stolen Info');
1728: END IF;
1729:
1730: INSERT INTO MSC_ALLOC_SUPPLIES
1731: (plan_id, inventory_item_id, organization_id, sr_instance_id,
1732: demand_class, supply_date, parent_transaction_id,
1733: allocated_quantity, order_type, sales_order_line_id,demand_source_type, stealing_flag,--cmro
1734: supply_quantity, original_item_id, original_order_type,
1748: END IF;
1749:
1750: IF (l_pf_stealing_rec_date is not null) and (p_pf_stealing_quantity > 0) THEN
1751: IF PG_DEBUG in ('Y', 'C') THEN
1752: msc_sch_wb.atp_debug('Add_PF_Stealing_Supply_Details: ' || 'before insert into msc_alloc_supplies-Stealing Info');
1753: END IF;
1754:
1755: IF p_transaction_id is not null THEN --bug3555084
1756:
1753: END IF;
1754:
1755: IF p_transaction_id is not null THEN --bug3555084
1756:
1757: INSERT INTO MSC_ALLOC_SUPPLIES
1758: (plan_id, inventory_item_id, organization_id, sr_instance_id,
1759: demand_class, supply_date, parent_transaction_id,
1760: allocated_quantity, order_type, sales_order_line_id,demand_source_type, stealing_flag,--cmro
1761: supply_quantity, original_item_id, original_order_type,
1773:
1774: l_rows_proc := l_rows_proc + SQL%ROWCOUNT;
1775:
1776: ELSE --bug3555084 start
1777: INSERT INTO MSC_ALLOC_SUPPLIES
1778: (plan_id, inventory_item_id, organization_id, sr_instance_id,
1779: demand_class, supply_date, parent_transaction_id,
1780: allocated_quantity, order_type, sales_order_line_id,demand_source_type, stealing_flag,--cmro
1781: supply_quantity, original_item_id, original_order_type,
1797: END IF;
1798: --bug3555084 end
1799: -- Next add the Stolen Data.
1800: IF PG_DEBUG in ('Y', 'C') THEN
1801: msc_sch_wb.atp_debug('Add_PF_Stealing_Supply_Details: ' || 'before insert into msc_alloc_supplies-Stolen Info');
1802: END IF;
1803:
1804: INSERT INTO MSC_ALLOC_SUPPLIES
1805: (plan_id, inventory_item_id, organization_id, sr_instance_id,
1800: IF PG_DEBUG in ('Y', 'C') THEN
1801: msc_sch_wb.atp_debug('Add_PF_Stealing_Supply_Details: ' || 'before insert into msc_alloc_supplies-Stolen Info');
1802: END IF;
1803:
1804: INSERT INTO MSC_ALLOC_SUPPLIES
1805: (plan_id, inventory_item_id, organization_id, sr_instance_id,
1806: demand_class, supply_date, parent_transaction_id,
1807: allocated_quantity, order_type, sales_order_line_id,demand_source_type, stealing_flag,--cmro
1808: supply_quantity, original_item_id, original_order_type,
2497: UNION ALL
2498: --bug3700564 added trunc
2499: SELECT TRUNC(SA.SUPPLY_DATE) SD_DATE,
2500: SA.ALLOCATED_QUANTITY SD_QTY
2501: FROM MSC_ALLOC_SUPPLIES SA,
2502: MSC_SYSTEM_ITEMS I,
2503: MSC_PLANS P -- For summary enhancement
2504: WHERE I.SR_INVENTORY_ITEM_ID in (p_sr_member_id, p_sr_family_id)
2505: AND I.ORGANIZATION_ID = p_org_id
2534: | - Bucketed demands (origination type 51) for member item upto ATF from
2535: | msc_alloc_demands table.
2536: | - Bucketed demands for family after ATF from msc_alloc_demands table.
2537: | - Rollup supplies (order type 50) for member item upto ATF from
2538: | msc_alloc_supplies table.
2539: | - Rollup supplies for family after ATF from msc_alloc_supplies table.
2540: +------------------------------------------------------------------------------*/
2541: PROCEDURE Get_Mat_Avail_Pf_Pds(
2542: p_sr_member_id IN NUMBER,
2535: | msc_alloc_demands table.
2536: | - Bucketed demands for family after ATF from msc_alloc_demands table.
2537: | - Rollup supplies (order type 50) for member item upto ATF from
2538: | msc_alloc_supplies table.
2539: | - Rollup supplies for family after ATF from msc_alloc_supplies table.
2540: +------------------------------------------------------------------------------*/
2541: PROCEDURE Get_Mat_Avail_Pf_Pds(
2542: p_sr_member_id IN NUMBER,
2543: p_sr_family_id IN NUMBER,
2581: UNION ALL
2582: --bug3700564 added trunc
2583: SELECT TRUNC(SA.SUPPLY_DATE) SD_DATE,
2584: SA.ALLOCATED_QUANTITY SD_QTY
2585: FROM MSC_ALLOC_SUPPLIES SA,
2586: MSC_SYSTEM_ITEMS I
2587: WHERE I.SR_INVENTORY_ITEM_ID in (p_sr_member_id, p_sr_family_id)
2588: AND I.ORGANIZATION_ID = p_org_id
2589: AND I.SR_INSTANCE_ID = p_instance_id
3063: | - Bucketed demands (origination type 51) for member item upto ATF from
3064: | msc_alloc_demands table.
3065: | - Bucketed demands for family after ATF from msc_alloc_demands table.
3066: | - Rollup supplies (order type 50) for member item upto ATF from
3067: | msc_alloc_supplies table.
3068: | - Rollup supplies for family after ATF from msc_alloc_supplies table.
3069: | o Other important differences from non PF SQLs are:
3070: | - Columns Pf_Display_Flag, Original_Demand_Quantity and Original_Demand_Date
3071: | in msc_atp_sd_details_temp table are populated for demands.
3064: | msc_alloc_demands table.
3065: | - Bucketed demands for family after ATF from msc_alloc_demands table.
3066: | - Rollup supplies (order type 50) for member item upto ATF from
3067: | msc_alloc_supplies table.
3068: | - Rollup supplies for family after ATF from msc_alloc_supplies table.
3069: | o Other important differences from non PF SQLs are:
3070: | - Columns Pf_Display_Flag, Original_Demand_Quantity and Original_Demand_Date
3071: | in msc_atp_sd_details_temp table are populated for demands.
3072: | - Column Original_Supply_Demand_Type is populated for demands and supplies
3264: l_null_char, --bug3814584
3265: l_null_char, --bug3814584
3266: l_null_date, --bug3814584
3267: I2.Item_Name --bug3579625
3268: FROM MSC_ALLOC_SUPPLIES SA,
3269: MSC_SYSTEM_ITEMS I,
3270: MSC_SYSTEM_ITEMS I2 --bug3579625
3271: WHERE I.SR_INVENTORY_ITEM_ID in (p_sr_member_id, p_sr_family_id)
3272: AND I.ORGANIZATION_ID = p_org_id
3433: | upto ATF from msc_alloc_demands table.
3434: | - Allocated Bucketed demands for family after ATF from msc_alloc_demands
3435: | table.
3436: | - Allocated Rollup supplies (order type 50) for member item upto ATF
3437: | from msc_alloc_supplies table.
3438: | - Allocated Rollup supplies for family after ATF from msc_alloc_supplies
3439: | table.
3440: +-------------------------------------------------------------------------------*/
3441: PROCEDURE Item_Alloc_Avail_Pf (
3434: | - Allocated Bucketed demands for family after ATF from msc_alloc_demands
3435: | table.
3436: | - Allocated Rollup supplies (order type 50) for member item upto ATF
3437: | from msc_alloc_supplies table.
3438: | - Allocated Rollup supplies for family after ATF from msc_alloc_supplies
3439: | table.
3440: +-------------------------------------------------------------------------------*/
3441: PROCEDURE Item_Alloc_Avail_Pf (
3442: p_member_id IN NUMBER,
3862: p_demand_class,
3863: TRUNC(SA.SUPPLY_DATE)),*/
3864: NULL, 1,
3865: 0)) SD_QTY
3866: FROM MSC_ALLOC_SUPPLIES SA, MSC_ITEM_HIERARCHY_MV MIHM --4365873
3867: WHERE SA.PLAN_ID = p_plan_id
3868: AND SA.SR_INSTANCE_ID = p_instance_id
3869: AND SA.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
3870: AND SA.ORGANIZATION_ID = p_org_id
4332: p_demand_class,
4333: TRUNC(sa.SUPPLY_DATE)),*/
4334: NULL, 1,
4335: 0)) SD_QTY
4336: FROM MSC_ALLOC_SUPPLIES SA,MSC_ITEM_HIERARCHY_MV MIHM
4337: WHERE SA.PLAN_ID = p_plan_id
4338: AND SA.SR_INSTANCE_ID = p_instance_id
4339: AND SA.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
4340: AND SA.ORGANIZATION_ID = p_org_id
4376: | - Allocated Bucketed demands (origination type 51) for member item upto ATF
4377: | from msc_alloc_demands table.
4378: | - Allocated Bucketed demands for family after ATF from msc_alloc_demands table.
4379: | - Allocated Rollup supplies (order type 50) for member item upto ATF from
4380: | msc_alloc_supplies table.
4381: | - Allocated Rollup supplies for family after ATF from msc_alloc_supplies table.
4382: | o Other important differences from non PF SQLs are:
4383: | - Columns Pf_Display_Flag, Original_Demand_Quantity and Original_Demand_Date
4384: | in msc_atp_sd_details_temp table are populated for demands.
4377: | from msc_alloc_demands table.
4378: | - Allocated Bucketed demands for family after ATF from msc_alloc_demands table.
4379: | - Allocated Rollup supplies (order type 50) for member item upto ATF from
4380: | msc_alloc_supplies table.
4381: | - Allocated Rollup supplies for family after ATF from msc_alloc_supplies table.
4382: | o Other important differences from non PF SQLs are:
4383: | - Columns Pf_Display_Flag, Original_Demand_Quantity and Original_Demand_Date
4384: | in msc_atp_sd_details_temp table are populated for demands.
4385: | - Column Original_Supply_Demand_Type is populated for demands and supplies
5300: SA.Supply_Quantity,
5301: SA.ALLOCATED_QUANTITY,
5302: SA.PARENT_TRANSACTION_ID,
5303: SA.ORDER_TYPE
5304: FROM MSC_ALLOC_SUPPLIES SA,
5305: MSC_SYSTEM_ITEMS I
5306: WHERE SA.PLAN_ID = p_plan_id
5307: AND SA.SR_INSTANCE_ID = p_instance_id
5308: AND SA.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
5392: AND TRUNC(AD.DEMAND_DATE) < p_itf
5393: UNION ALL
5394: SELECT TRUNC(SA.SUPPLY_DATE) SD_DATE,
5395: SA.ALLOCATED_QUANTITY SD_QTY
5396: FROM MSC_ALLOC_SUPPLIES SA
5397: WHERE SA.PLAN_ID = p_plan_id
5398: AND SA.SR_INSTANCE_ID = p_instance_id
5399: AND SA.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
5400: AND TRUNC(SA.SUPPLY_DATE) >= DECODE(SA.ORIGINAL_ORDER_TYPE,
5492: SELECT TRUNC(SA.SUPPLY_DATE) SD_DATE,
5493: decode(SA.ALLOCATED_QUANTITY, -- Consider deleted stealing records as dummy demands
5494: 0, -1 * OLD_ALLOCATED_QUANTITY, -- For summary enhancement
5495: SA.ALLOCATED_QUANTITY) SD_QTY
5496: FROM MSC_ALLOC_SUPPLIES SA,
5497: MSC_PLANS P -- For summary enhancement
5498: WHERE SA.PLAN_ID = p_plan_id
5499: AND SA.SR_INSTANCE_ID = p_instance_id
5500: AND SA.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
5729: --null, --bug3684383
5730: l_null_date, --bug3814584
5731: I.Item_Name --bug3579625
5732:
5733: FROM MSC_ALLOC_SUPPLIES SA,
5734: MSC_SYSTEM_ITEMS I, --bug3579625
5735: MSC_TRADING_PARTNERS MTP,--bug3684383
5736: MSC_TRADING_PARTNER_SITES MTPS --bug3684383
5737:
5840:
5841: SELECT TRUNC(SA.SUPPLY_DATE) SD_DATE,
5842: SA.ALLOCATED_QUANTITY SD_QTY,
5843: SA.DEMAND_CLASS
5844: FROM MSC_ALLOC_SUPPLIES SA
5845: WHERE SA.PLAN_ID = p_plan_id
5846: AND SA.SR_INSTANCE_ID = p_instance_id
5847: AND SA.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
5848: AND SA.ORGANIZATION_ID = p_org_id
5953: decode(SA.ALLOCATED_QUANTITY, -- Consider deleted stealing records as dummy demands
5954: 0, -1 * OLD_ALLOCATED_QUANTITY, -- For summary enhancement
5955: SA.ALLOCATED_QUANTITY) SD_QTY ,
5956: SA.DEMAND_CLASS
5957: FROM MSC_ALLOC_SUPPLIES SA,
5958: MSC_PLANS P -- For summary enhancement
5959: WHERE SA.PLAN_ID = p_plan_id
5960: AND SA.SR_INSTANCE_ID = p_instance_id
5961: AND SA.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
6155: MTP.PARTNER_NAME col28, --bug3684383
6156: SA.DEMAND_CLASS col29, --bug3684383
6157: l_null_date col30 --bug3684383 -- Bug 3875786 - local variable used for NULL
6158: FROM
6159: MSC_ALLOC_SUPPLIES SA,
6160: MSC_ALLOC_TEMP TEMP,
6161: MSC_SYSTEM_ITEMS msi, --bug3671294
6162: MSC_TRADING_PARTNER_SITES MTPS, --bug3684383
6163: MSC_TRADING_PARTNERS MTP --bug3684383
6760: l_null_char col30, --bug3263368 ORIG_DEMAND_CLASS --Bug 3875786
6761: l_null_date col31 --bug3263368 ORIG_REQUEST_DATE -- Bug 3875786 - local variable used for NULL
6762:
6763: FROM
6764: MSC_ALLOC_SUPPLIES SA,
6765: MSC_ALLOC_TEMP TEMP,
6766: MSC_SYSTEM_ITEMS msi --bug3671294
6767: WHERE
6768: SA.PLAN_ID = p_plan_id
7268: l_null_char col34, --bug3263368 ORIG_CUSTOMER_NAME --Bug 3875786
7269: l_null_char col35, --bug3263368 ORIG_DEMAND_CLASS --Bug 3875786
7270: l_null_date col36 --bug3263368 ORIG_REQUEST_DATE -- Bug 3875786 - local variable used for NULL
7271: FROM
7272: MSC_ALLOC_SUPPLIES SA,
7273: MSC_ALLOC_HIERARCHY_TEMP TEMP,
7274: MSC_SYSTEM_ITEMS msi --bug3671294
7275: WHERE
7276: SA.PLAN_ID = p_plan_id
9546:
9547: DELETE MSC_ALLOC_DEMANDS where plan_id = p_plan_id;
9548: msc_util.msc_log('After deleting data from MSC_ALLOC_DEMANDS table');
9549:
9550: DELETE MSC_ALLOC_SUPPLIES where plan_id = p_plan_id;
9551: msc_util.msc_log('After deleting data from MSC_ALLOC_SUPPLIES table');
9552:
9553: /*--------------------------------------------------------------------------
9554: | <<<<<<<<<<<<<<<<<<<<<<< Begin Demands SQL1 >>>>>>>>>>>>>>>>>>>>>>>>>>>
9547: DELETE MSC_ALLOC_DEMANDS where plan_id = p_plan_id;
9548: msc_util.msc_log('After deleting data from MSC_ALLOC_DEMANDS table');
9549:
9550: DELETE MSC_ALLOC_SUPPLIES where plan_id = p_plan_id;
9551: msc_util.msc_log('After deleting data from MSC_ALLOC_SUPPLIES table');
9552:
9553: /*--------------------------------------------------------------------------
9554: | <<<<<<<<<<<<<<<<<<<<<<< Begin Demands SQL1 >>>>>>>>>>>>>>>>>>>>>>>>>>>
9555: +-------------------------------------------------------------------------*/
9632: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
9633: msc_util.msc_log('After executing first supplies cursor');
9634:
9635: msc_util.msc_log('rows processed: ' || rows_processed);
9636: msc_util.msc_log('after inserting item data into MSC_ALLOC_SUPPLIES tables');
9637:
9638: msc_util.msc_log('Analyze Plan partition for MSC_ALLOC_DEMANDS');
9639: fnd_stats.gather_table_stats(ownname=>l_msc_schema,tabname=>'MSC_ALLOC_DEMANDS',
9640: partname=>'ALLOC_DEMANDS_999999',
9640: partname=>'ALLOC_DEMANDS_999999',
9641: granularity=>'PARTITION',
9642: percent =>10);
9643:
9644: msc_util.msc_log('Analyze Plan partition for MSC_ALLOC_SUPPLIES');
9645: fnd_stats.gather_table_stats(ownname=>l_msc_schema,tabname=>'MSC_ALLOC_SUPPLIES',
9646: partname=>'ALLOC_SUPPLIES_999999',
9647: granularity=>'PARTITION',
9648: percent =>10);
9641: granularity=>'PARTITION',
9642: percent =>10);
9643:
9644: msc_util.msc_log('Analyze Plan partition for MSC_ALLOC_SUPPLIES');
9645: fnd_stats.gather_table_stats(ownname=>l_msc_schema,tabname=>'MSC_ALLOC_SUPPLIES',
9646: partname=>'ALLOC_SUPPLIES_999999',
9647: granularity=>'PARTITION',
9648: percent =>10);
9649:
9846: INTO l_tbspace, l_ind_tbspace
9847: FROM all_tab_partitions t,
9848: all_part_indexes i
9849: WHERE t.table_owner = l_msc_schema
9850: AND t.table_name = 'MSC_ALLOC_SUPPLIES'
9851: AND t.partition_name = 'ALLOC_SUPPLIES_' || to_char(l_plan_id)
9852: AND i.owner (+) = t.table_owner
9853: AND i.table_name (+) = t.table_name
9854: AND rownum = 1;
9859: --bug 6113544
9860: l_insert_stmt := 'CREATE TABLE ' || l_temp_table
9861: || ' TABLESPACE ' || l_tbspace
9862: || ' PCTFREE 0 STORAGE(INITIAL 40K NEXT 5M PCTINCREASE 0)'
9863: || ' as select * from msc_alloc_supplies where 1=2 ';
9864:
9865: /*
9866: l_insert_stmt := 'CREATE TABLE ' || l_temp_table || '(
9867: PLAN_ID NUMBER NOT NULL,
10050:
10051: msc_util.msc_log('swap partition for supplies');
10052: l_partition_name := 'ALLOC_SUPPLIES_' || to_char(l_plan_id);
10053:
10054: msc_util.msc_log('Partition name for msc_alloc_supplies table : ' || l_partition_name);
10055:
10056: l_sql_stmt := 'ALTER TABLE msc_alloc_supplies EXCHANGE PARTITION ' || l_partition_name ||
10057: ' with table MSC_TEMP_ALLOC_SUP_'|| to_char(l_plan_id) ||
10058: ' including indexes without validation';
10052: l_partition_name := 'ALLOC_SUPPLIES_' || to_char(l_plan_id);
10053:
10054: msc_util.msc_log('Partition name for msc_alloc_supplies table : ' || l_partition_name);
10055:
10056: l_sql_stmt := 'ALTER TABLE msc_alloc_supplies EXCHANGE PARTITION ' || l_partition_name ||
10057: ' with table MSC_TEMP_ALLOC_SUP_'|| to_char(l_plan_id) ||
10058: ' including indexes without validation';
10059:
10060: BEGIN
10057: ' with table MSC_TEMP_ALLOC_SUP_'|| to_char(l_plan_id) ||
10058: ' including indexes without validation';
10059:
10060: BEGIN
10061: msc_util.msc_log('Before alter table msc_alloc_supplies');
10062: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
10063: APPLICATION_SHORT_NAME => 'MSC',
10064: STATEMENT_TYPE => ad_ddl.alter_table,
10065: STATEMENT => l_sql_stmt,
10062: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
10063: APPLICATION_SHORT_NAME => 'MSC',
10064: STATEMENT_TYPE => ad_ddl.alter_table,
10065: STATEMENT => l_sql_stmt,
10066: OBJECT_NAME => 'MSC_ALLOC_SUPPLIES');
10067: END;
10068:
10069: END IF; -- IF l_share_partition = 'Y'
10070:
10601: x_return_status := FND_API.G_RET_STS_SUCCESS;
10602:
10603: IF p_share_partition = 'Y' THEN
10604: x_sql_stmt := '
10605: INSERT INTO MSC_ALLOC_SUPPLIES(';
10606: ELSE
10607: x_sql_stmt := '
10608: INSERT INTO ' || p_temp_table || '(';
10609: END IF;
11687: x_return_status := FND_API.G_RET_STS_SUCCESS;
11688:
11689: IF p_share_partition = 'Y' THEN
11690: x_sql_stmt := '
11691: INSERT INTO MSC_ALLOC_SUPPLIES(';
11692: ELSE
11693: x_sql_stmt := '
11694: INSERT INTO ' || p_temp_table || '(';
11695: END IF;
12009: x_return_status := FND_API.G_RET_STS_SUCCESS;
12010:
12011: IF p_share_partition = 'Y' THEN
12012: x_sql_stmt := '
12013: INSERT INTO MSC_ALLOC_SUPPLIES(';
12014: ELSE
12015: x_sql_stmt := '
12016: INSERT INTO ' || p_temp_table || '(';
12017: END IF;