APPS.PMI_BUILD_PROD_SUM dependencies on PMI_PROD_SUM

Line 48: DELETE PMI_PROD_SUM

44: EXIT WHEN check_cldr_for_perd_bal%NOTFOUND;
45: /* Delete data for the current processing period from summary table and insert summary data
46: into summary table using transaction tables.
47: */
48: DELETE PMI_PROD_SUM
49: WHERE co_Code = cldr_rec.co_code
50: AND period_set_name = cldr_rec.period_Set_name
51: AND period_name = cldr_rec.period_name;
52:

Line 54: INSERT INTO PMI_PROD_SUM(FISCAL_YEAR

50: AND period_set_name = cldr_rec.period_Set_name
51: AND period_name = cldr_rec.period_name;
52:
53:
54: INSERT INTO PMI_PROD_SUM(FISCAL_YEAR
55: ,CO_CODE
56: ,ORGN_CODE
57: ,WHSE_CODE
58: ,PERIOD_ID

Line 161: WHERE summary_table = 'PMI_PROD_SUM';

157: -- Cursors and cursor row type variables
158: CURSOR cur_bisopm_prod IS
159: SELECT LAST_RUN_DATE,ATTR1
160: FROM PMI_SUMMARY_LOG_TABLE
161: WHERE summary_table = 'PMI_PROD_SUM';
162: CURSOR cur_last_trans_eff_date IS
163: SELECT min(trans_date)
164: from (Select (min(trans_date)) trans_date
165: from IC_TRAN_PND

Line 182: FROM PMI_PROD_SUM

178: IF cur_bisopm_prod%NOTFOUND THEN
179: CLOSE cur_bisopm_prod;
180: BEGIN
181: SELECT 1 into rows_exists
182: FROM PMI_PROD_SUM
183: WHERE ROWNUM = 1;
184: errbuf := FND_MESSAGE.get_string('PMI','PMI_SUMM_POPULATION_ERR');
185: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf );
186: retcode:= '2';

Line 210: DELETE pmi_prod_sum;

206: /* Delete data from summary table. now we need to populate using new conversion UOM */
207: buff32k := FND_MESSAGE.get_number('PMI','PMI_CONV_UOM_VAL_CHG') ||'-'||
208: FND_MESSAGE.get_string('PMI','PMI_CONV_UOM_VAL_CHG');
209: FND_FILE.PUT_LINE(FND_FILE.LOG, buff32k );
210: DELETE pmi_prod_sum;
211: COMMIT;
212: l_last_run_date := NULL;
213: END IF;
214: OPEN cur_last_trans_eff_date;

Line 223: WHERE summary_table = 'PMI_PROD_SUM';

219: BEGIN
220: UPDATE PMI_SUMMARY_LOG_TABLE
221: SET LAST_RUN_DATE = l_log_end_date,
222: ATTR1 = PV_conv_uom
223: WHERE summary_table = 'PMI_PROD_SUM';
224: IF SQL%ROWCOUNT = 0 THEN
225: INSERT INTO PMI_SUMMARY_LOG_TABLE (SUMMARY_TABLE,LAST_RUN_DATE,ATTR1,ATTR2,ATTR3,ATTR4,ATTR5,ATTR6)
226: VALUES ('PMI_PROD_SUM',l_log_end_date,PV_conv_uom,null,null,null,null,null);
227: END IF;

Line 226: VALUES ('PMI_PROD_SUM',l_log_end_date,PV_conv_uom,null,null,null,null,null);

222: ATTR1 = PV_conv_uom
223: WHERE summary_table = 'PMI_PROD_SUM';
224: IF SQL%ROWCOUNT = 0 THEN
225: INSERT INTO PMI_SUMMARY_LOG_TABLE (SUMMARY_TABLE,LAST_RUN_DATE,ATTR1,ATTR2,ATTR3,ATTR4,ATTR5,ATTR6)
226: VALUES ('PMI_PROD_SUM',l_log_end_date,PV_conv_uom,null,null,null,null,null);
227: END IF;
228: END;
229:
230: SELECT TABLE_OWNER INTO l_table_owner

Line 232: WHERE SYNONYM_NAME = 'PMI_PROD_SUM';

228: END;
229:
230: SELECT TABLE_OWNER INTO l_table_owner
231: FROM USER_SYNONYMS
232: WHERE SYNONYM_NAME = 'PMI_PROD_SUM';
233: FND_STATS.GATHER_TABLE_STATS(l_table_owner, 'PMI_PROD_SUM');
234:
235:
236: ELSE

Line 233: FND_STATS.GATHER_TABLE_STATS(l_table_owner, 'PMI_PROD_SUM');

229:
230: SELECT TABLE_OWNER INTO l_table_owner
231: FROM USER_SYNONYMS
232: WHERE SYNONYM_NAME = 'PMI_PROD_SUM';
233: FND_STATS.GATHER_TABLE_STATS(l_table_owner, 'PMI_PROD_SUM');
234:
235:
236: ELSE
237: buff32k := FND_MESSAGE.get_number('PMI','PMI_CONV_UOM_PROF_MISS') ||'-'||