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_CL_OTHER_ODS_LOAD dependencies on MSC_CL_EXCHANGE_PARTTBL

Line 1517: IF NOT MSC_CL_EXCHANGE_PARTTBL.Initialize_SWAP_Tbl_List(MSC_CL_COLLECTION.v_instance_id,MSC_CL_COLLECTION.v_instance_code) THEN

1513:
1514: COMMIT;
1515:
1516: /* Initialize the list */
1517: IF NOT MSC_CL_EXCHANGE_PARTTBL.Initialize_SWAP_Tbl_List(MSC_CL_COLLECTION.v_instance_id,MSC_CL_COLLECTION.v_instance_code) THEN
1518: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1519: END IF;
1520: /* Get the swap table index number in the list*/
1521: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_REGIONS'); --ods table name

Line 1521: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_REGIONS'); --ods table name

1517: IF NOT MSC_CL_EXCHANGE_PARTTBL.Initialize_SWAP_Tbl_List(MSC_CL_COLLECTION.v_instance_id,MSC_CL_COLLECTION.v_instance_code) THEN
1518: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1519: END IF;
1520: /* Get the swap table index number in the list*/
1521: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_REGIONS'); --ods table name
1522: IF i = -1 THEN
1523: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Table not in the list of SWAP partition');
1524: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1525: END IF;

Line 1528: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (

1524: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1525: END IF;
1526: /* Do phase 1 exchange*/
1527:
1528: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
1529: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1530: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1531: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1532: MSC_UTIL.SYS_NO ) THEN

Line 1529: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,

1525: END IF;
1526: /* Do phase 1 exchange*/
1527:
1528: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
1529: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1530: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1531: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1532: MSC_UTIL.SYS_NO ) THEN
1533: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');

Line 1530: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,

1526: /* Do phase 1 exchange*/
1527:
1528: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
1529: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1530: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1531: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1532: MSC_UTIL.SYS_NO ) THEN
1533: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
1534: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;

Line 1531: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,

1527:
1528: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
1529: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1530: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1531: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1532: MSC_UTIL.SYS_NO ) THEN
1533: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
1534: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1535: END IF;

Line 1538: || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).column_name || ' = '

1534: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1535: END IF;
1536:
1537: EXECUTE IMMEDIATE ' Update msc_coll_parameters set '
1538: || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).column_name || ' = '
1539: || MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_1
1540: || ' where instance_id = ' || MSC_CL_COLLECTION.v_instance_id;
1541:
1542: commit;

Line 1546: lv_crt_ind_status := MSC_CL_EXCHANGE_PARTTBL.create_temp_table_index

1542: commit;
1543: /* Add code to copy required data from ods table to this temp table*/
1544:
1545: /* Add code to create indexes on this temp table*/
1546: lv_crt_ind_status := MSC_CL_EXCHANGE_PARTTBL.create_temp_table_index
1547: ( 'NONUNIQUE',
1548: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).ods_table_name,
1549: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1550: MSC_CL_COLLECTION.v_instance_code,

Line 1548: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).ods_table_name,

1544:
1545: /* Add code to create indexes on this temp table*/
1546: lv_crt_ind_status := MSC_CL_EXCHANGE_PARTTBL.create_temp_table_index
1547: ( 'NONUNIQUE',
1548: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).ods_table_name,
1549: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1550: MSC_CL_COLLECTION.v_instance_code,
1551: MSC_CL_COLLECTION.v_instance_id,
1552: MSC_UTIL.SYS_NO,

Line 1549: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,

1545: /* Add code to create indexes on this temp table*/
1546: lv_crt_ind_status := MSC_CL_EXCHANGE_PARTTBL.create_temp_table_index
1547: ( 'NONUNIQUE',
1548: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).ods_table_name,
1549: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1550: MSC_CL_COLLECTION.v_instance_code,
1551: MSC_CL_COLLECTION.v_instance_id,
1552: MSC_UTIL.SYS_NO,
1553: MSC_CL_COLLECTION.G_WARNING

Line 1557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1553: MSC_CL_COLLECTION.G_WARNING
1554: );
1555:
1556: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN
1557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1558: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1560: --RETURN ;
1561: ELSE

Line 1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1555:
1556: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN
1557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1558: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1560: --RETURN ;
1561: ELSE
1562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1563: END IF;

Line 1562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1558: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1560: --RETURN ;
1561: ELSE
1562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1563: END IF;
1564:
1565: COMMIT;
1566:

Line 1616: IF NOT MSC_CL_EXCHANGE_PARTTBL.Initialize_SWAP_Tbl_List(MSC_CL_COLLECTION.v_instance_id,MSC_CL_COLLECTION.v_instance_code) THEN

1612:
1613: COMMIT;
1614:
1615: /* Initialize the list */
1616: IF NOT MSC_CL_EXCHANGE_PARTTBL.Initialize_SWAP_Tbl_List(MSC_CL_COLLECTION.v_instance_id,MSC_CL_COLLECTION.v_instance_code) THEN
1617: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1618: END IF;
1619: /* Get the swap table index number in the list*/
1620: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_ZONE_REGIONS'); --ods table name

Line 1620: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_ZONE_REGIONS'); --ods table name

1616: IF NOT MSC_CL_EXCHANGE_PARTTBL.Initialize_SWAP_Tbl_List(MSC_CL_COLLECTION.v_instance_id,MSC_CL_COLLECTION.v_instance_code) THEN
1617: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1618: END IF;
1619: /* Get the swap table index number in the list*/
1620: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_ZONE_REGIONS'); --ods table name
1621: IF i = -1 THEN
1622: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Table not in the list of SWAP partition');
1623: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1624: END IF;

Line 1627: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (

1623: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1624: END IF;
1625: /* Do phase 1 exchange*/
1626:
1627: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
1628: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1629: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1630: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1631: MSC_UTIL.SYS_NO ) THEN

Line 1628: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,

1624: END IF;
1625: /* Do phase 1 exchange*/
1626:
1627: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
1628: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1629: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1630: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1631: MSC_UTIL.SYS_NO ) THEN
1632: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');

Line 1629: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,

1625: /* Do phase 1 exchange*/
1626:
1627: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
1628: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1629: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1630: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1631: MSC_UTIL.SYS_NO ) THEN
1632: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
1633: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;

Line 1630: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,

1626:
1627: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
1628: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1629: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1630: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1631: MSC_UTIL.SYS_NO ) THEN
1632: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
1633: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1634: END IF;

Line 1637: || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).column_name || ' = '

1633: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1634: END IF;
1635:
1636: EXECUTE IMMEDIATE ' Update msc_coll_parameters set '
1637: || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).column_name || ' = '
1638: || MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_1
1639: || ' where instance_id = ' || MSC_CL_COLLECTION.v_instance_id;
1640:
1641: commit;

Line 1645: lv_crt_ind_status := MSC_CL_EXCHANGE_PARTTBL.create_temp_table_index

1641: commit;
1642: /* Add code to copy required data from ods table to this temp table*/
1643:
1644: /* Add code to create indexes on this temp table*/
1645: lv_crt_ind_status := MSC_CL_EXCHANGE_PARTTBL.create_temp_table_index
1646: ( 'NONUNIQUE',
1647: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).ods_table_name,
1648: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1649: MSC_CL_COLLECTION.v_instance_code,

Line 1647: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).ods_table_name,

1643:
1644: /* Add code to create indexes on this temp table*/
1645: lv_crt_ind_status := MSC_CL_EXCHANGE_PARTTBL.create_temp_table_index
1646: ( 'NONUNIQUE',
1647: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).ods_table_name,
1648: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1649: MSC_CL_COLLECTION.v_instance_code,
1650: MSC_CL_COLLECTION.v_instance_id,
1651: MSC_UTIL.SYS_NO,

Line 1648: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,

1644: /* Add code to create indexes on this temp table*/
1645: lv_crt_ind_status := MSC_CL_EXCHANGE_PARTTBL.create_temp_table_index
1646: ( 'NONUNIQUE',
1647: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).ods_table_name,
1648: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1649: MSC_CL_COLLECTION.v_instance_code,
1650: MSC_CL_COLLECTION.v_instance_id,
1651: MSC_UTIL.SYS_NO,
1652: MSC_CL_COLLECTION.G_WARNING

