APPS.EDW_GEOGRAPHY_M_C dependencies on EDW_GEOGRAPHY_M_C

Line 1: Package Body EDW_GEOGRAPHY_M_C AS

1: Package Body EDW_GEOGRAPHY_M_C AS
2: /* $Header: poaphge.pkb 120.1 2005/06/13 13:06:36 sriswami noship $ */
3: G_PUSH_DATE_RANGE1 Date:=Null;
4: G_PUSH_DATE_RANGE2 Date:=Null;
5: g_row_count Number:=0;

Line 100: EDW_GEOGRAPHY_M_C.g_exception_msg := l_exception_msg;

96: Exception When others then
97: Errbuf:=sqlerrm;
98: Retcode:=sqlcode;
99: l_exception_msg := Retcode || ':' || Errbuf;
100: EDW_GEOGRAPHY_M_C.g_exception_msg := l_exception_msg;
101: rollback;
102: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_GEOGRAPHY_M_C.g_exception_msg,
103: g_push_date_range1, g_push_date_range2);
104: End;

Line 102: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_GEOGRAPHY_M_C.g_exception_msg,

98: Retcode:=sqlcode;
99: l_exception_msg := Retcode || ':' || Errbuf;
100: EDW_GEOGRAPHY_M_C.g_exception_msg := l_exception_msg;
101: rollback;
102: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_GEOGRAPHY_M_C.g_exception_msg,
103: g_push_date_range1, g_push_date_range2);
104: End;
105:
106:

Line 178: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;

174: from EDW_GEOG_POSTCODE_CITY_LSTG
175: where collection_status='READY');
176:
177: l_rows_inserted := sql%rowcount;
178: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
179:
180: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
181: ' rows into the staging table');
182:

Line 185: EDW_GEOGRAPHY_M_C.g_row_count_m := l_rows_inserted;

181: ' rows into the staging table');
182:
183: edw_log.put_line('Completed Push_EDW_GEOG_LOCATION_LSTG');
184:
185: EDW_GEOGRAPHY_M_C.g_row_count_m := l_rows_inserted;
186:
187: Exception When others then
188: rollback;
189: raise;

Line 276: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;

272: where
273: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where POSTCODE_CITY_PK = TEMP_PK);
274:
275: l_rows_inserted := sql%rowcount;
276: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
277:
278: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
279: ' rows into the staging table');
280:

Line 458: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;

454: where
455: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where POSTCODE_PK = TEMP_PK);
456:
457: l_rows_inserted := sql%rowcount;
458: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
459:
460: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
461: ' rows into the staging table');
462:

Line 557: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;

553: where
554: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where STATE_REGION_PK = TEMP_PK);
555:
556: l_rows_inserted := sql%rowcount;
557: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
558:
559: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
560: ' rows into the staging table');
561:

Line 649: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;

645: where
646: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where STATE_PK = TEMP_PK);
647:
648: l_rows_inserted := sql%rowcount;
649: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
650:
651: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
652: ' rows into the staging table');
653:

Line 839: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;

835: where
836: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where COUNTRY_PK = TEMP_PK);
837:
838: l_rows_inserted := sql%rowcount;
839: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
840:
841: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
842: ' rows into the staging table');
843:

Line 922: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;

918: OR last_update_date is NULL)
919: AND NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where AREA2_PK = TEMP_PK);
920:
921: l_rows_inserted := sql%rowcount;
922: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
923:
924: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
925: ' rows into the staging table');
926:

Line 1004: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;

1000: OR last_update_date is NULL)
1001: AND NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where AREA1_PK = TEMP_PK);
1002:
1003: l_rows_inserted := sql%rowcount;
1004: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
1005:
1006: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
1007: ' rows into the staging table');
1008:

Line 1016: End EDW_GEOGRAPHY_M_C;

1012: rollback;
1013: raise;
1014:
1015: END;
1016: End EDW_GEOGRAPHY_M_C;