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_OPI_OPRN_M_C dependencies on EDW_OPI_OPRN_M_C

Line 1: Package Body EDW_OPI_OPRN_M_C AS

1: Package Body EDW_OPI_OPRN_M_C AS
2: /* $Header: OPIOPRDB.pls 120.1 2005/06/07 02:26:54 appldev $ */
3: G_PUSH_DATE_RANGE1 Date:=Null;
4: G_PUSH_DATE_RANGE2 Date:=Null;
5: g_row_count Number:=0;

Line 29: EDW_OPI_OPRN_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -

25: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
26: Return;
27: END IF;
28: IF (p_from_date IS NULL) THEN
29: EDW_OPI_OPRN_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -
30: EDW_COLLECTION_UTIL.g_offset;
31: ELSE
32: EDW_OPI_OPRN_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
33: END IF;

Line 32: EDW_OPI_OPRN_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');

28: IF (p_from_date IS NULL) THEN
29: EDW_OPI_OPRN_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -
30: EDW_COLLECTION_UTIL.g_offset;
31: ELSE
32: EDW_OPI_OPRN_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
33: END IF;
34: IF (p_to_date IS NULL) THEN
35: EDW_OPI_OPRN_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
36: ELSE

Line 35: EDW_OPI_OPRN_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

31: ELSE
32: EDW_OPI_OPRN_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
33: END IF;
34: IF (p_to_date IS NULL) THEN
35: EDW_OPI_OPRN_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
36: ELSE
37: EDW_OPI_OPRN_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
38: END IF;
39: edw_log.put_line( 'The collection range is from '||

Line 37: EDW_OPI_OPRN_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');

33: END IF;
34: IF (p_to_date IS NULL) THEN
35: EDW_OPI_OPRN_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
36: ELSE
37: EDW_OPI_OPRN_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
38: END IF;
39: edw_log.put_line( 'The collection range is from '||
40: to_char(EDW_OPI_OPRN_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
41: to_char(EDW_OPI_OPRN_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));

Line 40: to_char(EDW_OPI_OPRN_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||

36: ELSE
37: EDW_OPI_OPRN_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
38: END IF;
39: edw_log.put_line( 'The collection range is from '||
40: to_char(EDW_OPI_OPRN_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
41: to_char(EDW_OPI_OPRN_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
42: edw_log.put_line(' ');
43: -- -----------------------------------------------------------------------------
44: -- Start of Collection , Developer Customizable Section

Line 41: to_char(EDW_OPI_OPRN_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));

37: EDW_OPI_OPRN_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
38: END IF;
39: edw_log.put_line( 'The collection range is from '||
40: to_char(EDW_OPI_OPRN_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
41: to_char(EDW_OPI_OPRN_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
42: edw_log.put_line(' ');
43: -- -----------------------------------------------------------------------------
44: -- Start of Collection , Developer Customizable Section
45: -- -----------------------------------------------------------------------------

Line 49: Push_EDW_OPI_OPRN_OPRN_LSTG(EDW_OPI_OPRN_M_C.g_push_date_range1, EDW_OPI_OPRN_M_C.g_push_date_range2);

45: -- -----------------------------------------------------------------------------
46: edw_log.put_line(' ');
47: edw_log.put_line('Pushing data');
48: l_temp_date := sysdate;
49: Push_EDW_OPI_OPRN_OPRN_LSTG(EDW_OPI_OPRN_M_C.g_push_date_range1, EDW_OPI_OPRN_M_C.g_push_date_range2);
50: Push_EDW_OPI_OPRN_OPRC_LSTG(EDW_OPI_OPRN_M_C.g_push_date_range1, EDW_OPI_OPRN_M_C.g_push_date_range2);
51: l_duration := sysdate - l_temp_date;
52: edw_log.put_line('Total rows inserted : '||g_row_count);
53: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));

Line 50: Push_EDW_OPI_OPRN_OPRC_LSTG(EDW_OPI_OPRN_M_C.g_push_date_range1, EDW_OPI_OPRN_M_C.g_push_date_range2);

46: edw_log.put_line(' ');
47: edw_log.put_line('Pushing data');
48: l_temp_date := sysdate;
49: Push_EDW_OPI_OPRN_OPRN_LSTG(EDW_OPI_OPRN_M_C.g_push_date_range1, EDW_OPI_OPRN_M_C.g_push_date_range2);
50: Push_EDW_OPI_OPRN_OPRC_LSTG(EDW_OPI_OPRN_M_C.g_push_date_range1, EDW_OPI_OPRN_M_C.g_push_date_range2);
51: l_duration := sysdate - l_temp_date;
52: edw_log.put_line('Total rows inserted : '||g_row_count);
53: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
54: edw_log.put_line(' ');

Line 58: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,EDW_OPI_OPRN_M_C.g_exception_msg,

54: edw_log.put_line(' ');
55: -- ---------------------------------------------------------------------------
56: -- END OF Collection , Developer Customizable Section
57: -- ---------------------------------------------------------------------------
58: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,EDW_OPI_OPRN_M_C.g_exception_msg,
59: EDW_OPI_OPRN_M_C.g_push_date_range1,
60: EDW_OPI_OPRN_M_C.g_push_date_range2);
61: commit;
62: Exception When others then

Line 59: EDW_OPI_OPRN_M_C.g_push_date_range1,

55: -- ---------------------------------------------------------------------------
56: -- END OF Collection , Developer Customizable Section
57: -- ---------------------------------------------------------------------------
58: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,EDW_OPI_OPRN_M_C.g_exception_msg,
59: EDW_OPI_OPRN_M_C.g_push_date_range1,
60: EDW_OPI_OPRN_M_C.g_push_date_range2);
61: commit;
62: Exception When others then
63: Errbuf:=sqlerrm;

Line 60: EDW_OPI_OPRN_M_C.g_push_date_range2);

56: -- END OF Collection , Developer Customizable Section
57: -- ---------------------------------------------------------------------------
58: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,EDW_OPI_OPRN_M_C.g_exception_msg,
59: EDW_OPI_OPRN_M_C.g_push_date_range1,
60: EDW_OPI_OPRN_M_C.g_push_date_range2);
61: commit;
62: Exception When others then
63: Errbuf:=sqlerrm;
64: Retcode:=sqlcode;

Line 66: EDW_OPI_OPRN_M_C.g_exception_msg := l_exception_msg;

62: Exception When others then
63: Errbuf:=sqlerrm;
64: Retcode:=sqlcode;
65: l_exception_msg := Retcode || ':' || Errbuf;
66: EDW_OPI_OPRN_M_C.g_exception_msg := l_exception_msg;
67: rollback;
68: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_OPRN_M_C.g_exception_msg,
69: EDW_OPI_OPRN_M_C.g_push_date_range1,
70: EDW_OPI_OPRN_M_C.g_push_date_range2);

Line 68: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_OPRN_M_C.g_exception_msg,

64: Retcode:=sqlcode;
65: l_exception_msg := Retcode || ':' || Errbuf;
66: EDW_OPI_OPRN_M_C.g_exception_msg := l_exception_msg;
67: rollback;
68: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_OPRN_M_C.g_exception_msg,
69: EDW_OPI_OPRN_M_C.g_push_date_range1,
70: EDW_OPI_OPRN_M_C.g_push_date_range2);
71: commit;
72: End;

