DBA Data[Home] [Help]

APPS.FII_AR_TPDUE_TBL_REFRESH dependencies on FII_AR_TPDUE_BASE_F

Line 98: -- This procedure will (fully) refresh table FII_AR_TPDUE_BASE_F

94:
95: ----------------------------------------------------
96: -- PROCEDURE REFRESH_AR_TPDUE_BASE_F (private)
97: --
98: -- This procedure will (fully) refresh table FII_AR_TPDUE_BASE_F
99: -- FROM FII_AR_NET_REC_BASE_MV AND FII_AR_DISPUTES_BASE_MV
100: ----------------------------------------------------
101: PROCEDURE REFRESH_AR_TPDUE_BASE_F IS
102:

Line 111: g_phase := 'Entering FII_AR_TPDUE_BASE_F';

107: l_min_start_date DATE;
108:
109: BEGIN
110: g_self_msg := FND_MESSAGE.get_string('FII', 'FII_AR_SELF');
111: g_phase := 'Entering FII_AR_TPDUE_BASE_F';
112: IF g_debug_flag = 'Y' THEN
113: FII_UTIL.Write_Log ('> Entering FII_AR_TPDUE_BASE_F');
114: FII_UTIL.start_timer();
115: END IF;

Line 113: FII_UTIL.Write_Log ('> Entering FII_AR_TPDUE_BASE_F');

109: BEGIN
110: g_self_msg := FND_MESSAGE.get_string('FII', 'FII_AR_SELF');
111: g_phase := 'Entering FII_AR_TPDUE_BASE_F';
112: IF g_debug_flag = 'Y' THEN
113: FII_UTIL.Write_Log ('> Entering FII_AR_TPDUE_BASE_F');
114: FII_UTIL.start_timer();
115: END IF;
116:
117:

Line 162: g_phase := 'Truncate table FII_AR_TPDUE_BASE_F';

158: FII_UTIL.Write_Log ('>> l_this_date = ' || l_this_date);
159: END IF;
160:
161: --Always do a full refresh for snapshot tables
162: g_phase := 'Truncate table FII_AR_TPDUE_BASE_F';
163: FII_UTIL.truncate_table ('FII_AR_TPDUE_BASE_F', 'FII', g_retcode);
164:
165: g_phase := 'Starting to populate table FII_AR_TPDUE_BASE_F';
166: IF g_debug_flag = 'Y' THEN

Line 163: FII_UTIL.truncate_table ('FII_AR_TPDUE_BASE_F', 'FII', g_retcode);

159: END IF;
160:
161: --Always do a full refresh for snapshot tables
162: g_phase := 'Truncate table FII_AR_TPDUE_BASE_F';
163: FII_UTIL.truncate_table ('FII_AR_TPDUE_BASE_F', 'FII', g_retcode);
164:
165: g_phase := 'Starting to populate table FII_AR_TPDUE_BASE_F';
166: IF g_debug_flag = 'Y' THEN
167: FII_UTIL.Write_Log ('>> Starting to populate table FII_AR_TPDUE_BASE_F');

Line 165: g_phase := 'Starting to populate table FII_AR_TPDUE_BASE_F';

161: --Always do a full refresh for snapshot tables
162: g_phase := 'Truncate table FII_AR_TPDUE_BASE_F';
163: FII_UTIL.truncate_table ('FII_AR_TPDUE_BASE_F', 'FII', g_retcode);
164:
165: g_phase := 'Starting to populate table FII_AR_TPDUE_BASE_F';
166: IF g_debug_flag = 'Y' THEN
167: FII_UTIL.Write_Log ('>> Starting to populate table FII_AR_TPDUE_BASE_F');
168: END IF;
169:

Line 167: FII_UTIL.Write_Log ('>> Starting to populate table FII_AR_TPDUE_BASE_F');

163: FII_UTIL.truncate_table ('FII_AR_TPDUE_BASE_F', 'FII', g_retcode);
164:
165: g_phase := 'Starting to populate table FII_AR_TPDUE_BASE_F';
166: IF g_debug_flag = 'Y' THEN
167: FII_UTIL.Write_Log ('>> Starting to populate table FII_AR_TPDUE_BASE_F');
168: END IF;
169:
170:
171: --------------------------------------------------------------------------

