APPS.OPI_EDW_UOM_CONV_F_C dependencies on OPI_EDW_UOM_CONV_F_C

Line 1: Package Body OPI_EDW_UOM_CONV_F_C AS

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

Line 36: OPI_EDW_UOM_CONV_F_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -

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

Line 39: OPI_EDW_UOM_CONV_F_C.g_push_date_range1 := to_date(p_from_date,

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

Line 44: OPI_EDW_UOM_CONV_F_C.g_push_date_range2 :=

40: 'YYYY/MM/DD HH24:MI:SS');
41: END IF;
42:
43: IF (p_to_date IS NULL) THEN
44: OPI_EDW_UOM_CONV_F_C.g_push_date_range2 :=
45: EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
46: ELSE
47: IF to_char(to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD') =
48: to_char(sysdate,'YYYY/MM/DD') THEN

Line 49: OPI_EDW_UOM_CONV_F_C.g_push_date_range2 := to_date(to_char(sysdate,

45: EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
46: ELSE
47: IF to_char(to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD') =
48: to_char(sysdate,'YYYY/MM/DD') THEN
49: OPI_EDW_UOM_CONV_F_C.g_push_date_range2 := to_date(to_char(sysdate,
50: 'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS');
51: ELSE
52: l_temp_date_char := to_char(to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS'),
53: 'YYYY/MM/DD');

Line 54: OPI_EDW_UOM_CONV_F_C.g_push_date_range2 := to_date(l_temp_date_char||

50: 'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS');
51: ELSE
52: l_temp_date_char := to_char(to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS'),
53: 'YYYY/MM/DD');
54: OPI_EDW_UOM_CONV_F_C.g_push_date_range2 := to_date(l_temp_date_char||
55: ' 23:59:59', 'YYYY/MM/DD HH24:MI:SS');
56: END IF;
57: END IF ;
58:

Line 166: OPI_EDW_UOM_CONV_F_C.g_push_date_range1,

162: -- ---------------------------------------------------------------------------
163: -- END OF Collection , Developer Customizable Section
164: -- ---------------------------------------------------------------------------
165: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,
166: OPI_EDW_UOM_CONV_F_C.g_push_date_range1,
167: OPI_EDW_UOM_CONV_F_C.g_push_date_range2);
168:
169: Exception When others then
170: Errbuf:=sqlerrm;

Line 167: OPI_EDW_UOM_CONV_F_C.g_push_date_range2);

163: -- END OF Collection , Developer Customizable Section
164: -- ---------------------------------------------------------------------------
165: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,
166: OPI_EDW_UOM_CONV_F_C.g_push_date_range1,
167: OPI_EDW_UOM_CONV_F_C.g_push_date_range2);
168:
169: Exception When others then
170: Errbuf:=sqlerrm;
171: Retcode:=sqlcode;

Line 175: OPI_EDW_UOM_CONV_F_C.g_push_date_range1,

171: Retcode:=sqlcode;
172: l_exception_msg := Retcode || ':' || Errbuf;
173: rollback;
174: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
175: OPI_EDW_UOM_CONV_F_C.g_push_date_range1,
176: OPI_EDW_UOM_CONV_F_C.g_push_date_range2);
177: raise;
178:
179: End;

Line 176: OPI_EDW_UOM_CONV_F_C.g_push_date_range2);

172: l_exception_msg := Retcode || ':' || Errbuf;
173: rollback;
174: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
175: OPI_EDW_UOM_CONV_F_C.g_push_date_range1,
176: OPI_EDW_UOM_CONV_F_C.g_push_date_range2);
177: raise;
178:
179: End;
180: End OPI_EDW_UOM_CONV_F_C;

Line 180: End OPI_EDW_UOM_CONV_F_C;

176: OPI_EDW_UOM_CONV_F_C.g_push_date_range2);
177: raise;
178:
179: End;
180: End OPI_EDW_UOM_CONV_F_C;