APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_CARRIER_SERVICES

Line 1474: -- 5. MSC_CARRIER_SERVICES

1470: -- 1. MSC_REGIONS
1471: -- 2. MSC_ZONE_REGIONS
1472: -- 3. MSC_REGION_LOCATIONS
1473: -- 4. MSC_REGION_SITES
1474: -- 5. MSC_CARRIER_SERVICES
1475:
1476: SELECT
1477: decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
1478: INTO lv_control_flag

Line 1873: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_CARRIER_SERVICES', MSC_CL_COLLECTION.v_instance_id,-1);

1869:
1870: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1871:
1872: IF lv_control_flag = 2 THEN
1873: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_CARRIER_SERVICES', MSC_CL_COLLECTION.v_instance_id,-1);
1874: ELSE
1875: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE('MSC_CARRIER_SERVICES');
1876: END IF;
1877:

Line 1875: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE('MSC_CARRIER_SERVICES');

1871:
1872: IF lv_control_flag = 2 THEN
1873: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_CARRIER_SERVICES', MSC_CL_COLLECTION.v_instance_id,-1);
1874: ELSE
1875: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE('MSC_CARRIER_SERVICES');
1876: END IF;
1877:
1878: END IF;
1879:

Line 1884: INSERT INTO MSC_CARRIER_SERVICES

1880: FOR c_rec IN c11 LOOP
1881:
1882: BEGIN
1883:
1884: INSERT INTO MSC_CARRIER_SERVICES
1885: (SHIP_METHOD_CODE,
1886: CARRIER_ID,
1887: SERVICE_LEVEL,
1888: MODE_OF_TRANSPORT,

Line 1918: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CARRIER_SERVICES');

1914:
1915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1916: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1917: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1918: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CARRIER_SERVICES');
1919: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1920:
1921: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1922: RAISE;