Line 179: insert /*+ append */ INTO FII_AR_TPDUE_BASE_F

175: --fii_customer_hierarchies and hz_parties is used to avoid
176: --costly GT table population while running the report
177: --------------------------------------------------------------------------
178:
179: insert /*+ append */ INTO FII_AR_TPDUE_BASE_F
180: ( parent_party_id,
181: party_id,
182: collector_id,
183: org_id,

Line 296: FII_UTIL.Write_Log ('FII_AR_TPDUE_BASE_F from fii_ar_net_rec_base_mv has been populated successfully');

292:
293:
294: IF g_debug_flag = 'Y' THEN
295: FII_UTIL.stop_timer();
296: FII_UTIL.Write_Log ('FII_AR_TPDUE_BASE_F from fii_ar_net_rec_base_mv has been populated successfully');
297: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
298: FII_UTIL.print_timer();
299: END IF;
300: commit;

Line 310: insert /*+ append */ INTO FII_AR_TPDUE_BASE_F

306: --costly GT table population while running the report
307: --------------------------------------------------------------------------
308:
309:
310: insert /*+ append */ INTO FII_AR_TPDUE_BASE_F
311: ( parent_party_id,
312: party_id,
313: collector_id,
314: org_id,

Line 397: FII_UTIL.Write_Log ('FII_AR_TPDUE_BASE_F has been populated from fii_ar_disputes_base_mv successfully');

393:
394:
395: IF g_debug_flag = 'Y' THEN
396: FII_UTIL.stop_timer();
397: FII_UTIL.Write_Log ('FII_AR_TPDUE_BASE_F has been populated from fii_ar_disputes_base_mv successfully');
398: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
399: FII_UTIL.print_timer();
400: END IF;
401:

Line 402: g_phase := 'Gather table stats for FII_AR_TPDUE_BASE_F';

398: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
399: FII_UTIL.print_timer();
400: END IF;
401:
402: g_phase := 'Gather table stats for FII_AR_TPDUE_BASE_F';
403: fnd_stats.gather_table_stats (ownname=>g_schema_name,
404: tabname=>'FII_AR_TPDUE_BASE_F');
405:
406: g_phase := 'Commit the change';

Line 404: tabname=>'FII_AR_TPDUE_BASE_F');

400: END IF;
401:
402: g_phase := 'Gather table stats for FII_AR_TPDUE_BASE_F';
403: fnd_stats.gather_table_stats (ownname=>g_schema_name,
404: tabname=>'FII_AR_TPDUE_BASE_F');
405:
406: g_phase := 'Commit the change';
407: commit;
408:

Line 410: FII_UTIL.Write_Log ('< Leaving FII_AR_TPDUE_BASE_F');

406: g_phase := 'Commit the change';
407: commit;
408:
409: IF g_debug_flag = 'Y' THEN
410: FII_UTIL.Write_Log ('< Leaving FII_AR_TPDUE_BASE_F');
411: FII_UTIL.Write_Log (' ');
412: END IF;
413:
414: EXCEPTION

Line 795: g_phase := 'Populating FII_AR_TPDUE_BASE_F';

791: END IF;
792:
793: Initialize;
794:
795: g_phase := 'Populating FII_AR_TPDUE_BASE_F';
796: IF g_debug_flag = 'Y' THEN
797: FII_UTIL.Write_Log ('Populating FII_AR_TPDUE_BASE_F');
798: END IF;
799:

Line 797: FII_UTIL.Write_Log ('Populating FII_AR_TPDUE_BASE_F');

793: Initialize;
794:
795: g_phase := 'Populating FII_AR_TPDUE_BASE_F';
796: IF g_debug_flag = 'Y' THEN
797: FII_UTIL.Write_Log ('Populating FII_AR_TPDUE_BASE_F');
798: END IF;
799:
800: REFRESH_AR_TPDUE_BASE_F;
801: