APPS.ISC_MAINT_WO_ETL_PKG dependencies on ISC_MAINT_WORK_ORDERS_F

Line 23: from ISC_MAINT_WORK_ORDERS_F

19: IS
20:
21: CURSOR c_Last_Collection_Date is
22: Select Last_Update_Date
23: from ISC_MAINT_WORK_ORDERS_F
24: WHERE Organization_id = -99 and Work_Order_id = -99 and Entity_Type = -1;
25:
26: l_last_update_date DATE;
27: l_stmt_num number;

Line 39: INSERT INTO ISC_MAINT_WORK_ORDERS_F

35: FETCH c_Last_Collection_Date into l_last_update_date;
36: IF c_Last_Collection_Date %notfound THEN
37:
38: l_stmt_num := 20;
39: INSERT INTO ISC_MAINT_WORK_ORDERS_F
40: (ORGANIZATION_ID, WORK_ORDER_ID, WORK_ORDER_NAME, ENTITY_TYPE, CREATION_DATE,
41: LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
42: program_id, program_login_id, program_application_id, request_id)
43: VALUES(-99, -99, 'LAST COLLECTION DATE', -1, SYSDATE, SYSDATE, -1, -1, -1, -1, -1, -1, -1);

Line 48: UPDATE ISC_MAINT_WORK_ORDERS_F

44:
45: ELSE
46:
47: l_stmt_num := 30;
48: UPDATE ISC_MAINT_WORK_ORDERS_F
49: SET LAST_UPDATE_DATE = SYSDATE
50: WHERE Organization_id = -99 and Work_Order_id = -99 and Entity_Type = -1;
51:
52: END IF;

Line 97: IF BIS_COLLECTION_UTILITIES.SETUP( 'ISC_MAINT_WORK_ORDERS_F' ) = FALSE THEN

93: l_list(1) := 'BIS_GLOBAL_START_DATE';
94:
95: IF (bis_common_parameters.check_global_parameters(l_list)) THEN
96:
97: IF BIS_COLLECTION_UTILITIES.SETUP( 'ISC_MAINT_WORK_ORDERS_F' ) = FALSE THEN
98: RAISE_APPLICATION_ERROR(-20000, errbuf);
99: End if;
100:
101: l_stmt_num := 1;

Line 104: execute immediate 'truncate table ' || l_isc_schema || '.ISC_MAINT_WORK_ORDERS_F PURGE MATERIALIZED VIEW LOG';

100:
101: l_stmt_num := 1;
102: IF fnd_installation.get_app_info( 'ISC', l_status, l_industry, l_isc_schema) THEN
103: -- execute immediate 'truncate table ' || l_isc_schema || '.MLOG$_ISC_MAINT_WORK_ORDER'; -- RSG will now take care of this
104: execute immediate 'truncate table ' || l_isc_schema || '.ISC_MAINT_WORK_ORDERS_F PURGE MATERIALIZED VIEW LOG';
105: END IF;
106:
107: l_stmt_num := 10;
108: BEGIN

Line 132: INSERT /*+ append parallel(ISC_MAINT_WORK_ORDERS_F) */ INTO ISC_MAINT_WORK_ORDERS_F

128: /* Insert into Work Orders Fact Table */
129:
130: /* EAM Work Orders master extraction into DBI EAM Work Orders Base Table */
131:
132: INSERT /*+ append parallel(ISC_MAINT_WORK_ORDERS_F) */ INTO ISC_MAINT_WORK_ORDERS_F
133: (
134: Organization_id
135: ,Work_Order_id
136: ,Work_Order_Name

Line 290: IF BIS_COLLECTION_UTILITIES.SETUP( 'ISC_MAINT_WORK_ORDERS_F' ) = FALSE THEN

286: l_list(1) := 'BIS_GLOBAL_START_DATE';
287:
288: IF (bis_common_parameters.check_global_parameters(l_list)) THEN
289:
290: IF BIS_COLLECTION_UTILITIES.SETUP( 'ISC_MAINT_WORK_ORDERS_F' ) = FALSE THEN
291: RAISE_APPLICATION_ERROR(-20000, errbuf);
292: End if;
293:
294: l_stmt_num := 10;

Line 310: SELECT Last_Update_Date INTO g_last_collection_date FROM ISC_MAINT_WORK_ORDERS_F

306: END;
307:
308: l_stmt_num := 20;
309: BEGIN
310: SELECT Last_Update_Date INTO g_last_collection_date FROM ISC_MAINT_WORK_ORDERS_F
311: WHERE Organization_id = -99 and Work_Order_id = -99 and Entity_Type = -1;
312: EXCEPTION
313: WHEN NO_DATA_FOUND THEN
314: BIS_COLLECTION_UTILITIES.put_line('Last collection date is not available. Cannot proceed.');

Line 335: MERGE INTO ISC_MAINT_WORK_ORDERS_F f USING

331:
332: l_stmt_num := 40;
333: /* EAM Work Orders extraction into Work Orders Base Table */
334:
335: MERGE INTO ISC_MAINT_WORK_ORDERS_F f USING
336: (
337: Select
338: Organization_id
339: ,Work_Order_id