APPS.EDW_POA_LN_TYPE_M_C dependencies on EDW_POA_LN_TYPE_M_C

Line 1: Package Body EDW_POA_LN_TYPE_M_C AS

1: Package Body EDW_POA_LN_TYPE_M_C AS
2: /* $Header: poappltb.pls 120.1 2005/06/13 13:15:32 sriswami noship $ */
3:
4: g_row_count Number:= 0;
5: g_exception_message Varchar2(2000) := Null;

Line 39: Edw_POA_LN_TYPE_M_C.Push_LN_TYPE(Errbuf, Retcode, L_push_date_range1,l_push_date_range2);

35: to_char(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
36: to_char(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
37: edw_log.put_line(' ');
38:
39: Edw_POA_LN_TYPE_M_C.Push_LN_TYPE(Errbuf, Retcode, L_push_date_range1,l_push_date_range2);
40:
41:
42: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,
43: P_PERIOD_START => l_push_date_range1,

Line 50: EDW_POA_LN_TYPE_M_C.g_exception_message := EDW_POA_LN_TYPE_M_C.g_exception_message||'<>

46:
47: Exception When others then
48: Errbuf := sqlerrm;
49: Retcode := sqlcode;
50: EDW_POA_LN_TYPE_M_C.g_exception_message := EDW_POA_LN_TYPE_M_C.g_exception_message||'<>
51: '||Retcode || ':' || Errbuf;
52: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_POA_LN_TYPE_M_C.g_exception_message,
53: l_push_date_range1, l_push_date_range2);
54: rollback;

Line 52: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_POA_LN_TYPE_M_C.g_exception_message,

48: Errbuf := sqlerrm;
49: Retcode := sqlcode;
50: EDW_POA_LN_TYPE_M_C.g_exception_message := EDW_POA_LN_TYPE_M_C.g_exception_message||'<>
51: '||Retcode || ':' || Errbuf;
52: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_POA_LN_TYPE_M_C.g_exception_message,
53: l_push_date_range1, l_push_date_range2);
54: rollback;
55: raise;
56:

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

144:
145: -- ---------------------------------------------------------------------------
146: -- END OF Collection , Developer Customizable Section
147: -- ---------------------------------------------------------------------------
148: EDW_POA_LN_TYPE_M_C.g_row_count :=EDW_POA_LN_TYPE_M_C.g_row_count +l_rows_inserted;
149:
150: Exception When others then
151: Errbuf := sqlerrm;
152: Retcode := sqlcode;

Line 153: EDW_POA_LN_TYPE_M_C.g_exception_message := Retcode || ':' || Errbuf;

149:
150: Exception When others then
151: Errbuf := sqlerrm;
152: Retcode := sqlcode;
153: EDW_POA_LN_TYPE_M_C.g_exception_message := Retcode || ':' || Errbuf;
154: rollback;
155:
156: raise;
157:

Line 160: End EDW_POA_LN_TYPE_M_C;

156: raise;
157:
158: End Push_ln_type;
159:
160: End EDW_POA_LN_TYPE_M_C;