Line 69: EDW_OPI_OPRN_M_C.g_push_date_range1,

65: l_exception_msg := Retcode || ':' || Errbuf;
66: EDW_OPI_OPRN_M_C.g_exception_msg := l_exception_msg;
67: rollback;
68: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_OPRN_M_C.g_exception_msg,
69: EDW_OPI_OPRN_M_C.g_push_date_range1,
70: EDW_OPI_OPRN_M_C.g_push_date_range2);
71: commit;
72: End;
73:

Line 70: EDW_OPI_OPRN_M_C.g_push_date_range2);

66: EDW_OPI_OPRN_M_C.g_exception_msg := l_exception_msg;
67: rollback;
68: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_OPRN_M_C.g_exception_msg,
69: EDW_OPI_OPRN_M_C.g_push_date_range1,
70: EDW_OPI_OPRN_M_C.g_push_date_range2);
71: commit;
72: End;
73:
74: Procedure Push_EDW_OPI_OPRN_OPRN_LSTG(p_from_date IN date, p_to_date IN DATE) IS

Line 124: EDW_OPI_OPRN_M_C.g_row_count := EDW_OPI_OPRN_M_C.g_row_count + l_rows_inserted ;

120: 'READY'
121: from EDW_OPI_OPRN_OPRN_LCV@APPS_TO_APPS
122: where last_update_date between l_date1 and l_date2;
123: l_rows_inserted := sql%rowcount;
124: EDW_OPI_OPRN_M_C.g_row_count := EDW_OPI_OPRN_M_C.g_row_count + l_rows_inserted ;
125: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
126: ' rows into the staging table');
127: edw_log.put_line('Commiting records into EDW_OPI_OPRN_OPRN_LSTG');
128: commit;

Line 177: EDW_OPI_OPRN_M_C.g_row_count := EDW_OPI_OPRN_M_C.g_row_count + l_rows_inserted ;

173: 'READY'
174: from EDW_OPI_OPRN_OPRC_LCV@APPS_TO_APPS
175: where last_update_date between l_date1 and l_date2;
176: l_rows_inserted := sql%rowcount;
177: EDW_OPI_OPRN_M_C.g_row_count := EDW_OPI_OPRN_M_C.g_row_count + l_rows_inserted ;
178: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
179: ' rows into the staging table');
180: edw_log.put_line('Commiting records into EDW_OPI_OPRN_OPRC_LSTG');
181: commit;

Line 188: End EDW_OPI_OPRN_M_C;

184: raise;
185: commit;
186: END;
187:
188: End EDW_OPI_OPRN_M_C;