eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_DUNS_M_C dependencies on EDW_LOG

Line 44: edw_log.put_line( 'The collection range is from '||

40:
41: EDW_DUNS_M_C.g_push_date_range2 := nvl(l_to_date,
42: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
43:
44: edw_log.put_line( 'The collection range is from '||
45: to_char(EDW_DUNS_M_C.g_push_date_range1,
46: 'MM/DD/YYYY HH24:MI:SS')||' to '||
47: to_char(EDW_DUNS_M_C.g_push_date_range2,
48: 'MM/DD/YYYY HH24:MI:SS'));

Line 50: edw_log.put_line(' ');

46: 'MM/DD/YYYY HH24:MI:SS')||' to '||
47: to_char(EDW_DUNS_M_C.g_push_date_range2,
48: 'MM/DD/YYYY HH24:MI:SS'));
49:
50: edw_log.put_line(' ');
51: edw_log.put_line('Pushing data');
52:
53: Push_EDW_DNB_TPRT();
54: Push_EDW_DUNS_NUMBER_LSTG(EDW_DUNS_M_C.g_push_date_range1,

Line 51: edw_log.put_line('Pushing data');

47: to_char(EDW_DUNS_M_C.g_push_date_range2,
48: 'MM/DD/YYYY HH24:MI:SS'));
49:
50: edw_log.put_line(' ');
51: edw_log.put_line('Pushing data');
52:
53: Push_EDW_DNB_TPRT();
54: Push_EDW_DUNS_NUMBER_LSTG(EDW_DUNS_M_C.g_push_date_range1,
55: EDW_DUNS_M_C.g_push_date_range2);

Line 74: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));

70: EDW_DUNS_M_C.g_push_date_range2);
71:
72: l_duration := sysdate - l_temp_date;
73:
74: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
75: edw_log.put_line(' ');
76:
77: -- ---------------------------------------------------------------------------
78: -- END OF Collection , Developer Customizable Section

Line 75: edw_log.put_line(' ');

71:
72: l_duration := sysdate - l_temp_date;
73:
74: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
75: edw_log.put_line(' ');
76:
77: -- ---------------------------------------------------------------------------
78: -- END OF Collection , Developer Customizable Section
79: -- ---------------------------------------------------------------------------

Line 172: edw_log.put_line('Updating dnb failure code');

