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_ITEMS_M_C dependencies on EDW_COLLECTION_UTIL

Line 117: IF (Not EDW_COLLECTION_UTIL.setup('EDW_ITEMS_M')) THEN

113:
114: BEGIN
115: Errbuf :=NULL;
116: Retcode:=NULL;
117: IF (Not EDW_COLLECTION_UTIL.setup('EDW_ITEMS_M')) THEN
118: errbuf := fnd_message.get;
119: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
120: END IF;
121:

Line 139: l_push_date_range1:= NVL(l_FROM_date,EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);

135: ELSE
136: l_collect_onetime := 'Y';
137: END IF;
138:
139: l_push_date_range1:= NVL(l_FROM_date,EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
140: l_push_date_range2:= NVL(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
141: edw_log.put_line( 'The collection range is FROM '||
142: TO_CHAR(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
143: TO_CHAR(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));

Line 140: l_push_date_range2:= NVL(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

136: l_collect_onetime := 'Y';
137: END IF;
138:
139: l_push_date_range1:= NVL(l_FROM_date,EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
140: l_push_date_range2:= NVL(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
141: edw_log.put_line( 'The collection range is FROM '||
142: TO_CHAR(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
143: TO_CHAR(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
144: edw_log.put_line(' ');

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 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 411: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');

407: category_assignments_rec category_assignments_cursor%ROWTYPE;
408:
409: BEGIN
410:
411: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
412:
413: l_push_date_range1 := p_from_date;
414: l_push_date_range2 := p_to_date;
415:

Line 1155: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');

1151: category_assignments_rec category_assignments_cursor%ROWTYPE;**/
1152:
1153: BEGIN
1154:
1155: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
1156: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
1157:
1158: l_push_date_range1 := p_from_date;
1159: l_push_date_range2:= p_to_date;

Line 1156: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');

1152:
1153: BEGIN
1154:
1155: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
1156: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
1157:
1158: l_push_date_range1 := p_from_date;
1159: l_push_date_range2:= p_to_date;
1160:

Line 2638: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');

2634: BEGIN
2635:
2636: -- Getting lookup values for Push Down rows
2637:
2638: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');
2639: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
2640: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
2641:
2642: l_push_date_range1:=p_from_date;

Line 2639: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');

2635:
2636: -- Getting lookup values for Push Down rows
2637:
2638: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');
2639: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
2640: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
2641:
2642: l_push_date_range1:=p_from_date;
2643: l_push_date_range2:=p_to_date;

Line 2640: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');

2636: -- Getting lookup values for Push Down rows
2637:
2638: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');
2639: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
2640: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
2641:
2642: l_push_date_range1:=p_from_date;
2643: l_push_date_range2:=p_to_date;
2644:

Line 3397: l_all_prod_cats := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PCAT');

3393: l_all_item_revs VARCHAR2(100);
3394:
3395: BEGIN
3396:
3397: l_all_prod_cats := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PCAT');
3398: l_all_prod_grps := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PGRP');
3399: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');
3400: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
3401: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');

Line 3398: l_all_prod_grps := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PGRP');

3394:
3395: BEGIN
3396:
3397: l_all_prod_cats := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PCAT');
3398: l_all_prod_grps := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PGRP');
3399: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');
3400: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
3401: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
3402:

Line 3399: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');

3395: BEGIN
3396:
3397: l_all_prod_cats := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PCAT');
3398: l_all_prod_grps := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PGRP');
3399: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');
3400: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
3401: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
3402:
3403: edw_log.put_line(' ');

Line 3400: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');

3396:
3397: l_all_prod_cats := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PCAT');
3398: l_all_prod_grps := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PGRP');
3399: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');
3400: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
3401: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
3402:
3403: edw_log.put_line(' ');
3404: edw_log.put_line('Pushing EDW_ITEM_ITEM_PROD_LINE');

Line 3401: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');

3397: l_all_prod_cats := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PCAT');
3398: l_all_prod_grps := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PGRP');
3399: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');
3400: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
3401: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
3402:
3403: edw_log.put_line(' ');
3404: edw_log.put_line('Pushing EDW_ITEM_ITEM_PROD_LINE');
3405:

Line 3588: l_all_prod_grps := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PGRP');

3584: l_all_item_revs VARCHAR2(100);
3585:
3586: BEGIN
3587:
3588: l_all_prod_grps := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PGRP');
3589: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');
3590: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
3591: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
3592:

Line 3589: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');

3585:
3586: BEGIN
3587:
3588: l_all_prod_grps := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PGRP');
3589: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');
3590: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
3591: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
3592:
3593: edw_log.put_line(' ');

Line 3590: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');

3586: BEGIN
3587:
3588: l_all_prod_grps := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PGRP');
3589: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');
3590: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
3591: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
3592:
3593: edw_log.put_line(' ');
3594: edw_log.put_line('Pushing EDW_ITEM_PROD_CATG');

Line 3591: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');

3587:
3588: l_all_prod_grps := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_PGRP');
3589: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');
3590: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
3591: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
3592:
3593: edw_log.put_line(' ');
3594: edw_log.put_line('Pushing EDW_ITEM_PROD_CATG');
3595:

Line 3755: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');

3751: l_all_item_revs VARCHAR2(100);
3752:
3753: BEGIN
3754:
3755: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');
3756: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
3757: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
3758:
3759: edw_log.put_line(' ');

Line 3756: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');

3752:
3753: BEGIN
3754:
3755: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');
3756: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
3757: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
3758:
3759: edw_log.put_line(' ');
3760: edw_log.put_line('Pushing EDW_ITEM_PROD_GRP');

Line 3757: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');

3753: BEGIN
3754:
3755: l_all_items := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_ITEM');
3756: l_all_item_orgs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IORG');
3757: l_all_item_revs := edw_collection_util.get_lookup_value('EDW_LEVEL_PUSH_DOWN', 'EDW_ITEMS_M_IREV');
3758:
3759: edw_log.put_line(' ');
3760: edw_log.put_line('Pushing EDW_ITEM_PROD_GRP');
3761: