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_PRDL_M_C dependencies on EDW_OPI_PRDL_M_C

Line 1: Package Body EDW_OPI_PRDL_M_C AS

1: Package Body EDW_OPI_PRDL_M_C AS
2: /* $Header: OPIPPLDB.pls 120.1 2005/06/07 02:46:16 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_PRDL_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_PRDL_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_PRDL_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
36: END IF;

Line 35: EDW_OPI_PRDL_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_PRDL_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_PRDL_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_PRDL_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

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

35: EDW_OPI_PRDL_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_PRDL_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
40: ELSE
41: /* Bug 2333020
42: IF to_char(to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD') = to_char(sysdate,'YYYY/MM/DD') THEN
43: EDW_OPI_PRDL_M_C.g_push_date_range2 := to_date(to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS');

Line 43: EDW_OPI_PRDL_M_C.g_push_date_range2 := to_date(to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS');

39: EDW_OPI_PRDL_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
40: ELSE
41: /* Bug 2333020
42: IF to_char(to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD') = to_char(sysdate,'YYYY/MM/DD') THEN
43: EDW_OPI_PRDL_M_C.g_push_date_range2 := to_date(to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS');
44: ELSE
45: l_temp_date_char := to_char(to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD');
46: EDW_OPI_PRDL_M_C.g_push_date_range2 := to_date(l_temp_date_char||' 23:59:59', 'YYYY/MM/DD HH24:MI:SS');
47: END IF;

Line 46: EDW_OPI_PRDL_M_C.g_push_date_range2 := to_date(l_temp_date_char||' 23:59:59', 'YYYY/MM/DD HH24:MI:SS');

42: IF to_char(to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD') = to_char(sysdate,'YYYY/MM/DD') THEN
43: EDW_OPI_PRDL_M_C.g_push_date_range2 := to_date(to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS');
44: ELSE
45: l_temp_date_char := to_char(to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD');
46: EDW_OPI_PRDL_M_C.g_push_date_range2 := to_date(l_temp_date_char||' 23:59:59', 'YYYY/MM/DD HH24:MI:SS');
47: END IF;
48: */
49: EDW_OPI_PRDL_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
50: END IF;

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

45: l_temp_date_char := to_char(to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD');
46: EDW_OPI_PRDL_M_C.g_push_date_range2 := to_date(l_temp_date_char||' 23:59:59', 'YYYY/MM/DD HH24:MI:SS');
47: END IF;
48: */
49: EDW_OPI_PRDL_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
50: END IF;
51:
52:
53: edw_log.put_line( 'The collection range is from '||

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

50: END IF;
51:
52:
53: edw_log.put_line( 'The collection range is from '||
54: to_char(EDW_OPI_PRDL_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
55: to_char(EDW_OPI_PRDL_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
56: edw_log.put_line(' ');
57:
58: -- -----------------------------------------------------------------------------

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

51:
52:
53: edw_log.put_line( 'The collection range is from '||
54: to_char(EDW_OPI_PRDL_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
55: to_char(EDW_OPI_PRDL_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
56: edw_log.put_line(' ');
57:
58: -- -----------------------------------------------------------------------------
59: -- Start of Collection , Developer Customizable Section

Line 68: Push_EDW_OPI_PRDL_PRDL_LSTG(EDW_OPI_PRDL_M_C.g_push_date_range1, EDW_OPI_PRDL_M_C.g_push_date_range2);

64:
65: l_temp_date := sysdate;
66:
67:
68: Push_EDW_OPI_PRDL_PRDL_LSTG(EDW_OPI_PRDL_M_C.g_push_date_range1, EDW_OPI_PRDL_M_C.g_push_date_range2);
69:
70:
71: l_duration := sysdate - l_temp_date;
72:

Line 80: EDW_OPI_PRDL_M_C.g_exception_msg,

76: -- ---------------------------------------------------------------------------
77: -- END OF Collection , Developer Customizable Section
78: -- ---------------------------------------------------------------------------
79: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,
80: EDW_OPI_PRDL_M_C.g_exception_msg,
81: EDW_OPI_PRDL_M_C.g_push_date_range1,
82: EDW_OPI_PRDL_M_C.g_push_date_range2);
83: commit;
84:

Line 81: EDW_OPI_PRDL_M_C.g_push_date_range1,

77: -- END OF Collection , Developer Customizable Section
78: -- ---------------------------------------------------------------------------
79: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,
80: EDW_OPI_PRDL_M_C.g_exception_msg,
81: EDW_OPI_PRDL_M_C.g_push_date_range1,
82: EDW_OPI_PRDL_M_C.g_push_date_range2);
83: commit;
84:
85: Exception When others then

Line 82: EDW_OPI_PRDL_M_C.g_push_date_range2);

78: -- ---------------------------------------------------------------------------
79: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,
80: EDW_OPI_PRDL_M_C.g_exception_msg,
81: EDW_OPI_PRDL_M_C.g_push_date_range1,
82: EDW_OPI_PRDL_M_C.g_push_date_range2);
83: commit;
84:
85: Exception When others then
86: Errbuf:=sqlerrm;

Line 89: EDW_OPI_PRDL_M_C.g_exception_msg := l_exception_msg;

85: Exception When others then
86: Errbuf:=sqlerrm;
87: Retcode:=sqlcode;
88: l_exception_msg := Retcode || ':' || Errbuf;
89: EDW_OPI_PRDL_M_C.g_exception_msg := l_exception_msg;
90: rollback;
91: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_PRDL_M_C.g_exception_msg,
92: EDW_OPI_PRDL_M_C.g_push_date_range1,
93: EDW_OPI_PRDL_M_C.g_push_date_range2);

Line 91: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_PRDL_M_C.g_exception_msg,

87: Retcode:=sqlcode;
88: l_exception_msg := Retcode || ':' || Errbuf;
89: EDW_OPI_PRDL_M_C.g_exception_msg := l_exception_msg;
90: rollback;
91: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_PRDL_M_C.g_exception_msg,
92: EDW_OPI_PRDL_M_C.g_push_date_range1,
93: EDW_OPI_PRDL_M_C.g_push_date_range2);
94:
95: commit;

Line 92: EDW_OPI_PRDL_M_C.g_push_date_range1,

88: l_exception_msg := Retcode || ':' || Errbuf;
89: EDW_OPI_PRDL_M_C.g_exception_msg := l_exception_msg;
90: rollback;
91: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_PRDL_M_C.g_exception_msg,
92: EDW_OPI_PRDL_M_C.g_push_date_range1,
93: EDW_OPI_PRDL_M_C.g_push_date_range2);
94:
95: commit;
96: End;

Line 93: EDW_OPI_PRDL_M_C.g_push_date_range2);

89: EDW_OPI_PRDL_M_C.g_exception_msg := l_exception_msg;
90: rollback;
91: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_PRDL_M_C.g_exception_msg,
92: EDW_OPI_PRDL_M_C.g_push_date_range1,
93: EDW_OPI_PRDL_M_C.g_push_date_range2);
94:
95: commit;
96: End;
97:

Line 146: EDW_OPI_PRDL_M_C.g_row_count := EDW_OPI_PRDL_M_C.g_row_count + l_rows_inserted ;

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

Line 157: End EDW_OPI_PRDL_M_C;

153: Exception When others then
154: raise;
155: commit;
156: END;
157: End EDW_OPI_PRDL_M_C;