APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_BOMS

Line 1633: 'INSERT INTO MSC_BOMS '

1629:
1630: BEGIN
1631:
1632: lv_sql_stmt:=
1633: 'INSERT INTO MSC_BOMS '
1634: ||'( PLAN_ID,'
1635: ||' ASSEMBLY_TYPE,'
1636: ||' ALTERNATE_BOM_DESIGNATOR,'
1637: ||' SPECIFIC_ASSEMBLY_COMMENT,'

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

1671:
1672: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1673:
1674: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1675: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOMS', MSC_CL_COLLECTION.v_instance_id, -1);
1676: ELSE
1677: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1678: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOMS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1679: END IF;

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

1674: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1675: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOMS', MSC_CL_COLLECTION.v_instance_id, -1);
1676: ELSE
1677: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1678: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOMS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1679: END IF;
1680:
1681: BEGIN
1682: lv_sql_ins :=

Line 1683: 'INSERT INTO MSC_BOMS '

1679: END IF;
1680:
1681: BEGIN
1682: lv_sql_ins :=
1683: 'INSERT INTO MSC_BOMS '
1684: ||'( PLAN_ID,'
1685: ||' ASSEMBLY_TYPE,'
1686: ||' ALTERNATE_BOM_DESIGNATOR,'
1687: ||' SPECIFIC_ASSEMBLY_COMMENT,'

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

1735:
1736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1737: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1738: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1739: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1740: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1741:
1742: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1743: RAISE;

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

1745: ELSE
1746: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1747: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1748: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1749: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1750: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1751:
1752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1753:

Line 1771: DELETE MSC_BOMS

1767: IF MSC_CL_COLLECTION.v_is_incremental_refresh OR lb_refresh_failed THEN
1768:
1769: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1770: FOR c_rec IN c2_d LOOP
1771: DELETE MSC_BOMS
1772: WHERE PLAN_ID= -1
1773: AND BILL_SEQUENCE_ID= c_rec.BILL_SEQUENCE_ID
1774: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
1775: END LOOP;

Line 1827: UPDATE MSC_BOMS

1823:
1824: BEGIN
1825: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1826:
1827: UPDATE MSC_BOMS
1828: SET
1829: ASSEMBLY_TYPE= lb_ASSEMBLY_TYPE(j),
1830: ALTERNATE_BOM_DESIGNATOR= lb_ALTERNATE_BOM_DESIGNATOR(j),
1831: SPECIFIC_ASSEMBLY_COMMENT= lb_SPECIFIC_ASSEMBLY_COMMENT(j),

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

1880:
1881: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1882: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1883: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1884: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1885: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1886:
1887: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1888: RAISE;

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

1893:
1894: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1895: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1896: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1897: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1899:
1900: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1901: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');