APPS.PMI_PRODUCTION_SUM dependencies on PMI_BATCH_STATUS

Line 10: delete from pmi_batch_status;

6: l_table_owner VARCHAR2(40);
7:
8: BEGIN
9:
10: delete from pmi_batch_status;
11: commit;
12:
13: /* Insert records for Plan Start */
14: Insert into pmi_batch_status (CO_CODE,

Line 14: Insert into pmi_batch_status (CO_CODE,

10: delete from pmi_batch_status;
11: commit;
12:
13: /* Insert records for Plan Start */
14: Insert into pmi_batch_status (CO_CODE,
15: PLANT_CODE,
16: WHSE_CODE,
17: FISCAL_YEAR,
18: PERIOD_NUM,

Line 52: Insert into pmi_batch_status (CO_CODE,

48: '1',
49: sysdate;
50:
51: /*Insert records for Plan Complete */
52: Insert into pmi_batch_status (CO_CODE,
53: PLANT_CODE,
54: WHSE_CODE,
55: FISCAL_YEAR,
56: PERIOD_NUM,

Line 91: Insert into pmi_batch_status (CO_CODE,

87: sysdate;
88:
89: /* Insert records for Actual Start */
90:
91: Insert into pmi_batch_status (CO_CODE,
92: PLANT_CODE,
93: WHSE_CODE,
94: FISCAL_YEAR,
95: PERIOD_NUM,

Line 130: Insert into pmi_batch_status (CO_CODE,

126: '2',
127: sysdate;
128:
129: /* Insert records for Actual Complete */
130: Insert into pmi_batch_status (CO_CODE,
131: PLANT_CODE,
132: WHSE_CODE,
133: FISCAL_YEAR,
134: PERIOD_NUM,

Line 169: Insert into pmi_batch_status (CO_CODE,

165: '4',
166: sysdate;
167:
168: /* Insert records for Closed */
169: Insert into pmi_batch_status (CO_CODE,
170: PLANT_CODE,
171: WHSE_CODE,
172: FISCAL_YEAR,
173: PERIOD_NUM,

Line 209: Insert into pmi_batch_status (CO_CODE,

205: sysdate;
206:
207:
208: /* Insert records for Cancelled */
209: Insert into pmi_batch_status (CO_CODE,
210: PLANT_CODE,
211: WHSE_CODE,
212: FISCAL_YEAR,
213: PERIOD_NUM,

Line 250: WHERE SYNONYM_NAME = 'PMI_BATCH_STATUS';

246:
247: Commit;
248: SELECT TABLE_OWNER INTO l_table_owner
249: FROM USER_SYNONYMS
250: WHERE SYNONYM_NAME = 'PMI_BATCH_STATUS';
251: FND_STATS.GATHER_TABLE_STATS(l_table_owner, 'PMI_BATCH_STATUS');
252:
253: exception when others then
254: l_buffer :='Summary table Population Failed'||l_count;

Line 251: FND_STATS.GATHER_TABLE_STATS(l_table_owner, 'PMI_BATCH_STATUS');

247: Commit;
248: SELECT TABLE_OWNER INTO l_table_owner
249: FROM USER_SYNONYMS
250: WHERE SYNONYM_NAME = 'PMI_BATCH_STATUS';
251: FND_STATS.GATHER_TABLE_STATS(l_table_owner, 'PMI_BATCH_STATUS');
252:
253: exception when others then
254: l_buffer :='Summary table Population Failed'||l_count;
255: FND_FILE.PUT_LINE(FND_FILE.LOG,l_buffer);