168:
169: BEGIN
170:
171: -- Update the lookup values in the Interface table
172: edw_log.put_line('Updating dnb failure code');
173: For lfailure in c_dnb_failure loop
174: Update POA_TPRT_INTERFACE dnb
175: set (FAILURE_VALUE) =
176: (select Description

Line 187: edw_log.put_line('Updating Dnb High Risk Code');

183: Update POA_TPRT_INTERFACE dnb
184: set FAILURE_VALUE = FAILURE_IND
185: where (FAILURE_VALUE IS NULL);
186:
187: edw_log.put_line('Updating Dnb High Risk Code');
188: For lhigh_risk in c_dnb_high_risk loop
189: Update POA_TPRT_INTERFACE dnb
190: set (HIGH_RISK_VALUE) =
191: (select Description

Line 202: edw_log.put_line('Updating Minority Code');

198: Update POA_TPRT_INTERFACE dnb
199: set HIGH_RISK_VALUE = HIGH_RISK_INDCATOR
200: where (HIGH_RISK_VALUE IS NULL);
201:
202: edw_log.put_line('Updating Minority Code');
203: For lminority_owned in c_dnb_minority_owned loop
204: Update POA_TPRT_INTERFACE dnb
205: set (MINORITY_OWNED_VALUE) =
206: (select Description

Line 217: edw_log.put_line('Updating DNB Current Statement');

213: Update POA_TPRT_INTERFACE dnb
214: set MINORITY_OWNED_VALUE = MINORITY_OWNED_IND
215: where (MINORITY_OWNED_VALUE IS NULL);
216:
217: edw_log.put_line('Updating DNB Current Statement');
218: For lcurrent_statement in c_dnb_current_statement loop
219: Update POA_TPRT_INTERFACE dnb
220: set (CURRENT_STATEMENT_VALUE) =
221: (select Description

Line 234: edw_log.put_line('Updating Legal Status');

230: Update POA_TPRT_INTERFACE dnb
231: set CURRENT_STATEMENT_VALUE = CURRENT_STATEMENT_TYPE
232: where (CURRENT_STATEMENT_VALUE IS NULL);
233:
234: edw_log.put_line('Updating Legal Status');
235: For llegal_status in c_dnb_legal_status loop
236: Update POA_TPRT_INTERFACE dnb
237: set (LEGAL_STATUS_VALUE) =
238: (select Description

Line 249: edw_log.put_line('Updating Fire Disaster Code');

245: Update POA_TPRT_INTERFACE dnb
246: set LEGAL_STATUS_VALUE = LEGAL_STATUS
247: where (LEGAL_STATUS_VALUE IS NULL);
248:
249: edw_log.put_line('Updating Fire Disaster Code');
250: For lfire_disaster in c_dnb_fire_disaster loop
251: Update POA_TPRT_INTERFACE dnb
252: set (FIRE_DISASTER_VALUE) =
253: (select Description

Line 264: edw_log.put_line('Updating DNB owns/Rents Code');

260: Update POA_TPRT_INTERFACE dnb
261: set FIRE_DISASTER_VALUE = FIRE_DISASTER_IND
262: where (FIRE_DISASTER_VALUE IS NULL);
263:
264: edw_log.put_line('Updating DNB owns/Rents Code');
265: For lowns_rents in c_dnb_owns_rents loop
266: Update POA_TPRT_INTERFACE dnb
267: set (OWNS_RENTS_VALUE) =
268: (select Description

Line 279: edw_log.put_line('Updating History Code');

275: Update POA_TPRT_INTERFACE dnb
276: set OWNS_RENTS_VALUE = OWNS_RENTS_IND
277: where (OWNS_RENTS_VALUE IS NULL);
278:
279: edw_log.put_line('Updating History Code');
280: For lhistory in c_dnb_history loop
281: Update POA_TPRT_INTERFACE dnb
282: set (HISTORY_VALUE) =
283: (select Description

Line 294: edw_log.put_line('Updating Location Status Code');

290: Update POA_TPRT_INTERFACE dnb
291: set HISTORY_VALUE = HISTORY
292: where (HISTORY IS NULL);
293:
294: edw_log.put_line('Updating Location Status Code');
295: For llocation_status in c_dnb_location_status loop
296: Update POA_TPRT_INTERFACE dnb
297: set (LOCATION_STATUS_VALUE) =
298: (select Description

Line 309: edw_log.put_line('Updating DNB OOB');

305: Update POA_TPRT_INTERFACE dnb
306: set LOCATION_STATUS_VALUE = LOCATION_STATUS_IND
307: where (LOCATION_STATUS_VALUE IS NULL);
308:
309: edw_log.put_line('Updating DNB OOB');
310: For loob in c_dnb_oob loop
311: Update POA_TPRT_INTERFACE dnb
312: set (OOB_VALUE) =
313: (select Description

Line 324: edw_log.put_line('Updating Criminal Proceedings Code');

320: Update POA_TPRT_INTERFACE dnb
321: set OOB_VALUE = OOB_IND
322: where (OOB_VALUE IS NULL);
323:
324: edw_log.put_line('Updating Criminal Proceedings Code');
325: For lcriminal_proceedings in c_dnb_criminal_proceedings loop
326: Update POA_TPRT_INTERFACE dnb
327: set (CRIMINAL_PROCEEDINGS_VALUE) =
328: (select Description

Line 341: edw_log.put_line('Updating Bankruptcy Code');

337: Update POA_TPRT_INTERFACE dnb
338: set CRIMINAL_PROCEEDINGS_VALUE = CRIMINAL_PROCEEDINGS_IND
339: where (CRIMINAL_PROCEEDINGS_VALUE IS NULL);
340:
341: edw_log.put_line('Updating Bankruptcy Code');
342: For lbankruptcy in c_dnb_bankruptcy loop
343: Update POA_TPRT_INTERFACE dnb
344: set (BANKRUPTCY_VALUE) =
345: (select Description

Line 356: edw_log.put_line('Updating Business Moved Code');

352: Update POA_TPRT_INTERFACE dnb
353: set BANKRUPTCY_VALUE = BANKRUPTCY_IND
354: where (BANKRUPTCY_VALUE IS NULL);
355:
356: edw_log.put_line('Updating Business Moved Code');
357: For lbusiness_moved in c_dnb_business_moved loop
358: Update POA_TPRT_INTERFACE dnb
359: set (BUSINESS_MOVED_VALUE) =
360: (select Description

Line 372: edw_log.put_line('Starting Push_EDW_DNB_TPRT');

368: set BUSINESS_MOVED_VALUE = BUSINESS_MOVED_IND
369: where (BUSINESS_MOVED_VALUE IS NULL);
370:
371: -- Update Trading Partner Vendor Sites (Lowest Level)
372: edw_log.put_line('Starting Push_EDW_DNB_TPRT');
373: edw_log.put_line('Update Trading Partner Vendor Sites (Lowest Level)');
374:
375: g_start_time := sysdate;
376:

Line 373: edw_log.put_line('Update Trading Partner Vendor Sites (Lowest Level)');

369: where (BUSINESS_MOVED_VALUE IS NULL);
370:
371: -- Update Trading Partner Vendor Sites (Lowest Level)
372: edw_log.put_line('Starting Push_EDW_DNB_TPRT');
373: edw_log.put_line('Update Trading Partner Vendor Sites (Lowest Level)');
374:
375: g_start_time := sysdate;
376:
377: Update POA_DNB_TRD_PRTNR poa

Line 398: edw_log.put_line('Update of Trading Partner Vendor Sites complete');

394: where ((poa.TRADING_PARTNER_PK = dnb.TRADING_PARTNER_PK) and
395: ((poa.DUNS <> dnb.DUNS) OR
396: (poa.SIC_CODE <> dnb.SIC_CODE_1))));
397:
398: edw_log.put_line('Update of Trading Partner Vendor Sites complete');
399: edw_log.put_line('Insert Trading Partner Vendor Sites (Lowest Level)');
400: insert into POA_DNB_TRD_PRTNR poa (
401: TRADING_PARTNER_PK,
402: TRADING_PARTNER_NAME,

Line 399: edw_log.put_line('Insert Trading Partner Vendor Sites (Lowest Level)');

395: ((poa.DUNS <> dnb.DUNS) OR
396: (poa.SIC_CODE <> dnb.SIC_CODE_1))));
397:
398: edw_log.put_line('Update of Trading Partner Vendor Sites complete');
399: edw_log.put_line('Insert Trading Partner Vendor Sites (Lowest Level)');
400: insert into POA_DNB_TRD_PRTNR poa (
401: TRADING_PARTNER_PK,
402: TRADING_PARTNER_NAME,
403: DUNS,

Line 421: edw_log.put_line('Insert of Trading Partner Vendor Sites complete');

417: POA_DNB_TRD_PRTNR pdtp
418: where ltrim(rtrim(pdtp.TRADING_PARTNER_PK)) IS NOT NULL
419: and dnb.TRADING_PARTNER_PK = pdtp.TRADING_PARTNER_PK);
420:
421: edw_log.put_line('Insert of Trading Partner Vendor Sites complete');
422:
423: /*
424: -- Commenting this portion out for bug 2377655 (Ford)
425: -- This cursor is taking the maximum amount of time

Line 434: edw_log.put_line('Update Trading Partner Vendors (Higher levels)');

430: -- Also, the duns interface table poa_tprt_interface has only
431: -- supplier site level records
432:
433: -- Update Trading Partner Vendors (Higher levels)
434: edw_log.put_line('Update Trading Partner Vendors (Higher levels)');
435: BEGIN
436: For lvendor in c_vendors loop
437: DECLARE
438: CURSOR c_vendor_site IS

Line 458: edw_log.put_line('Update of Trading Partner Vendor complete');

454: POA_TPRT_INTERFACE dnb
455: where ((poa.TRADING_PARTNER_PK = lvendor.Trade_Partner_FK) and
456: (poa.DUNS <> lvsite.Global_Ult_Duns)));
457:
458: edw_log.put_line('Update of Trading Partner Vendor complete');
459: edw_log.put_line('Insert Trading Partner Vendors (Higher levels)');
460:
461: Insert into POA_DNB_TRD_PRTNR poa (
462: TRADING_PARTNER_PK,

Line 459: edw_log.put_line('Insert Trading Partner Vendors (Higher levels)');

455: where ((poa.TRADING_PARTNER_PK = lvendor.Trade_Partner_FK) and
456: (poa.DUNS <> lvsite.Global_Ult_Duns)));
457:
458: edw_log.put_line('Update of Trading Partner Vendor complete');
459: edw_log.put_line('Insert Trading Partner Vendors (Higher levels)');
460:
461: Insert into POA_DNB_TRD_PRTNR poa (
462: TRADING_PARTNER_PK,
463: TRADING_PARTNER_NAME,

Line 476: edw_log.put_line('Insert of Trading Partner Vendor complete');

472: (select 'X'
473: from POA_DNB_TRD_PRTNR pdtp
474: where ltrim(rtrim(Trading_Partner_PK)) IS NOT NULL
475: and pdtp.Trading_Partner_PK = lvendor.Trade_Partner_FK);
476: edw_log.put_line('Insert of Trading Partner Vendor complete');
477: exit;
478: END LOOP;
479: END;
480: END LOOP;

Line 484: edw_log.put_line('Updating SIC Code');

480: END LOOP;
481: END Push_EDW_DNB_TPRT;
482: */
483: -- Update the SIC Code Combination Table
484: edw_log.put_line('Updating SIC Code');
485: Update POA_DNB_SIC_CODE poa
486: set (SIC_Code,
487: SIC_Description,
488: DNB_Update_Date) =

Line 499: edw_log.put_line('Inserting SIC Code');

495: from POA_TPRT_INTERFACE dnb
496: where ((poa.SIC_Code = dnb.SIC_CODE_1) and
497: (poa.SIC_Description <> dnb.SIC_1_DESCRIPTION)));
498:
499: edw_log.put_line('Inserting SIC Code');
500: insert into POA_DNB_SIC_CODE poa (
501: SIC_Code,
502: SIC_Description,
503: DNB_Update_Date)

Line 514: edw_log.put_line('Completed Push_EDW_DNB_TPRT');

510: where ltrim(rtrim(SIC_Code)) IS NOT NULL
511: and dnb.sic_code_1 = pdsc.sic_code));
512:
513:
514: edw_log.put_line('Completed Push_EDW_DNB_TPRT');
515: Exception When others then
516: raise;
517: commit;
518:

Line 528: edw_log.put_line('Starting Push_EDW__DUNS_NUMBER_LSTG');

524: l_date1 DATE;
525: l_date2 DATE;
526: l_rows_inserted NUMBER :=0;
527: BEGIN
528: edw_log.put_line('Starting Push_EDW__DUNS_NUMBER_LSTG');
529: l_date1 := p_from_date;
530: l_date2 := p_to_date;
531:
532: Insert Into

Line 809: edw_log.put_line('Commiting records for EDW_DUNS_NUMBER_LSTG');

805: l_rows_inserted := sql%rowcount;
806:
807: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
808:
809: edw_log.put_line('Commiting records for EDW_DUNS_NUMBER_LSTG');
810: commit;
811:
812: edw_log.put_line('Completed Push_EDW_DUNS_NUMBER_LSTG');
813: Exception When others then

Line 812: edw_log.put_line('Completed Push_EDW_DUNS_NUMBER_LSTG');

808:
809: edw_log.put_line('Commiting records for EDW_DUNS_NUMBER_LSTG');
810: commit;
811:
812: edw_log.put_line('Completed Push_EDW_DUNS_NUMBER_LSTG');
813: Exception When others then
814: raise;
815: commit;
816: END Push_EDW_DUNS_NUMBER_LSTG;

Line 828: edw_log.put_line('Starting Push_DUNS_PARENT_LSTG');

824: l_date1 DATE;
825: l_date2 DATE;
826: l_rows_inserted NUMBER :=0;
827: BEGIN
828: edw_log.put_line('Starting Push_DUNS_PARENT_LSTG');
829: l_date1 := p_from_date;
830: l_date2 := p_to_date;
831: Insert Into
832: EDW_DUNS_PARENT_LSTG(

Line 907: edw_log.put_line('Commiting records for EDW_DUNS_PARENT_LSTG');

903: where (ltrim(rtrim(PARENT_DUNS)) IS NULL);
904:
905: l_rows_inserted := l_rows_inserted + sql%rowcount;
906: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
907: edw_log.put_line('Commiting records for EDW_DUNS_PARENT_LSTG');
908: commit;
909:
910: edw_log.put_line('Completed Push_EDW_DUNS_PARENT_LSTG');
911: Exception When others then

Line 910: edw_log.put_line('Completed Push_EDW_DUNS_PARENT_LSTG');

906: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
907: edw_log.put_line('Commiting records for EDW_DUNS_PARENT_LSTG');
908: commit;
909:
910: edw_log.put_line('Completed Push_EDW_DUNS_PARENT_LSTG');
911: Exception When others then
912: raise;
913: commit;
914: END Push_EDW_DUNS_PARENT_LSTG;

Line 924: edw_log.put_line('Starting Push_DUNS_DOMESTIC_LSTG');

920: l_date1 DATE;
921: l_date2 DATE;
922: l_rows_inserted NUMBER :=0;
923: BEGIN
924: edw_log.put_line('Starting Push_DUNS_DOMESTIC_LSTG');
925: l_date1 := p_from_date;
926: l_date2 := p_to_date;
927: Insert Into
928: EDW_DUNS_DOMESTIC_LSTG(

Line 1001: edw_log.put_line('Commiting records for EDW_DUNS_DOMESTIC_LSTG');

997: from POA_TPRT_INTERFACE dnb
998: where (ltrim(rtrim(DOMESTIC_ULT_DUNS)) IS NULL);
999:
1000: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1001: edw_log.put_line('Commiting records for EDW_DUNS_DOMESTIC_LSTG');
1002: commit;
1003:
1004: edw_log.put_line('Completed Push_EDW_DUNS_DOMESTIC_LSTG');
1005: Exception When others then

Line 1004: edw_log.put_line('Completed Push_EDW_DUNS_DOMESTIC_LSTG');

1000: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1001: edw_log.put_line('Commiting records for EDW_DUNS_DOMESTIC_LSTG');
1002: commit;
1003:
1004: edw_log.put_line('Completed Push_EDW_DUNS_DOMESTIC_LSTG');
1005: Exception When others then
1006: raise;
1007: commit;
1008: END Push_EDW_DUNS_DOMESTIC_LSTG;

Line 1018: edw_log.put_line('Starting Push_DUNS_GLOBAL_LSTG');

1014: l_date1 DATE;
1015: l_date2 DATE;
1016: l_rows_inserted NUMBER :=0;
1017: BEGIN
1018: edw_log.put_line('Starting Push_DUNS_GLOBAL_LSTG');
1019: l_date1 := p_from_date;
1020: l_date2 := p_to_date;
1021: Insert Into
1022: EDW_DUNS_GLOBAL_LSTG(

Line 1056: edw_log.put_line('Commiting records for EDW_DUNS_GLOBAL_LSTG');

1052: from POA_TPRT_INTERFACE dnb;
1053:
1054: l_rows_inserted := sql%rowcount;
1055: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1056: edw_log.put_line('Commiting records for EDW_DUNS_GLOBAL_LSTG');
1057: commit;
1058:
1059: -- Push Global Ultimate to all lower level if needed
1060: Insert into EDW_DUNS_DOMESTIC_LSTG(

Line 1103: edw_log.put_line('Commiting records for EDW_DUNS_DOMESTIC_LSTG');

1099: and dnb.GLOBAL_ULT_DUNS = pti.DUNS));
1100:
1101: l_rows_inserted := sql%rowcount;
1102: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1103: edw_log.put_line('Commiting records for EDW_DUNS_DOMESTIC_LSTG');
1104: commit;
1105:
1106: Insert into EDW_DUNS_HEADQTR_LSTG(
1107: HQ_PK,

Line 1149: edw_log.put_line('Commiting records for EDW_DUNS_HEADQTR_LSTG');

1145: and dnb.GLOBAL_ULT_DUNS = pti.DUNS));
1146:
1147: l_rows_inserted := sql%rowcount;
1148: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1149: edw_log.put_line('Commiting records for EDW_DUNS_HEADQTR_LSTG');
1150: commit;
1151:
1152: Insert into EDW_DUNS_PARENT_LSTG(
1153: PARENT_PK,

Line 1195: edw_log.put_line('Commiting records for EDW_DUNS_PARENT_LSTG');

1191: and dnb.GLOBAL_ULT_DUNS = pti.DUNS));
1192:
1193: l_rows_inserted := sql%rowcount;
1194: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1195: edw_log.put_line('Commiting records for EDW_DUNS_PARENT_LSTG');
1196: commit;
1197:
1198: Insert into EDW_DUNS_NUMBER_LSTG(
1199: DUNS_NUM_PK,

Line 1310: edw_log.put_line('Commiting records for EDW_DUNS_NUMBER_LSTG');

1306: and dnb.GLOBAL_ULT_DUNS = pti.DUNS)));
1307:
1308: l_rows_inserted := sql%rowcount;
1309: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1310: edw_log.put_line('Commiting records for EDW_DUNS_NUMBER_LSTG');
1311: commit;
1312:
1313: edw_log.put_line('Completed Push_EDW_DUNS_GLOBAL_LSTG');
1314: Exception When others then

Line 1313: edw_log.put_line('Completed Push_EDW_DUNS_GLOBAL_LSTG');

1309: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1310: edw_log.put_line('Commiting records for EDW_DUNS_NUMBER_LSTG');
1311: commit;
1312:
1313: edw_log.put_line('Completed Push_EDW_DUNS_GLOBAL_LSTG');
1314: Exception When others then
1315: raise;
1316: commit;
1317: END Push_EDW_DUNS_GLOBAL_LSTG;

Line 1327: edw_log.put_line('Starting Push_EDW_HEADQTR_LSTG');

1323: l_date1 DATE;
1324: l_date2 DATE;
1325: l_rows_inserted NUMBER :=0;
1326: BEGIN
1327: edw_log.put_line('Starting Push_EDW_HEADQTR_LSTG');
1328: l_date1 := p_from_date;
1329: l_date2 := p_to_date;
1330: Insert Into
1331: EDW_DUNS_HEADQTR_LSTG(

Line 1404: edw_log.put_line('Commiting records for EDW_DUNS_HEADQTR_LSTG');

1400: from POA_TPRT_INTERFACE dnb
1401: where (ltrim(rtrim(HQ_DUNS)) IS NULL);
1402:
1403: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1404: edw_log.put_line('Commiting records for EDW_DUNS_HEADQTR_LSTG');
1405: commit;
1406:
1407: edw_log.put_line('Completed Push_EDW_DUNS_HEADQTR_LSTG');
1408: Exception When others then

Line 1407: edw_log.put_line('Completed Push_EDW_DUNS_HEADQTR_LSTG');

1403: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1404: edw_log.put_line('Commiting records for EDW_DUNS_HEADQTR_LSTG');
1405: commit;
1406:
1407: edw_log.put_line('Completed Push_EDW_DUNS_HEADQTR_LSTG');
1408: Exception When others then
1409: raise;
1410: commit;
1411: END Push_EDW_DUNS_HEADQTR_LSTG;

Line 1420: edw_log.put_line('Starting Push_SICM_SIC_LSTG');

1416: l_date1 DATE;
1417: l_date2 DATE;
1418: l_rows_inserted NUMBER :=0;
1419: BEGIN
1420: edw_log.put_line('Starting Push_SICM_SIC_LSTG');
1421: l_date1 := p_from_date;
1422: l_date2 := p_to_date;
1423: Insert Into
1424: EDW_SICM_SIC_LSTG(

Line 1444: edw_log.put_line('Commiting records for EDW_SICM_SIC_LSTG');

1440: from POA_DNB_SIC_CODE poa;
1441:
1442: l_rows_inserted := sql%rowcount;
1443: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1444: edw_log.put_line('Commiting records for EDW_SICM_SIC_LSTG');
1445: Exception When others then
1446: raise;
1447: commit;
1448: END Push_EDW_SICM_SIC_LSTG;