Line 1656: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1652: MSC_CL_COLLECTION.G_WARNING
1653: );
1654:
1655: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN
1656: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1657: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1658: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1659: -- RETURN ;
1660: ELSE

Line 1658: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1654:
1655: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN
1656: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1657: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1658: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1659: -- RETURN ;
1660: ELSE
1661: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1662: END IF;

Line 1661: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1657: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1658: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1659: -- RETURN ;
1660: ELSE
1661: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1662: END IF;
1663:
1664: EXCEPTION
1665: WHEN MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR THEN

Line 1709: IF NOT MSC_CL_EXCHANGE_PARTTBL.Initialize_SWAP_Tbl_List(MSC_CL_COLLECTION.v_instance_id,MSC_CL_COLLECTION.v_instance_code) THEN

1705:
1706: COMMIT;
1707:
1708: /* Initialize the list */
1709: IF NOT MSC_CL_EXCHANGE_PARTTBL.Initialize_SWAP_Tbl_List(MSC_CL_COLLECTION.v_instance_id,MSC_CL_COLLECTION.v_instance_code) THEN
1710: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1711: END IF;
1712: /* Get the swap table index number in the list*/
1713: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_REGION_LOCATIONS'); --ods table name

Line 1713: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_REGION_LOCATIONS'); --ods table name

1709: IF NOT MSC_CL_EXCHANGE_PARTTBL.Initialize_SWAP_Tbl_List(MSC_CL_COLLECTION.v_instance_id,MSC_CL_COLLECTION.v_instance_code) THEN
1710: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1711: END IF;
1712: /* Get the swap table index number in the list*/
1713: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_REGION_LOCATIONS'); --ods table name
1714: IF i = -1 THEN
1715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Table not in the list of SWAP partition');
1716: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1717: END IF;

Line 1720: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (

1716: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1717: END IF;
1718: /* Do phase 1 exchange*/
1719:
1720: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
1721: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1722: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1723: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1724: MSC_UTIL.SYS_NO ) THEN

Line 1721: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,

1717: END IF;
1718: /* Do phase 1 exchange*/
1719:
1720: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
1721: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1722: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1723: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1724: MSC_UTIL.SYS_NO ) THEN
1725: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');

Line 1722: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,

1718: /* Do phase 1 exchange*/
1719:
1720: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
1721: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1722: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1723: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1724: MSC_UTIL.SYS_NO ) THEN
1725: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
1726: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;

Line 1723: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,

1719:
1720: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
1721: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1722: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1723: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1724: MSC_UTIL.SYS_NO ) THEN
1725: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
1726: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1727: END IF;

Line 1730: || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).column_name || ' = '

1726: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1727: END IF;
1728:
1729: EXECUTE IMMEDIATE ' Update msc_coll_parameters set '
1730: || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).column_name || ' = '
1731: || MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_1
1732: || ' where instance_id = ' || MSC_CL_COLLECTION.v_instance_id;
1733:
1734: commit;

Line 1738: lv_crt_ind_status := MSC_CL_EXCHANGE_PARTTBL.create_temp_table_index

1734: commit;
1735: /* Add code to copy required data from ods table to this temp table*/
1736:
1737: /* Add code to create indexes on this temp table*/
1738: lv_crt_ind_status := MSC_CL_EXCHANGE_PARTTBL.create_temp_table_index
1739: ( 'NONUNIQUE',
1740: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).ods_table_name,
1741: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1742: MSC_CL_COLLECTION.v_instance_code,

Line 1740: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).ods_table_name,

1736:
1737: /* Add code to create indexes on this temp table*/
1738: lv_crt_ind_status := MSC_CL_EXCHANGE_PARTTBL.create_temp_table_index
1739: ( 'NONUNIQUE',
1740: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).ods_table_name,
1741: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1742: MSC_CL_COLLECTION.v_instance_code,
1743: MSC_CL_COLLECTION.v_instance_id,
1744: MSC_UTIL.SYS_NO,

