APPS.EDW_POA_SPLRITEM_M_C dependencies on EDW_POA_SPLRITEM_M_C

Line 1: Package Body EDW_POA_SPLRITEM_M_C AS

1: Package Body EDW_POA_SPLRITEM_M_C AS
2: /* $Header: poaphsib.pls 120.1 2005/06/13 13:10:11 sriswami noship $ */
3: G_PUSH_DATE_RANGE1 Date:=Null;
4: G_PUSH_DATE_RANGE2 Date:=Null;
5: g_row_count Number:=0;

Line 59: Push_POA_SPIM_SPLRITEM_LSTG(EDW_POA_SPLRITEM_M_C.g_push_date_range1, EDW_POA_SPLRITEM_M_C.g_push_date_range2);

55:
56: l_temp_date := sysdate;
57:
58:
59: Push_POA_SPIM_SPLRITEM_LSTG(EDW_POA_SPLRITEM_M_C.g_push_date_range1, EDW_POA_SPLRITEM_M_C.g_push_date_range2);
60:
61:
62: l_duration := sysdate - l_temp_date;
63:

Line 78: EDW_POA_SPLRITEM_M_C.g_exception_msg := l_exception_msg;

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

Line 80: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_POA_SPLRITEM_M_C.g_exception_msg,

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

Line 135: EDW_POA_SPLRITEM_M_C.g_row_count := EDW_POA_SPLRITEM_M_C.g_row_count + l_rows_inserted ;

131: where last_update_date between l_date1 and l_date2
132: OR last_update_date is NULL;
133:
134: l_rows_inserted := sql%rowcount;
135: EDW_POA_SPLRITEM_M_C.g_row_count := EDW_POA_SPLRITEM_M_C.g_row_count + l_rows_inserted ;
136:
137: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
138: ' rows into the staging table');
139:

Line 146: End EDW_POA_SPLRITEM_M_C;

142: Exception When others then
143: rollback;
144: raise;
145: END;
146: End EDW_POA_SPLRITEM_M_C;