DBA Data[Home] [Help]

APPS.FII_PA_BUDGET_M_C dependencies on FII_PA_PABU_BUDGET_LSTG

Line 64: Push_FII_PA_PABU_BUDGET_LSTG(FII_PA_BUDGET_M_C.g_push_date_range1, FII_PA_BUDGET_M_C.g_push_date_range2);

60:
61: l_temp_date := sysdate;
62:
63:
64: Push_FII_PA_PABU_BUDGET_LSTG(FII_PA_BUDGET_M_C.g_push_date_range1, FII_PA_BUDGET_M_C.g_push_date_range2);
65:
66:
67: l_duration := sysdate - l_temp_date;
68:

Line 92: Procedure Push_FII_PA_PABU_BUDGET_LSTG(p_from_date IN date, p_to_date IN DATE) IS

88: commit;
89: End;
90:
91:
92: Procedure Push_FII_PA_PABU_BUDGET_LSTG(p_from_date IN date, p_to_date IN DATE) IS
93: l_date1 DATE;
94: l_date2 DATE;
95: l_rows_inserted NUMBER :=0;
96: BEGIN

Line 99: edw_log.put_line('Starting Push_FII_PA_PABU_BUDGET_LSTG');

95: l_rows_inserted NUMBER :=0;
96: BEGIN
97:
98: if g_debug_flag = 'Y' then
99: edw_log.put_line('Starting Push_FII_PA_PABU_BUDGET_LSTG');
100: end if;
101:
102: l_date1 := p_from_date;
103: l_date2 := p_to_date;

Line 106: FII_PA_PABU_BUDGET_LSTG(

102: l_date1 := p_from_date;
103: l_date2 := p_to_date;
104:
105: Insert Into
106: FII_PA_PABU_BUDGET_LSTG(
107: USER_ATTRIBUTE3,
108: USER_ATTRIBUTE4,
109: USER_ATTRIBUTE5,
110: INSTANCE,

Line 153: edw_log.put_line('Commiting records for FII_PA_PABU_BUDGET_LSTG');

149: l_rows_inserted := sql%rowcount;
150: g_row_count := g_row_count + l_rows_inserted ;
151:
152: if g_debug_flag = 'Y' then
153: edw_log.put_line('Commiting records for FII_PA_PABU_BUDGET_LSTG');
154: end if;
155:
156: commit;
157:

Line 159: edw_log.put_line('Completed Push_FII_PA_PABU_BUDGET_LSTG');

155:
156: commit;
157:
158: if g_debug_flag = 'Y' then
159: edw_log.put_line('Completed Push_FII_PA_PABU_BUDGET_LSTG');
160: end if;
161:
162: Exception When others then
163: raise;