Line 1741: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,

1737: /* Add code to create indexes on this temp table*/
1738: lv_crt_ind_status := MSC_CL_EXCHANGE_PARTTBL.create_temp_table_index
1739: ( 'NONUNIQUE',
1740: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).ods_table_name,
1741: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1742: MSC_CL_COLLECTION.v_instance_code,
1743: MSC_CL_COLLECTION.v_instance_id,
1744: MSC_UTIL.SYS_NO,
1745: MSC_CL_COLLECTION.G_WARNING

Line 1749: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1745: MSC_CL_COLLECTION.G_WARNING
1746: );
1747:
1748: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN
1749: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1750: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1751: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1752: -- RETURN ;
1753: ELSE

Line 1751: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1747:
1748: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN
1749: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1750: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1751: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1752: -- RETURN ;
1753: ELSE
1754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1755: END IF;

Line 1754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1750: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1751: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1752: -- RETURN ;
1753: ELSE
1754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1755: END IF;
1756:
1757: EXCEPTION
1758: WHEN MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR THEN

Line 4513: IF NOT MSC_CL_EXCHANGE_PARTTBL.Initialize_SWAP_Tbl_List(MSC_CL_COLLECTION.v_instance_id,MSC_CL_COLLECTION.v_instance_code) THEN

4509:
4510: COMMIT;
4511:
4512: /* Initialize the list */
4513: IF NOT MSC_CL_EXCHANGE_PARTTBL.Initialize_SWAP_Tbl_List(MSC_CL_COLLECTION.v_instance_id,MSC_CL_COLLECTION.v_instance_code) THEN
4514: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
4515: END IF;
4516: /* Get the swap table index number in the list*/
4517: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_DELIVERY_DETAILS'); --ods table name

Line 4517: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_DELIVERY_DETAILS'); --ods table name

4513: IF NOT MSC_CL_EXCHANGE_PARTTBL.Initialize_SWAP_Tbl_List(MSC_CL_COLLECTION.v_instance_id,MSC_CL_COLLECTION.v_instance_code) THEN
4514: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
4515: END IF;
4516: /* Get the swap table index number in the list*/
4517: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_DELIVERY_DETAILS'); --ods table name
4518: IF i = -1 THEN
4519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Table not in the list of SWAP partition');
4520: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
4521: END IF;

Line 4524: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (

4520: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
4521: END IF;
4522: /* Do phase 1 exchange*/
4523:
4524: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
4525: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
4526: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
4527: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
4528: MSC_UTIL.SYS_NO ) THEN

Line 4525: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,

4521: END IF;
4522: /* Do phase 1 exchange*/
4523:
4524: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
4525: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
4526: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
4527: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
4528: MSC_UTIL.SYS_NO ) THEN
4529: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');

Line 4526: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,

4522: /* Do phase 1 exchange*/
4523:
4524: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
4525: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
4526: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
4527: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
4528: MSC_UTIL.SYS_NO ) THEN
4529: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
4530: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;

Line 4527: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,

4523:
4524: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
4525: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
4526: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
4527: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
4528: MSC_UTIL.SYS_NO ) THEN
4529: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
4530: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
4531: END IF;

Line 4534: || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).column_name || ' = '

4530: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
4531: END IF;
4532:
4533: EXECUTE IMMEDIATE ' Update msc_coll_parameters set '
4534: || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).column_name || ' = '
4535: || MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_1
4536: || ' where instance_id = ' || MSC_CL_COLLECTION.v_instance_id;
4537:
4538: commit;

Line 4541: lv_sql_stmt := ' INSERT INTO '||MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name

4537:
4538: commit;
4539: /* Add code to copy required data from ods table to this temp table*/
4540:
4541: lv_sql_stmt := ' INSERT INTO '||MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name
4542: ||' ('
4543: ||' SR_INSTANCE_ID,'
4544: ||' DELIVERY_DETAIL_ID,'
4545: ||' SOURCE_CODE,'