DBA Data[Home] [Help]

APPS.EDW_BOM_RES_M_C dependencies on EDW_BOM_RES_M_C

Line 1: Package Body EDW_BOM_RES_M_C AS

1: Package Body EDW_BOM_RES_M_C AS
2: /* $Header: ENICRESB.pls 115.4 2004/01/30 20:33:58 sbag noship $ */
3: l_push_date_range1 DATE := NULL;
4: l_push_date_range2 DATE := NULL;
5: g_row_count NUMBER := 0;

Line 50: EDW_COLLECTION_UTIL.wrapup(TRUE, EDW_BOM_RES_M_C.g_row_count, null, l_push_date_range1, l_push_date_range2);

46: Push_EDW_BRES_PARENT_DEPT(l_push_date_range1, l_push_date_range2);
47: Push_EDW_BRES_DEPT(l_push_date_range1, l_push_date_range2);
48: Push_EDW_BRES_DEPT_CLASS(l_push_date_range1, l_push_date_range2);
49:
50: EDW_COLLECTION_UTIL.wrapup(TRUE, EDW_BOM_RES_M_C.g_row_count, null, l_push_date_range1, l_push_date_range2);
51: commit;
52:
53: Exception When others then
54: Errbuf := sqlerrm;

Line 56: EDW_BOM_RES_M_C.g_exception_message := EDW_BOM_RES_M_C.g_exception_message||' <> '||Retcode||' : '||Errbuf;

52:
53: Exception When others then
54: Errbuf := sqlerrm;
55: Retcode := sqlcode;
56: EDW_BOM_RES_M_C.g_exception_message := EDW_BOM_RES_M_C.g_exception_message||' <> '||Retcode||' : '||Errbuf;
57: Rollback;
58: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_BOM_RES_M_C.g_exception_message,l_push_date_range1, l_push_date_range2);
59: commit;
60:

Line 58: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_BOM_RES_M_C.g_exception_message,l_push_date_range1, l_push_date_range2);

54: Errbuf := sqlerrm;
55: Retcode := sqlcode;
56: EDW_BOM_RES_M_C.g_exception_message := EDW_BOM_RES_M_C.g_exception_message||' <> '||Retcode||' : '||Errbuf;
57: Rollback;
58: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_BOM_RES_M_C.g_exception_message,l_push_date_range1, l_push_date_range2);
59: commit;
60:
61: End Push;
62:

Line 143: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

139: -- ---------------------------------------------------------------------------
140: -- END OF Collection , Developer Customizable Section
141: -- ---------------------------------------------------------------------------
142:
143: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;
144: Commit;
145:
146: Exception When others then
147: raise;

Line 232: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

228: -- ---------------------------------------------------------------------------
229: -- END OF Collection , Developer Customizable Section
230: -- ---------------------------------------------------------------------------
231:
232: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;
233: Commit;
234:
235: Exception When others then
236: raise;

Line 335: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

331: -- ---------------------------------------------------------------------------
332: -- END OF Collection , Developer Customizable Section
333: -- ---------------------------------------------------------------------------
334:
335: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;
336: Commit;
337:
338: Exception When others then
339: raise;

Line 419: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

415: -- ---------------------------------------------------------------------------
416: -- END OF Collection , Developer Customizable Section
417: -- ---------------------------------------------------------------------------
418:
419: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;
420: Commit;
421:
422: Exception When others then
423: raise;

Line 504: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

500: -- ---------------------------------------------------------------------------
501: -- END OF Collection , Developer Customizable Section
502: -- ---------------------------------------------------------------------------
503:
504: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;
505: Commit;
506:
507: /***************************************************/
508:

Line 594: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

590: -- ---------------------------------------------------------------------------
591: -- END OF Collection , Developer Customizable Section
592: -- ---------------------------------------------------------------------------
593:
594: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;
595: Commit;
596:
597: Exception When others then
598: raise;

Line 679: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

675: -- ---------------------------------------------------------------------------
676: -- END OF Collection , Developer Customizable Section
677: -- ---------------------------------------------------------------------------
678:
679: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;
680: Commit;
681:
682: /***************************************************/
683:

Line 766: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

762: -- ---------------------------------------------------------------------------
763: -- END OF Collection , Developer Customizable Section
764: -- ---------------------------------------------------------------------------
765:
766: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;
767: Commit;
768:
769: Exception When others then
770: raise;

Line 853: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

849: -- ---------------------------------------------------------------------------
850: -- END OF Collection , Developer Customizable Section
851: -- ---------------------------------------------------------------------------
852:
853: EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;
854: Commit;
855:
856: Exception When others then
857: raise;

Line 862: End EDW_BOM_RES_M_C;

858: commit;
859:
860: End Push_EDW_BRES_DEPT_CLASS;
861:
862: End EDW_BOM_RES_M_C;