APPS.EDW_ITEMS_M_C dependencies on EDW_ITEMS_M_C

Line 1: PACKAGE BODY EDW_ITEMS_M_C AS

1: PACKAGE BODY EDW_ITEMS_M_C AS
2: /* $Header: ENICITMB.pls 120.3 2006/04/03 06:44:02 lparihar noship $ */
3:
4: l_collect_onetime VARCHAR2(10) := NULL;
5: l_push_date_range1 DATE := NULL;

Line 202: EDW_COLLECTION_UTIL.wrapup(TRUE, EDW_ITEMS_M_C.g_row_count,NULL, l_push_date_range1,l_push_date_range2);

198: Push_EDW_ITEM_PROD_LINE(l_push_date_range1, l_push_date_range2);
199: Push_EDW_ITEM_PROD_CATG(l_push_date_range1, l_push_date_range2);
200: Push_EDW_ITEM_PROD_GRP(l_push_date_range1, l_push_date_range2);
201:
202: EDW_COLLECTION_UTIL.wrapup(TRUE, EDW_ITEMS_M_C.g_row_count,NULL, l_push_date_range1,l_push_date_range2);
203: COMMIT;
204:
205: EXCEPTION WHEN OTHERS THEN
206: IF g_error_message IS NULL THEN

Line 209: EDW_ITEMS_M_C.g_EXCEPTION_message := EDW_ITEMS_M_C.g_EXCEPTION_message||' <> '||Retcode||' : '||Errbuf;

205: EXCEPTION WHEN OTHERS THEN
206: IF g_error_message IS NULL THEN
207: Errbuf := sqlerrm;
208: Retcode := sqlcode;
209: EDW_ITEMS_M_C.g_EXCEPTION_message := EDW_ITEMS_M_C.g_EXCEPTION_message||' <> '||Retcode||' : '||Errbuf;
210: ELSE
211: Retcode := 2;
212: g_error_message := 'ERROR: ' || g_error_message;
213: EDW_ITEMS_M_C.g_EXCEPTION_message := EDW_ITEMS_M_C.g_EXCEPTION_message||

Line 213: EDW_ITEMS_M_C.g_EXCEPTION_message := EDW_ITEMS_M_C.g_EXCEPTION_message||

209: EDW_ITEMS_M_C.g_EXCEPTION_message := EDW_ITEMS_M_C.g_EXCEPTION_message||' <> '||Retcode||' : '||Errbuf;
210: ELSE
211: Retcode := 2;
212: g_error_message := 'ERROR: ' || g_error_message;
213: EDW_ITEMS_M_C.g_EXCEPTION_message := EDW_ITEMS_M_C.g_EXCEPTION_message||
214: ' <> 2 : '|| g_error_message;
215: Errbuf := g_error_message;
216: END IF;
217: ROLLBACK;

Line 218: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_ITEMS_M_C.g_EXCEPTION_message,l_push_date_range1, l_push_date_range2);

214: ' <> 2 : '|| g_error_message;
215: Errbuf := g_error_message;
216: END IF;
217: ROLLBACK;
218: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_ITEMS_M_C.g_EXCEPTION_message,l_push_date_range1, l_push_date_range2);
219: COMMIT;
220:
221: END Push;
222:

Line 292: EDW_ITEMS_M_C.g_row_count:=EDW_ITEMS_M_C.g_row_count+l_rows_inserted;

288: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||
289: ' rows into the staging table');
290: edw_log.put_line(' ');
291:
292: EDW_ITEMS_M_C.g_row_count:=EDW_ITEMS_M_C.g_row_count+l_rows_inserted;
293: COMMIT;
294:
295: EXCEPTION WHEN OTHERS THEN
296: RAISE;

Line 1072: EDW_ITEMS_M_C.g_row_count:=EDW_ITEMS_M_C.g_row_count+l_rows_inserted;

1068: l_rows_inserted := SQL%ROWCOUNT;
1069: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||
1070: ' rows into the staging table');
1071: edw_log.put_line(' ');
1072: EDW_ITEMS_M_C.g_row_count:=EDW_ITEMS_M_C.g_row_count+l_rows_inserted;
1073: COMMIT;
1074:
1075: IF l_collect_onetime = 'Y' THEN
1076:

Line 1099: EDW_ITEMS_M_C.g_row_count:=EDW_ITEMS_M_C.g_row_count+l_rows_inserted;

1095: l_rows_inserted := SQL%ROWCOUNT;
1096: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||
1097: ' rows into the staging table');
1098: edw_log.put_line(' ');
1099: EDW_ITEMS_M_C.g_row_count:=EDW_ITEMS_M_C.g_row_count+l_rows_inserted;
1100: COMMIT;
1101:
1102: END IF;
1103:

Line 1541: EDW_ITEMS_M_C.g_row_count:=EDW_ITEMS_M_C.g_row_count+l_rows_inserted;

1537: l_rows_inserted := SQL%ROWCOUNT;
1538: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||
1539: ' rows into the staging table');
1540: edw_log.put_line(' ');
1541: EDW_ITEMS_M_C.g_row_count:=EDW_ITEMS_M_C.g_row_count+l_rows_inserted;
1542: COMMIT;
1543:
1544: IF l_collect_onetime = 'Y' THEN
1545:

Line 1659: EDW_ITEMS_M_C.g_row_count:=EDW_ITEMS_M_C.g_row_count+l_rows_inserted;

1655: l_rows_inserted := SQL%ROWCOUNT;
1656: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||
1657: ' rows into the staging table');
1658: edw_log.put_line(' ');
1659: EDW_ITEMS_M_C.g_row_count:=EDW_ITEMS_M_C.g_row_count+l_rows_inserted;
1660: COMMIT;
1661:
1662: ELSE
1663:

Line 3151: EDW_ITEMS_M_C.g_row_count:=EDW_ITEMS_M_C.g_row_count+l_rows_inserted;

3147:
3148: edw_log.put_line('Inserted '||TO_CHAR(NVL(l_rows_inserted,0))||
3149: ' rows into the lower level staging tables');
3150: edw_log.put_line(' ');
3151: EDW_ITEMS_M_C.g_row_count:=EDW_ITEMS_M_C.g_row_count+l_rows_inserted;
3152:
3153: ELSIF (p_item_item_org=0) THEN
3154:
3155: edw_log.put_line(' ');

Line 3352: EDW_ITEMS_M_C.g_row_count:=EDW_ITEMS_M_C.g_row_count+l_rows_inserted;

3348: edw_log.put_line(' ');
3349: edw_log.put_line('Inserted '||TO_CHAR(NVL(l_rows_inserted,0))||
3350: ' rows into the lower level staging tables');
3351: edw_log.put_line(' ');
3352: EDW_ITEMS_M_C.g_row_count:=EDW_ITEMS_M_C.g_row_count+l_rows_inserted;
3353:
3354: END IF;
3355:
3356: COMMIT;

Line 3896: END EDW_ITEMS_M_C;

3892: edw_log.put_line(' ');
3893:
3894: END Push_EDW_ITEM_PROD_GRP;
3895:
3896: END EDW_ITEMS_M_C;