APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_BOMS

Line 1614: 'INSERT INTO MSC_BOMS '

1610:
1611: BEGIN
1612:
1613: lv_sql_stmt:=
1614: 'INSERT INTO MSC_BOMS '
1615: ||'( PLAN_ID,'
1616: ||' ASSEMBLY_TYPE,'
1617: ||' ALTERNATE_BOM_DESIGNATOR,'
1618: ||' SPECIFIC_ASSEMBLY_COMMENT,'

Line 1656: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOMS', MSC_CL_COLLECTION.v_instance_id, -1);

1652:
1653: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1654:
1655: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1656: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOMS', MSC_CL_COLLECTION.v_instance_id, -1);
1657: ELSE
1658: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1659: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOMS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1660: END IF;

Line 1659: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOMS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

1655: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1656: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOMS', MSC_CL_COLLECTION.v_instance_id, -1);
1657: ELSE
1658: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1659: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOMS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1660: END IF;
1661:
1662: BEGIN
1663: lv_sql_ins :=

Line 1664: 'INSERT INTO MSC_BOMS '

1660: END IF;
1661:
1662: BEGIN
1663: lv_sql_ins :=
1664: 'INSERT INTO MSC_BOMS '
1665: ||'( PLAN_ID,'
1666: ||' ASSEMBLY_TYPE,'
1667: ||' ALTERNATE_BOM_DESIGNATOR,'
1668: ||' SPECIFIC_ASSEMBLY_COMMENT,'

Line 1720: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');

1716:
1717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1718: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1719: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1720: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1721: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1722:
1723: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1724: RAISE;

Line 1730: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');

1726: ELSE
1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1728: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1729: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1730: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1732:
1733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1734:

Line 1752: DELETE MSC_BOMS

1748: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN
1749:
1750: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1751: FOR c_rec IN c2_d LOOP
1752: DELETE MSC_BOMS
1753: WHERE PLAN_ID= -1
1754: AND BILL_SEQUENCE_ID= c_rec.BILL_SEQUENCE_ID
1755: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
1756: END LOOP;

Line 1808: UPDATE MSC_BOMS

1804:
1805: BEGIN
1806: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1807:
1808: UPDATE MSC_BOMS
1809: SET
1810: ASSEMBLY_TYPE= lb_ASSEMBLY_TYPE(j),
1811: ALTERNATE_BOM_DESIGNATOR= lb_ALTERNATE_BOM_DESIGNATOR(j),
1812: SPECIFIC_ASSEMBLY_COMMENT= lb_SPECIFIC_ASSEMBLY_COMMENT(j),

Line 1865: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');

1861:
1862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1863: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1864: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1865: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1866: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1867:
1868: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1869: RAISE;

Line 1878: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');

1874:
1875: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1876: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1877: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1878: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1880:
1881: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');