APPS.FII_AP_INV_TYPE_M_C dependencies on FII_AP_INV_TYPE_M_C

Line 1: Package Body FII_AP_INV_TYPE_M_C AS

1: Package Body FII_AP_INV_TYPE_M_C AS
2: /* $Header: FIIAP03B.pls 120.4 2004/10/05 19:23:23 phu ship $ */
3: G_PUSH_DATE_RANGE1 Date:=Null;
4: G_PUSH_DATE_RANGE2 Date:=Null;
5: g_row_count Number:=0;

Line 34: FII_AP_INV_TYPE_M_C.g_push_date_range1 := nvl(l_from_date,

30: IF (Not EDW_COLLECTION_UTIL.setup(l_dimension_name)) THEN
31: errbuf := fnd_message.get;
32: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
33: END IF;
34: FII_AP_INV_TYPE_M_C.g_push_date_range1 := nvl(l_from_date,
35: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
36: FII_AP_INV_TYPE_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
37: edw_log.put_line( 'The collection range is from '||
38: to_char(FII_AP_INV_TYPE_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||

Line 36: FII_AP_INV_TYPE_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

32: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
33: END IF;
34: FII_AP_INV_TYPE_M_C.g_push_date_range1 := nvl(l_from_date,
35: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
36: FII_AP_INV_TYPE_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
37: edw_log.put_line( 'The collection range is from '||
38: to_char(FII_AP_INV_TYPE_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
39: to_char(FII_AP_INV_TYPE_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
40: edw_log.put_line(' ');

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

34: FII_AP_INV_TYPE_M_C.g_push_date_range1 := nvl(l_from_date,
35: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
36: FII_AP_INV_TYPE_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
37: edw_log.put_line( 'The collection range is from '||
38: to_char(FII_AP_INV_TYPE_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
39: to_char(FII_AP_INV_TYPE_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
40: edw_log.put_line(' ');
41:
42: -- -----------------------------

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

35: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
36: FII_AP_INV_TYPE_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
37: edw_log.put_line( 'The collection range is from '||
38: to_char(FII_AP_INV_TYPE_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
39: to_char(FII_AP_INV_TYPE_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
40: edw_log.put_line(' ');
41:
42: -- -----------------------------
43: -- Read in profile option value --**Added for Merrill Lynch, 03-DEC-02

Line 57: Push_EDW_IVTY_INV_LSTG(FII_AP_INV_TYPE_M_C.g_push_date_range1, FII_AP_INV_TYPE_M_C.g_push_date_range2);

53:
54: l_temp_date := sysdate;
55:
56:
57: Push_EDW_IVTY_INV_LSTG(FII_AP_INV_TYPE_M_C.g_push_date_range1, FII_AP_INV_TYPE_M_C.g_push_date_range2);
58: Push_EDW_IVTY_INV_TYPE_LSTG(FII_AP_INV_TYPE_M_C.g_push_date_range1, FII_AP_INV_TYPE_M_C.g_push_date_range2);
59:
60:
61: l_duration := sysdate - l_temp_date;

Line 58: Push_EDW_IVTY_INV_TYPE_LSTG(FII_AP_INV_TYPE_M_C.g_push_date_range1, FII_AP_INV_TYPE_M_C.g_push_date_range2);

54: l_temp_date := sysdate;
55:
56:
57: Push_EDW_IVTY_INV_LSTG(FII_AP_INV_TYPE_M_C.g_push_date_range1, FII_AP_INV_TYPE_M_C.g_push_date_range2);
58: Push_EDW_IVTY_INV_TYPE_LSTG(FII_AP_INV_TYPE_M_C.g_push_date_range1, FII_AP_INV_TYPE_M_C.g_push_date_range2);
59:
60:
61: l_duration := sysdate - l_temp_date;
62:

Line 75: FII_AP_INV_TYPE_M_C.g_exception_msg := l_exception_msg;

71: Exception When others then
72: Errbuf:=sqlerrm;
73: Retcode:=sqlcode;
74: l_exception_msg := Retcode || ':' || Errbuf;
75: FII_AP_INV_TYPE_M_C.g_exception_msg := l_exception_msg;
76: rollback;
77: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, FII_AP_INV_TYPE_M_C.g_exception_msg,g_push_date_range1, g_push_date_range2);
78:
79: commit;

Line 77: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, FII_AP_INV_TYPE_M_C.g_exception_msg,g_push_date_range1, g_push_date_range2);

73: Retcode:=sqlcode;
74: l_exception_msg := Retcode || ':' || Errbuf;
75: FII_AP_INV_TYPE_M_C.g_exception_msg := l_exception_msg;
76: rollback;
77: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, FII_AP_INV_TYPE_M_C.g_exception_msg,g_push_date_range1, g_push_date_range2);
78:
79: commit;
80: End;
81:

Line 235: End FII_AP_INV_TYPE_M_C;

231: Exception When others then
232: raise;
233: commit;
234: END;
235: End FII_AP_INV_TYPE_M_C;