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_LOT_M_C dependencies on EDW_OPI_LOT_M_C

Line 1: Package Body EDW_OPI_LOT_M_C AS

1: Package Body EDW_OPI_LOT_M_C AS
2: /* $Header: OPIPLTDB.pls 120.2 2005/06/07 03:44:23 appldev $ */
3: G_PUSH_DATE_RANGE1 Date:=Null;
4: G_PUSH_DATE_RANGE2 Date:=Null;
5: g_row_count Number:=0;

Line 32: EDW_OPI_LOT_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -

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

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

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

Line 39: EDW_OPI_LOT_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

35: EDW_OPI_LOT_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
36: END IF;
37:
38: IF (p_to_date IS NULL) THEN
39: EDW_OPI_LOT_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
40: ELSE
41: EDW_OPI_LOT_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
42: END IF;
43:

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

37:
38: IF (p_to_date IS NULL) THEN
39: EDW_OPI_LOT_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
40: ELSE
41: EDW_OPI_LOT_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
42: END IF;
43:
44:
45: edw_log.put_line( 'The collection range is from '||

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

42: END IF;
43:
44:
45: edw_log.put_line( 'The collection range is from '||
46: to_char(EDW_OPI_LOT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
47: to_char(EDW_OPI_LOT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
48: edw_log.put_line(' ');
49:
50: -- -----------------------------------------------------------------------------

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

43:
44:
45: edw_log.put_line( 'The collection range is from '||
46: to_char(EDW_OPI_LOT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
47: to_char(EDW_OPI_LOT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
48: edw_log.put_line(' ');
49:
50: -- -----------------------------------------------------------------------------
51: -- Start of Collection , Developer Customizable Section

Line 60: Push_EDW_OPI_LOTD_LOT_LSTG(EDW_OPI_LOT_M_C.g_push_date_range1, EDW_OPI_LOT_M_C.g_push_date_range2);

56:
57: l_temp_date := sysdate;
58:
59:
60: Push_EDW_OPI_LOTD_LOT_LSTG(EDW_OPI_LOT_M_C.g_push_date_range1, EDW_OPI_LOT_M_C.g_push_date_range2);
61:
62:
63: l_duration := sysdate - l_temp_date;
64:

Line 71: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,EDW_OPI_LOT_M_C.g_exception_msg,

67: edw_log.put_line(' ');
68: -- ---------------------------------------------------------------------------
69: -- END OF Collection , Developer Customizable Section
70: -- ---------------------------------------------------------------------------
71: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,EDW_OPI_LOT_M_C.g_exception_msg,
72: EDW_OPI_LOT_M_C.g_push_date_range1,
73: EDW_OPI_LOT_M_C.g_push_date_range2);
74: commit;
75:

Line 72: EDW_OPI_LOT_M_C.g_push_date_range1,

68: -- ---------------------------------------------------------------------------
69: -- END OF Collection , Developer Customizable Section
70: -- ---------------------------------------------------------------------------
71: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,EDW_OPI_LOT_M_C.g_exception_msg,
72: EDW_OPI_LOT_M_C.g_push_date_range1,
73: EDW_OPI_LOT_M_C.g_push_date_range2);
74: commit;
75:
76: Exception When others then

Line 73: EDW_OPI_LOT_M_C.g_push_date_range2);

69: -- END OF Collection , Developer Customizable Section
70: -- ---------------------------------------------------------------------------
71: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,EDW_OPI_LOT_M_C.g_exception_msg,
72: EDW_OPI_LOT_M_C.g_push_date_range1,
73: EDW_OPI_LOT_M_C.g_push_date_range2);
74: commit;
75:
76: Exception When others then
77: Errbuf:=sqlerrm;

Line 80: EDW_OPI_LOT_M_C.g_exception_msg := l_exception_msg;

76: Exception When others then
77: Errbuf:=sqlerrm;
78: Retcode:=sqlcode;
79: l_exception_msg := Retcode || ':' || Errbuf;
80: EDW_OPI_LOT_M_C.g_exception_msg := l_exception_msg;
81: rollback;
82: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_LOT_M_C.g_exception_msg,
83: EDW_OPI_LOT_M_C.g_push_date_range1,
84: EDW_OPI_LOT_M_C.g_push_date_range2);

Line 82: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_LOT_M_C.g_exception_msg,

78: Retcode:=sqlcode;
79: l_exception_msg := Retcode || ':' || Errbuf;
80: EDW_OPI_LOT_M_C.g_exception_msg := l_exception_msg;
81: rollback;
82: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_LOT_M_C.g_exception_msg,
83: EDW_OPI_LOT_M_C.g_push_date_range1,
84: EDW_OPI_LOT_M_C.g_push_date_range2);
85: commit;
86: End;

Line 83: EDW_OPI_LOT_M_C.g_push_date_range1,

79: l_exception_msg := Retcode || ':' || Errbuf;
80: EDW_OPI_LOT_M_C.g_exception_msg := l_exception_msg;
81: rollback;
82: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_LOT_M_C.g_exception_msg,
83: EDW_OPI_LOT_M_C.g_push_date_range1,
84: EDW_OPI_LOT_M_C.g_push_date_range2);
85: commit;
86: End;
87:

Line 84: EDW_OPI_LOT_M_C.g_push_date_range2);

80: EDW_OPI_LOT_M_C.g_exception_msg := l_exception_msg;
81: rollback;
82: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_LOT_M_C.g_exception_msg,
83: EDW_OPI_LOT_M_C.g_push_date_range1,
84: EDW_OPI_LOT_M_C.g_push_date_range2);
85: commit;
86: End;
87:
88:

Line 148: EDW_OPI_LOT_M_C.g_row_count := EDW_OPI_LOT_M_C.g_row_count + l_rows_inserted ;

144: where last_update_date between l_date1 and l_date2;
145:
146:
147: l_rows_inserted := sql%rowcount;
148: EDW_OPI_LOT_M_C.g_row_count := EDW_OPI_LOT_M_C.g_row_count + l_rows_inserted ;
149: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
150: ' rows into the staging table');
151: edw_log.put_line('Commiting records for EDW_OPI_LOTD_LOT_LSTG');
152: commit;

Line 159: End EDW_OPI_LOT_M_C;

155: Exception When others then
156: raise;
157: commit;
158: END;
159: End EDW_OPI_LOT_M_C;