eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FIN_PLAN_VIEW_GLOBAL dependencies on PA_FIN_PLAN_VIEW_GLOBAL

Line 1: PACKAGE BODY pa_fin_plan_view_global as

1: PACKAGE BODY pa_fin_plan_view_global as
2: /* $Header: PARFPSVB.pls 120.4 2006/03/09 20:11:28 nkumbi noship $ */
3:
4: PROCEDURE pa_fp_get_budget_status_code(
5: p_budget_version_id IN NUMBER,

Line 46: pa_fin_plan_view_global.G_FP_VIEW_VERSION_ID := p_orgfcst_version_id;

42: BEGIN
43:
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45:
46: pa_fin_plan_view_global.G_FP_VIEW_VERSION_ID := p_orgfcst_version_id;
47:
48: select project_id
49: into l_project_id
50: from pa_budget_versions

Line 58: pa_fin_plan_view_global.G_FP_ORG_ID := l_org_id;

54: into l_org_id
55: from pa_projects_all
56: where project_id = l_project_id;
57:
58: pa_fin_plan_view_global.G_FP_ORG_ID := l_org_id;
59:
60: select fin_plan_start_date, fin_plan_end_date
61: into ll_plan_start_date,ll_plan_end_date
62: from pa_proj_fp_options

Line 73: pa_fin_plan_view_global.G_FP_PLAN_START_DATE := ll_plan_start_date;

69: pa_budget_versions pbv
70: where pbv.budget_version_id = p_orgfcst_version_id
71: and pp.period_profile_id = pbv.period_profile_id;
72:
73: pa_fin_plan_view_global.G_FP_PLAN_START_DATE := ll_plan_start_date;
74: pa_fin_plan_view_global.G_FP_PLAN_END_DATE := ll_plan_end_date;
75: pa_fin_plan_view_global.G_FP_PERIOD_TYPE := ll_plan_period_type;
76:
77: if ll_plan_period_type = 'GL' THEN

Line 74: pa_fin_plan_view_global.G_FP_PLAN_END_DATE := ll_plan_end_date;

70: where pbv.budget_version_id = p_orgfcst_version_id
71: and pp.period_profile_id = pbv.period_profile_id;
72:
73: pa_fin_plan_view_global.G_FP_PLAN_START_DATE := ll_plan_start_date;
74: pa_fin_plan_view_global.G_FP_PLAN_END_DATE := ll_plan_end_date;
75: pa_fin_plan_view_global.G_FP_PERIOD_TYPE := ll_plan_period_type;
76:
77: if ll_plan_period_type = 'GL' THEN
78: l_num_of_periods := 6;

Line 75: pa_fin_plan_view_global.G_FP_PERIOD_TYPE := ll_plan_period_type;

71: and pp.period_profile_id = pbv.period_profile_id;
72:
73: pa_fin_plan_view_global.G_FP_PLAN_START_DATE := ll_plan_start_date;
74: pa_fin_plan_view_global.G_FP_PLAN_END_DATE := ll_plan_end_date;
75: pa_fin_plan_view_global.G_FP_PERIOD_TYPE := ll_plan_period_type;
76:
77: if ll_plan_period_type = 'GL' THEN
78: l_num_of_periods := 6;
79: else

Line 89: pa_fin_plan_view_global.G_FP_VIEW_START_DATE1:=ll_plan_end_date;

85: l_start_date := to_char(ll_plan_start_date);
86:
87: elsif p_period_start_date = 'L' Then
88:
89: pa_fin_plan_view_global.G_FP_VIEW_START_DATE1:=ll_plan_end_date;
90: pa_fin_plan_view_global.pa_fp_set_periods_nav (
91: p_direction => 'BACKWARD',
92: p_num_of_periods => l_num_of_periods,
93: p_period_type => ll_plan_period_type,

Line 90: pa_fin_plan_view_global.pa_fp_set_periods_nav (

86:
87: elsif p_period_start_date = 'L' Then
88:
89: pa_fin_plan_view_global.G_FP_VIEW_START_DATE1:=ll_plan_end_date;
90: pa_fin_plan_view_global.pa_fp_set_periods_nav (
91: p_direction => 'BACKWARD',
92: p_num_of_periods => l_num_of_periods,
93: p_period_type => ll_plan_period_type,
94: x_start_date => l_start_date,

Line 106: pa_fin_plan_view_global.pa_fp_set_periods (

102:
103:
104: end if;
105:
106: pa_fin_plan_view_global.pa_fp_set_periods (
107: p_period_start_date => l_start_date,
108: p_period_type => ll_plan_period_type,
109: x_return_status => l_return_status,
110: x_msg_count => l_msg_count,

Line 121: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_VIEW_GLOBAL',

117: WHEN OTHERS THEN
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119: x_msg_count := 1;
120: x_msg_data := SQLERRM;
121: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_VIEW_GLOBAL',
122: p_procedure_name => 'pa_fp_set_orgfcst_version_id');
123:
124: END pa_fp_set_orgfcst_version_id;
125:

Line 137: pa_fin_plan_view_global.G_FP_ADJ_REASON_CODE := p_adj_reason_code;

133: IS
134:
135: BEGIN
136: x_return_status:= FND_API.G_RET_STS_SUCCESS;
137: pa_fin_plan_view_global.G_FP_ADJ_REASON_CODE := p_adj_reason_code;
138:
139: begin
140: select pe.adjustment_comments
141: into x_adj_comments

Line 144: where pra.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

140: select pe.adjustment_comments
141: into x_adj_comments
142: from pa_fp_adj_elements pe,
143: pa_resource_assignments pra
144: where pra.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
145: and resource_assignment_type = 'OWN'
146: and pe.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
147: and pe.resource_assignment_id = pra.resource_assignment_id
148: and pe.ADJUSTMENT_REASON_CODE = pa_fin_plan_view_global.Get_Adj_Reason_Code();

Line 146: and pe.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

142: from pa_fp_adj_elements pe,
143: pa_resource_assignments pra
144: where pra.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
145: and resource_assignment_type = 'OWN'
146: and pe.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
147: and pe.resource_assignment_id = pra.resource_assignment_id
148: and pe.ADJUSTMENT_REASON_CODE = pa_fin_plan_view_global.Get_Adj_Reason_Code();
149:
150: exception

Line 148: and pe.ADJUSTMENT_REASON_CODE = pa_fin_plan_view_global.Get_Adj_Reason_Code();

144: where pra.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
145: and resource_assignment_type = 'OWN'
146: and pe.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
147: and pe.resource_assignment_id = pra.resource_assignment_id
148: and pe.ADJUSTMENT_REASON_CODE = pa_fin_plan_view_global.Get_Adj_Reason_Code();
149:
150: exception
151: when no_data_found then
152: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 162: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_VIEW_GLOBAL',

158: WHEN OTHERS THEN
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: x_msg_count := 1;
161: x_msg_data := SQLERRM;
162: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_VIEW_GLOBAL',
163: p_procedure_name => 'pa_fp_viewby_set_globals');
164:
165:
166: END pa_fp_set_Adj_Reason_Code;

Line 189: pa_fin_plan_view_global.G_FP_AMOUNT_TYPE_CODE := p_amount_type_code;

185: BEGIN
186:
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188:
189: pa_fin_plan_view_global.G_FP_AMOUNT_TYPE_CODE := p_amount_type_code;
190: pa_fin_plan_view_global.G_FP_RA_ID := p_resource_assignment_id;
191: l_budget_version_id := p_budget_version_id;
192:
193: l_start_date := p_start_period;

Line 190: pa_fin_plan_view_global.G_FP_RA_ID := p_resource_assignment_id;

186:
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188:
189: pa_fin_plan_view_global.G_FP_AMOUNT_TYPE_CODE := p_amount_type_code;
190: pa_fin_plan_view_global.G_FP_RA_ID := p_resource_assignment_id;
191: l_budget_version_id := p_budget_version_id;
192:
193: l_start_date := p_start_period;
194:

Line 195: pa_fin_plan_view_global.pa_fp_set_orgfcst_version_id(

191: l_budget_version_id := p_budget_version_id;
192:
193: l_start_date := p_start_period;
194:
195: pa_fin_plan_view_global.pa_fp_set_orgfcst_version_id(
196: p_orgfcst_version_id => l_budget_version_id,
197: p_period_start_date => l_start_date,
198: x_return_status => l_return_status,
199: x_msg_count => l_msg_count,

Line 211: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_VIEW_GLOBAL',

207: WHEN OTHERS THEN
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: x_msg_count := 1;
210: x_msg_data := SQLERRM;
211: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_VIEW_GLOBAL',
212: p_procedure_name => 'pa_fp_viewby_set_globals');
213: END pa_fp_viewby_set_globals;
214:
215:

Line 290: pa_fin_plan_view_global.G_FP_VIEW_START_DATE1 := v_start_date_tab(0);

286: END LOOP;
287:
288: CLOSE C1;
289:
290: pa_fin_plan_view_global.G_FP_VIEW_START_DATE1 := v_start_date_tab(0);
291: pa_fin_plan_view_global.G_FP_VIEW_START_DATE2 := v_start_date_tab(1);
292: pa_fin_plan_view_global.G_FP_VIEW_START_DATE3 := v_start_date_tab(2);
293: pa_fin_plan_view_global.G_FP_VIEW_START_DATE4 := v_start_date_tab(3);
294: pa_fin_plan_view_global.G_FP_VIEW_START_DATE5 := v_start_date_tab(4);

Line 291: pa_fin_plan_view_global.G_FP_VIEW_START_DATE2 := v_start_date_tab(1);

287:
288: CLOSE C1;
289:
290: pa_fin_plan_view_global.G_FP_VIEW_START_DATE1 := v_start_date_tab(0);
291: pa_fin_plan_view_global.G_FP_VIEW_START_DATE2 := v_start_date_tab(1);
292: pa_fin_plan_view_global.G_FP_VIEW_START_DATE3 := v_start_date_tab(2);
293: pa_fin_plan_view_global.G_FP_VIEW_START_DATE4 := v_start_date_tab(3);
294: pa_fin_plan_view_global.G_FP_VIEW_START_DATE5 := v_start_date_tab(4);
295: pa_fin_plan_view_global.G_FP_VIEW_START_DATE6 := v_start_date_tab(5);

Line 292: pa_fin_plan_view_global.G_FP_VIEW_START_DATE3 := v_start_date_tab(2);

288: CLOSE C1;
289:
290: pa_fin_plan_view_global.G_FP_VIEW_START_DATE1 := v_start_date_tab(0);
291: pa_fin_plan_view_global.G_FP_VIEW_START_DATE2 := v_start_date_tab(1);
292: pa_fin_plan_view_global.G_FP_VIEW_START_DATE3 := v_start_date_tab(2);
293: pa_fin_plan_view_global.G_FP_VIEW_START_DATE4 := v_start_date_tab(3);
294: pa_fin_plan_view_global.G_FP_VIEW_START_DATE5 := v_start_date_tab(4);
295: pa_fin_plan_view_global.G_FP_VIEW_START_DATE6 := v_start_date_tab(5);
296:

Line 293: pa_fin_plan_view_global.G_FP_VIEW_START_DATE4 := v_start_date_tab(3);

289:
290: pa_fin_plan_view_global.G_FP_VIEW_START_DATE1 := v_start_date_tab(0);
291: pa_fin_plan_view_global.G_FP_VIEW_START_DATE2 := v_start_date_tab(1);
292: pa_fin_plan_view_global.G_FP_VIEW_START_DATE3 := v_start_date_tab(2);
293: pa_fin_plan_view_global.G_FP_VIEW_START_DATE4 := v_start_date_tab(3);
294: pa_fin_plan_view_global.G_FP_VIEW_START_DATE5 := v_start_date_tab(4);
295: pa_fin_plan_view_global.G_FP_VIEW_START_DATE6 := v_start_date_tab(5);
296:
297: pa_fin_plan_view_global.G_FP_VIEW_END_DATE1 := v_end_date_tab(0);

Line 294: pa_fin_plan_view_global.G_FP_VIEW_START_DATE5 := v_start_date_tab(4);

290: pa_fin_plan_view_global.G_FP_VIEW_START_DATE1 := v_start_date_tab(0);
291: pa_fin_plan_view_global.G_FP_VIEW_START_DATE2 := v_start_date_tab(1);
292: pa_fin_plan_view_global.G_FP_VIEW_START_DATE3 := v_start_date_tab(2);
293: pa_fin_plan_view_global.G_FP_VIEW_START_DATE4 := v_start_date_tab(3);
294: pa_fin_plan_view_global.G_FP_VIEW_START_DATE5 := v_start_date_tab(4);
295: pa_fin_plan_view_global.G_FP_VIEW_START_DATE6 := v_start_date_tab(5);
296:
297: pa_fin_plan_view_global.G_FP_VIEW_END_DATE1 := v_end_date_tab(0);
298: pa_fin_plan_view_global.G_FP_VIEW_END_DATE2 := v_end_date_tab(1);

Line 295: pa_fin_plan_view_global.G_FP_VIEW_START_DATE6 := v_start_date_tab(5);

291: pa_fin_plan_view_global.G_FP_VIEW_START_DATE2 := v_start_date_tab(1);
292: pa_fin_plan_view_global.G_FP_VIEW_START_DATE3 := v_start_date_tab(2);
293: pa_fin_plan_view_global.G_FP_VIEW_START_DATE4 := v_start_date_tab(3);
294: pa_fin_plan_view_global.G_FP_VIEW_START_DATE5 := v_start_date_tab(4);
295: pa_fin_plan_view_global.G_FP_VIEW_START_DATE6 := v_start_date_tab(5);
296:
297: pa_fin_plan_view_global.G_FP_VIEW_END_DATE1 := v_end_date_tab(0);
298: pa_fin_plan_view_global.G_FP_VIEW_END_DATE2 := v_end_date_tab(1);
299: pa_fin_plan_view_global.G_FP_VIEW_END_DATE3 := v_end_date_tab(2);

Line 297: pa_fin_plan_view_global.G_FP_VIEW_END_DATE1 := v_end_date_tab(0);

293: pa_fin_plan_view_global.G_FP_VIEW_START_DATE4 := v_start_date_tab(3);
294: pa_fin_plan_view_global.G_FP_VIEW_START_DATE5 := v_start_date_tab(4);
295: pa_fin_plan_view_global.G_FP_VIEW_START_DATE6 := v_start_date_tab(5);
296:
297: pa_fin_plan_view_global.G_FP_VIEW_END_DATE1 := v_end_date_tab(0);
298: pa_fin_plan_view_global.G_FP_VIEW_END_DATE2 := v_end_date_tab(1);
299: pa_fin_plan_view_global.G_FP_VIEW_END_DATE3 := v_end_date_tab(2);
300: pa_fin_plan_view_global.G_FP_VIEW_END_DATE4 := v_end_date_tab(3);
301: pa_fin_plan_view_global.G_FP_VIEW_END_DATE5 := v_end_date_tab(4);

Line 298: pa_fin_plan_view_global.G_FP_VIEW_END_DATE2 := v_end_date_tab(1);

294: pa_fin_plan_view_global.G_FP_VIEW_START_DATE5 := v_start_date_tab(4);
295: pa_fin_plan_view_global.G_FP_VIEW_START_DATE6 := v_start_date_tab(5);
296:
297: pa_fin_plan_view_global.G_FP_VIEW_END_DATE1 := v_end_date_tab(0);
298: pa_fin_plan_view_global.G_FP_VIEW_END_DATE2 := v_end_date_tab(1);
299: pa_fin_plan_view_global.G_FP_VIEW_END_DATE3 := v_end_date_tab(2);
300: pa_fin_plan_view_global.G_FP_VIEW_END_DATE4 := v_end_date_tab(3);
301: pa_fin_plan_view_global.G_FP_VIEW_END_DATE5 := v_end_date_tab(4);
302: pa_fin_plan_view_global.G_FP_VIEW_END_DATE6 := v_end_date_tab(5);

Line 299: pa_fin_plan_view_global.G_FP_VIEW_END_DATE3 := v_end_date_tab(2);

295: pa_fin_plan_view_global.G_FP_VIEW_START_DATE6 := v_start_date_tab(5);
296:
297: pa_fin_plan_view_global.G_FP_VIEW_END_DATE1 := v_end_date_tab(0);
298: pa_fin_plan_view_global.G_FP_VIEW_END_DATE2 := v_end_date_tab(1);
299: pa_fin_plan_view_global.G_FP_VIEW_END_DATE3 := v_end_date_tab(2);
300: pa_fin_plan_view_global.G_FP_VIEW_END_DATE4 := v_end_date_tab(3);
301: pa_fin_plan_view_global.G_FP_VIEW_END_DATE5 := v_end_date_tab(4);
302: pa_fin_plan_view_global.G_FP_VIEW_END_DATE6 := v_end_date_tab(5);
303: /*

Line 300: pa_fin_plan_view_global.G_FP_VIEW_END_DATE4 := v_end_date_tab(3);

296:
297: pa_fin_plan_view_global.G_FP_VIEW_END_DATE1 := v_end_date_tab(0);
298: pa_fin_plan_view_global.G_FP_VIEW_END_DATE2 := v_end_date_tab(1);
299: pa_fin_plan_view_global.G_FP_VIEW_END_DATE3 := v_end_date_tab(2);
300: pa_fin_plan_view_global.G_FP_VIEW_END_DATE4 := v_end_date_tab(3);
301: pa_fin_plan_view_global.G_FP_VIEW_END_DATE5 := v_end_date_tab(4);
302: pa_fin_plan_view_global.G_FP_VIEW_END_DATE6 := v_end_date_tab(5);
303: /*
304: dbms_output.put_line('global start date 1: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE1);

Line 301: pa_fin_plan_view_global.G_FP_VIEW_END_DATE5 := v_end_date_tab(4);

297: pa_fin_plan_view_global.G_FP_VIEW_END_DATE1 := v_end_date_tab(0);
298: pa_fin_plan_view_global.G_FP_VIEW_END_DATE2 := v_end_date_tab(1);
299: pa_fin_plan_view_global.G_FP_VIEW_END_DATE3 := v_end_date_tab(2);
300: pa_fin_plan_view_global.G_FP_VIEW_END_DATE4 := v_end_date_tab(3);
301: pa_fin_plan_view_global.G_FP_VIEW_END_DATE5 := v_end_date_tab(4);
302: pa_fin_plan_view_global.G_FP_VIEW_END_DATE6 := v_end_date_tab(5);
303: /*
304: dbms_output.put_line('global start date 1: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE1);
305: dbms_output.put_line('global start date 2: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE2);

Line 302: pa_fin_plan_view_global.G_FP_VIEW_END_DATE6 := v_end_date_tab(5);

298: pa_fin_plan_view_global.G_FP_VIEW_END_DATE2 := v_end_date_tab(1);
299: pa_fin_plan_view_global.G_FP_VIEW_END_DATE3 := v_end_date_tab(2);
300: pa_fin_plan_view_global.G_FP_VIEW_END_DATE4 := v_end_date_tab(3);
301: pa_fin_plan_view_global.G_FP_VIEW_END_DATE5 := v_end_date_tab(4);
302: pa_fin_plan_view_global.G_FP_VIEW_END_DATE6 := v_end_date_tab(5);
303: /*
304: dbms_output.put_line('global start date 1: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE1);
305: dbms_output.put_line('global start date 2: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE2);
306: dbms_output.put_line('global start date 3: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE3);

Line 304: dbms_output.put_line('global start date 1: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE1);

300: pa_fin_plan_view_global.G_FP_VIEW_END_DATE4 := v_end_date_tab(3);
301: pa_fin_plan_view_global.G_FP_VIEW_END_DATE5 := v_end_date_tab(4);
302: pa_fin_plan_view_global.G_FP_VIEW_END_DATE6 := v_end_date_tab(5);
303: /*
304: dbms_output.put_line('global start date 1: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE1);
305: dbms_output.put_line('global start date 2: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE2);
306: dbms_output.put_line('global start date 3: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE3);
307: dbms_output.put_line('global start date 4: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE4);
308: dbms_output.put_line('global start date 5: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE5);

Line 305: dbms_output.put_line('global start date 2: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE2);

301: pa_fin_plan_view_global.G_FP_VIEW_END_DATE5 := v_end_date_tab(4);
302: pa_fin_plan_view_global.G_FP_VIEW_END_DATE6 := v_end_date_tab(5);
303: /*
304: dbms_output.put_line('global start date 1: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE1);
305: dbms_output.put_line('global start date 2: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE2);
306: dbms_output.put_line('global start date 3: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE3);
307: dbms_output.put_line('global start date 4: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE4);
308: dbms_output.put_line('global start date 5: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE5);
309: dbms_output.put_line('global start date 6: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE6);

Line 306: dbms_output.put_line('global start date 3: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE3);

302: pa_fin_plan_view_global.G_FP_VIEW_END_DATE6 := v_end_date_tab(5);
303: /*
304: dbms_output.put_line('global start date 1: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE1);
305: dbms_output.put_line('global start date 2: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE2);
306: dbms_output.put_line('global start date 3: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE3);
307: dbms_output.put_line('global start date 4: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE4);
308: dbms_output.put_line('global start date 5: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE5);
309: dbms_output.put_line('global start date 6: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE6);
310:

Line 307: dbms_output.put_line('global start date 4: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE4);

303: /*
304: dbms_output.put_line('global start date 1: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE1);
305: dbms_output.put_line('global start date 2: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE2);
306: dbms_output.put_line('global start date 3: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE3);
307: dbms_output.put_line('global start date 4: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE4);
308: dbms_output.put_line('global start date 5: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE5);
309: dbms_output.put_line('global start date 6: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE6);
310:
311: dbms_output.put_line('global end date 1: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE1);

Line 308: dbms_output.put_line('global start date 5: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE5);

304: dbms_output.put_line('global start date 1: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE1);
305: dbms_output.put_line('global start date 2: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE2);
306: dbms_output.put_line('global start date 3: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE3);
307: dbms_output.put_line('global start date 4: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE4);
308: dbms_output.put_line('global start date 5: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE5);
309: dbms_output.put_line('global start date 6: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE6);
310:
311: dbms_output.put_line('global end date 1: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE1);
312: dbms_output.put_line('global end date 2: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE2);

Line 309: dbms_output.put_line('global start date 6: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE6);

305: dbms_output.put_line('global start date 2: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE2);
306: dbms_output.put_line('global start date 3: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE3);
307: dbms_output.put_line('global start date 4: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE4);
308: dbms_output.put_line('global start date 5: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE5);
309: dbms_output.put_line('global start date 6: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE6);
310:
311: dbms_output.put_line('global end date 1: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE1);
312: dbms_output.put_line('global end date 2: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE2);
313: dbms_output.put_line('global end date 3: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE3);

Line 311: dbms_output.put_line('global end date 1: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE1);

307: dbms_output.put_line('global start date 4: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE4);
308: dbms_output.put_line('global start date 5: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE5);
309: dbms_output.put_line('global start date 6: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE6);
310:
311: dbms_output.put_line('global end date 1: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE1);
312: dbms_output.put_line('global end date 2: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE2);
313: dbms_output.put_line('global end date 3: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE3);
314: dbms_output.put_line('global end date 4: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE4);
315: dbms_output.put_line('global end date 5: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE5);

Line 312: dbms_output.put_line('global end date 2: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE2);

308: dbms_output.put_line('global start date 5: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE5);
309: dbms_output.put_line('global start date 6: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE6);
310:
311: dbms_output.put_line('global end date 1: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE1);
312: dbms_output.put_line('global end date 2: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE2);
313: dbms_output.put_line('global end date 3: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE3);
314: dbms_output.put_line('global end date 4: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE4);
315: dbms_output.put_line('global end date 5: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE5);
316: dbms_output.put_line('global end date 6: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE6);

Line 313: dbms_output.put_line('global end date 3: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE3);

309: dbms_output.put_line('global start date 6: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE6);
310:
311: dbms_output.put_line('global end date 1: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE1);
312: dbms_output.put_line('global end date 2: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE2);
313: dbms_output.put_line('global end date 3: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE3);
314: dbms_output.put_line('global end date 4: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE4);
315: dbms_output.put_line('global end date 5: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE5);
316: dbms_output.put_line('global end date 6: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE6);
317: */

Line 314: dbms_output.put_line('global end date 4: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE4);

310:
311: dbms_output.put_line('global end date 1: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE1);
312: dbms_output.put_line('global end date 2: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE2);
313: dbms_output.put_line('global end date 3: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE3);
314: dbms_output.put_line('global end date 4: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE4);
315: dbms_output.put_line('global end date 5: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE5);
316: dbms_output.put_line('global end date 6: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE6);
317: */
318:

Line 315: dbms_output.put_line('global end date 5: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE5);

311: dbms_output.put_line('global end date 1: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE1);
312: dbms_output.put_line('global end date 2: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE2);
313: dbms_output.put_line('global end date 3: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE3);
314: dbms_output.put_line('global end date 4: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE4);
315: dbms_output.put_line('global end date 5: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE5);
316: dbms_output.put_line('global end date 6: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE6);
317: */
318:
319:

Line 316: dbms_output.put_line('global end date 6: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE6);

312: dbms_output.put_line('global end date 2: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE2);
313: dbms_output.put_line('global end date 3: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE3);
314: dbms_output.put_line('global end date 4: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE4);
315: dbms_output.put_line('global end date 5: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE5);
316: dbms_output.put_line('global end date 6: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE6);
317: */
318:
319:
320: if p_period_type = 'PA' THEN

Line 322: pa_fin_plan_view_global.G_FP_VIEW_START_DATE7 := v_start_date_tab(6);

318:
319:
320: if p_period_type = 'PA' THEN
321:
322: pa_fin_plan_view_global.G_FP_VIEW_START_DATE7 := v_start_date_tab(6);
323: pa_fin_plan_view_global.G_FP_VIEW_START_DATE8 := v_start_date_tab(7);
324: pa_fin_plan_view_global.G_FP_VIEW_START_DATE9 := v_start_date_tab(8);
325: pa_fin_plan_view_global.G_FP_VIEW_START_DATE10 := v_start_date_tab(9);
326: pa_fin_plan_view_global.G_FP_VIEW_START_DATE11 := v_start_date_tab(10);

Line 323: pa_fin_plan_view_global.G_FP_VIEW_START_DATE8 := v_start_date_tab(7);

319:
320: if p_period_type = 'PA' THEN
321:
322: pa_fin_plan_view_global.G_FP_VIEW_START_DATE7 := v_start_date_tab(6);
323: pa_fin_plan_view_global.G_FP_VIEW_START_DATE8 := v_start_date_tab(7);
324: pa_fin_plan_view_global.G_FP_VIEW_START_DATE9 := v_start_date_tab(8);
325: pa_fin_plan_view_global.G_FP_VIEW_START_DATE10 := v_start_date_tab(9);
326: pa_fin_plan_view_global.G_FP_VIEW_START_DATE11 := v_start_date_tab(10);
327: pa_fin_plan_view_global.G_FP_VIEW_START_DATE12 := v_start_date_tab(11);

Line 324: pa_fin_plan_view_global.G_FP_VIEW_START_DATE9 := v_start_date_tab(8);

320: if p_period_type = 'PA' THEN
321:
322: pa_fin_plan_view_global.G_FP_VIEW_START_DATE7 := v_start_date_tab(6);
323: pa_fin_plan_view_global.G_FP_VIEW_START_DATE8 := v_start_date_tab(7);
324: pa_fin_plan_view_global.G_FP_VIEW_START_DATE9 := v_start_date_tab(8);
325: pa_fin_plan_view_global.G_FP_VIEW_START_DATE10 := v_start_date_tab(9);
326: pa_fin_plan_view_global.G_FP_VIEW_START_DATE11 := v_start_date_tab(10);
327: pa_fin_plan_view_global.G_FP_VIEW_START_DATE12 := v_start_date_tab(11);
328: pa_fin_plan_view_global.G_FP_VIEW_START_DATE13 := v_start_date_tab(12);

Line 325: pa_fin_plan_view_global.G_FP_VIEW_START_DATE10 := v_start_date_tab(9);

321:
322: pa_fin_plan_view_global.G_FP_VIEW_START_DATE7 := v_start_date_tab(6);
323: pa_fin_plan_view_global.G_FP_VIEW_START_DATE8 := v_start_date_tab(7);
324: pa_fin_plan_view_global.G_FP_VIEW_START_DATE9 := v_start_date_tab(8);
325: pa_fin_plan_view_global.G_FP_VIEW_START_DATE10 := v_start_date_tab(9);
326: pa_fin_plan_view_global.G_FP_VIEW_START_DATE11 := v_start_date_tab(10);
327: pa_fin_plan_view_global.G_FP_VIEW_START_DATE12 := v_start_date_tab(11);
328: pa_fin_plan_view_global.G_FP_VIEW_START_DATE13 := v_start_date_tab(12);
329:

Line 326: pa_fin_plan_view_global.G_FP_VIEW_START_DATE11 := v_start_date_tab(10);

322: pa_fin_plan_view_global.G_FP_VIEW_START_DATE7 := v_start_date_tab(6);
323: pa_fin_plan_view_global.G_FP_VIEW_START_DATE8 := v_start_date_tab(7);
324: pa_fin_plan_view_global.G_FP_VIEW_START_DATE9 := v_start_date_tab(8);
325: pa_fin_plan_view_global.G_FP_VIEW_START_DATE10 := v_start_date_tab(9);
326: pa_fin_plan_view_global.G_FP_VIEW_START_DATE11 := v_start_date_tab(10);
327: pa_fin_plan_view_global.G_FP_VIEW_START_DATE12 := v_start_date_tab(11);
328: pa_fin_plan_view_global.G_FP_VIEW_START_DATE13 := v_start_date_tab(12);
329:
330: pa_fin_plan_view_global.G_FP_VIEW_END_DATE7 := v_end_date_tab(6);

Line 327: pa_fin_plan_view_global.G_FP_VIEW_START_DATE12 := v_start_date_tab(11);

323: pa_fin_plan_view_global.G_FP_VIEW_START_DATE8 := v_start_date_tab(7);
324: pa_fin_plan_view_global.G_FP_VIEW_START_DATE9 := v_start_date_tab(8);
325: pa_fin_plan_view_global.G_FP_VIEW_START_DATE10 := v_start_date_tab(9);
326: pa_fin_plan_view_global.G_FP_VIEW_START_DATE11 := v_start_date_tab(10);
327: pa_fin_plan_view_global.G_FP_VIEW_START_DATE12 := v_start_date_tab(11);
328: pa_fin_plan_view_global.G_FP_VIEW_START_DATE13 := v_start_date_tab(12);
329:
330: pa_fin_plan_view_global.G_FP_VIEW_END_DATE7 := v_end_date_tab(6);
331: pa_fin_plan_view_global.G_FP_VIEW_END_DATE8 := v_end_date_tab(7);

Line 328: pa_fin_plan_view_global.G_FP_VIEW_START_DATE13 := v_start_date_tab(12);

324: pa_fin_plan_view_global.G_FP_VIEW_START_DATE9 := v_start_date_tab(8);
325: pa_fin_plan_view_global.G_FP_VIEW_START_DATE10 := v_start_date_tab(9);
326: pa_fin_plan_view_global.G_FP_VIEW_START_DATE11 := v_start_date_tab(10);
327: pa_fin_plan_view_global.G_FP_VIEW_START_DATE12 := v_start_date_tab(11);
328: pa_fin_plan_view_global.G_FP_VIEW_START_DATE13 := v_start_date_tab(12);
329:
330: pa_fin_plan_view_global.G_FP_VIEW_END_DATE7 := v_end_date_tab(6);
331: pa_fin_plan_view_global.G_FP_VIEW_END_DATE8 := v_end_date_tab(7);
332: pa_fin_plan_view_global.G_FP_VIEW_END_DATE9 := v_end_date_tab(8);

Line 330: pa_fin_plan_view_global.G_FP_VIEW_END_DATE7 := v_end_date_tab(6);

326: pa_fin_plan_view_global.G_FP_VIEW_START_DATE11 := v_start_date_tab(10);
327: pa_fin_plan_view_global.G_FP_VIEW_START_DATE12 := v_start_date_tab(11);
328: pa_fin_plan_view_global.G_FP_VIEW_START_DATE13 := v_start_date_tab(12);
329:
330: pa_fin_plan_view_global.G_FP_VIEW_END_DATE7 := v_end_date_tab(6);
331: pa_fin_plan_view_global.G_FP_VIEW_END_DATE8 := v_end_date_tab(7);
332: pa_fin_plan_view_global.G_FP_VIEW_END_DATE9 := v_end_date_tab(8);
333: pa_fin_plan_view_global.G_FP_VIEW_END_DATE10 := v_end_date_tab(9);
334: pa_fin_plan_view_global.G_FP_VIEW_END_DATE11 := v_end_date_tab(10);

Line 331: pa_fin_plan_view_global.G_FP_VIEW_END_DATE8 := v_end_date_tab(7);

327: pa_fin_plan_view_global.G_FP_VIEW_START_DATE12 := v_start_date_tab(11);
328: pa_fin_plan_view_global.G_FP_VIEW_START_DATE13 := v_start_date_tab(12);
329:
330: pa_fin_plan_view_global.G_FP_VIEW_END_DATE7 := v_end_date_tab(6);
331: pa_fin_plan_view_global.G_FP_VIEW_END_DATE8 := v_end_date_tab(7);
332: pa_fin_plan_view_global.G_FP_VIEW_END_DATE9 := v_end_date_tab(8);
333: pa_fin_plan_view_global.G_FP_VIEW_END_DATE10 := v_end_date_tab(9);
334: pa_fin_plan_view_global.G_FP_VIEW_END_DATE11 := v_end_date_tab(10);
335: pa_fin_plan_view_global.G_FP_VIEW_END_DATE12 := v_end_date_tab(11);

Line 332: pa_fin_plan_view_global.G_FP_VIEW_END_DATE9 := v_end_date_tab(8);

328: pa_fin_plan_view_global.G_FP_VIEW_START_DATE13 := v_start_date_tab(12);
329:
330: pa_fin_plan_view_global.G_FP_VIEW_END_DATE7 := v_end_date_tab(6);
331: pa_fin_plan_view_global.G_FP_VIEW_END_DATE8 := v_end_date_tab(7);
332: pa_fin_plan_view_global.G_FP_VIEW_END_DATE9 := v_end_date_tab(8);
333: pa_fin_plan_view_global.G_FP_VIEW_END_DATE10 := v_end_date_tab(9);
334: pa_fin_plan_view_global.G_FP_VIEW_END_DATE11 := v_end_date_tab(10);
335: pa_fin_plan_view_global.G_FP_VIEW_END_DATE12 := v_end_date_tab(11);
336: pa_fin_plan_view_global.G_FP_VIEW_END_DATE13 := v_end_date_tab(12);

Line 333: pa_fin_plan_view_global.G_FP_VIEW_END_DATE10 := v_end_date_tab(9);

329:
330: pa_fin_plan_view_global.G_FP_VIEW_END_DATE7 := v_end_date_tab(6);
331: pa_fin_plan_view_global.G_FP_VIEW_END_DATE8 := v_end_date_tab(7);
332: pa_fin_plan_view_global.G_FP_VIEW_END_DATE9 := v_end_date_tab(8);
333: pa_fin_plan_view_global.G_FP_VIEW_END_DATE10 := v_end_date_tab(9);
334: pa_fin_plan_view_global.G_FP_VIEW_END_DATE11 := v_end_date_tab(10);
335: pa_fin_plan_view_global.G_FP_VIEW_END_DATE12 := v_end_date_tab(11);
336: pa_fin_plan_view_global.G_FP_VIEW_END_DATE13 := v_end_date_tab(12);
337: /*

Line 334: pa_fin_plan_view_global.G_FP_VIEW_END_DATE11 := v_end_date_tab(10);

330: pa_fin_plan_view_global.G_FP_VIEW_END_DATE7 := v_end_date_tab(6);
331: pa_fin_plan_view_global.G_FP_VIEW_END_DATE8 := v_end_date_tab(7);
332: pa_fin_plan_view_global.G_FP_VIEW_END_DATE9 := v_end_date_tab(8);
333: pa_fin_plan_view_global.G_FP_VIEW_END_DATE10 := v_end_date_tab(9);
334: pa_fin_plan_view_global.G_FP_VIEW_END_DATE11 := v_end_date_tab(10);
335: pa_fin_plan_view_global.G_FP_VIEW_END_DATE12 := v_end_date_tab(11);
336: pa_fin_plan_view_global.G_FP_VIEW_END_DATE13 := v_end_date_tab(12);
337: /*
338: dbms_output.put_line('global start date 7: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE7);

Line 335: pa_fin_plan_view_global.G_FP_VIEW_END_DATE12 := v_end_date_tab(11);

331: pa_fin_plan_view_global.G_FP_VIEW_END_DATE8 := v_end_date_tab(7);
332: pa_fin_plan_view_global.G_FP_VIEW_END_DATE9 := v_end_date_tab(8);
333: pa_fin_plan_view_global.G_FP_VIEW_END_DATE10 := v_end_date_tab(9);
334: pa_fin_plan_view_global.G_FP_VIEW_END_DATE11 := v_end_date_tab(10);
335: pa_fin_plan_view_global.G_FP_VIEW_END_DATE12 := v_end_date_tab(11);
336: pa_fin_plan_view_global.G_FP_VIEW_END_DATE13 := v_end_date_tab(12);
337: /*
338: dbms_output.put_line('global start date 7: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE7);
339: dbms_output.put_line('global start date 8: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE8);

Line 336: pa_fin_plan_view_global.G_FP_VIEW_END_DATE13 := v_end_date_tab(12);

332: pa_fin_plan_view_global.G_FP_VIEW_END_DATE9 := v_end_date_tab(8);
333: pa_fin_plan_view_global.G_FP_VIEW_END_DATE10 := v_end_date_tab(9);
334: pa_fin_plan_view_global.G_FP_VIEW_END_DATE11 := v_end_date_tab(10);
335: pa_fin_plan_view_global.G_FP_VIEW_END_DATE12 := v_end_date_tab(11);
336: pa_fin_plan_view_global.G_FP_VIEW_END_DATE13 := v_end_date_tab(12);
337: /*
338: dbms_output.put_line('global start date 7: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE7);
339: dbms_output.put_line('global start date 8: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE8);
340: dbms_output.put_line('global start date 9: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE9);

Line 338: dbms_output.put_line('global start date 7: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE7);

334: pa_fin_plan_view_global.G_FP_VIEW_END_DATE11 := v_end_date_tab(10);
335: pa_fin_plan_view_global.G_FP_VIEW_END_DATE12 := v_end_date_tab(11);
336: pa_fin_plan_view_global.G_FP_VIEW_END_DATE13 := v_end_date_tab(12);
337: /*
338: dbms_output.put_line('global start date 7: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE7);
339: dbms_output.put_line('global start date 8: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE8);
340: dbms_output.put_line('global start date 9: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE9);
341: dbms_output.put_line('global start date 10: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE10);
342: dbms_output.put_line('global start date 11: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE11);

Line 339: dbms_output.put_line('global start date 8: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE8);

335: pa_fin_plan_view_global.G_FP_VIEW_END_DATE12 := v_end_date_tab(11);
336: pa_fin_plan_view_global.G_FP_VIEW_END_DATE13 := v_end_date_tab(12);
337: /*
338: dbms_output.put_line('global start date 7: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE7);
339: dbms_output.put_line('global start date 8: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE8);
340: dbms_output.put_line('global start date 9: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE9);
341: dbms_output.put_line('global start date 10: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE10);
342: dbms_output.put_line('global start date 11: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE11);
343: dbms_output.put_line('global start date 12: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE12);

Line 340: dbms_output.put_line('global start date 9: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE9);

336: pa_fin_plan_view_global.G_FP_VIEW_END_DATE13 := v_end_date_tab(12);
337: /*
338: dbms_output.put_line('global start date 7: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE7);
339: dbms_output.put_line('global start date 8: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE8);
340: dbms_output.put_line('global start date 9: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE9);
341: dbms_output.put_line('global start date 10: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE10);
342: dbms_output.put_line('global start date 11: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE11);
343: dbms_output.put_line('global start date 12: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE12);
344: dbms_output.put_line('global start date 13: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE13);

Line 341: dbms_output.put_line('global start date 10: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE10);

337: /*
338: dbms_output.put_line('global start date 7: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE7);
339: dbms_output.put_line('global start date 8: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE8);
340: dbms_output.put_line('global start date 9: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE9);
341: dbms_output.put_line('global start date 10: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE10);
342: dbms_output.put_line('global start date 11: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE11);
343: dbms_output.put_line('global start date 12: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE12);
344: dbms_output.put_line('global start date 13: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE13);
345:

Line 342: dbms_output.put_line('global start date 11: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE11);

338: dbms_output.put_line('global start date 7: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE7);
339: dbms_output.put_line('global start date 8: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE8);
340: dbms_output.put_line('global start date 9: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE9);
341: dbms_output.put_line('global start date 10: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE10);
342: dbms_output.put_line('global start date 11: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE11);
343: dbms_output.put_line('global start date 12: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE12);
344: dbms_output.put_line('global start date 13: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE13);
345:
346: dbms_output.put_line('global end date 7: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE7);

Line 343: dbms_output.put_line('global start date 12: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE12);

339: dbms_output.put_line('global start date 8: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE8);
340: dbms_output.put_line('global start date 9: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE9);
341: dbms_output.put_line('global start date 10: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE10);
342: dbms_output.put_line('global start date 11: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE11);
343: dbms_output.put_line('global start date 12: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE12);
344: dbms_output.put_line('global start date 13: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE13);
345:
346: dbms_output.put_line('global end date 7: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE7);
347: dbms_output.put_line('global end date 8: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE8);

Line 344: dbms_output.put_line('global start date 13: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE13);

340: dbms_output.put_line('global start date 9: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE9);
341: dbms_output.put_line('global start date 10: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE10);
342: dbms_output.put_line('global start date 11: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE11);
343: dbms_output.put_line('global start date 12: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE12);
344: dbms_output.put_line('global start date 13: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE13);
345:
346: dbms_output.put_line('global end date 7: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE7);
347: dbms_output.put_line('global end date 8: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE8);
348: dbms_output.put_line('global end date 9: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE9);

Line 346: dbms_output.put_line('global end date 7: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE7);

342: dbms_output.put_line('global start date 11: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE11);
343: dbms_output.put_line('global start date 12: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE12);
344: dbms_output.put_line('global start date 13: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE13);
345:
346: dbms_output.put_line('global end date 7: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE7);
347: dbms_output.put_line('global end date 8: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE8);
348: dbms_output.put_line('global end date 9: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE9);
349: dbms_output.put_line('global end date 10: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE10);
350: dbms_output.put_line('global end date 11: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE11);

Line 347: dbms_output.put_line('global end date 8: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE8);

343: dbms_output.put_line('global start date 12: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE12);
344: dbms_output.put_line('global start date 13: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE13);
345:
346: dbms_output.put_line('global end date 7: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE7);
347: dbms_output.put_line('global end date 8: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE8);
348: dbms_output.put_line('global end date 9: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE9);
349: dbms_output.put_line('global end date 10: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE10);
350: dbms_output.put_line('global end date 11: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE11);
351: dbms_output.put_line('global end date 12: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE12);

Line 348: dbms_output.put_line('global end date 9: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE9);

344: dbms_output.put_line('global start date 13: '||pa_fin_plan_view_global.G_FP_VIEW_START_DATE13);
345:
346: dbms_output.put_line('global end date 7: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE7);
347: dbms_output.put_line('global end date 8: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE8);
348: dbms_output.put_line('global end date 9: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE9);
349: dbms_output.put_line('global end date 10: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE10);
350: dbms_output.put_line('global end date 11: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE11);
351: dbms_output.put_line('global end date 12: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE12);
352: dbms_output.put_line('global end date 13: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE13);

Line 349: dbms_output.put_line('global end date 10: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE10);

345:
346: dbms_output.put_line('global end date 7: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE7);
347: dbms_output.put_line('global end date 8: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE8);
348: dbms_output.put_line('global end date 9: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE9);
349: dbms_output.put_line('global end date 10: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE10);
350: dbms_output.put_line('global end date 11: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE11);
351: dbms_output.put_line('global end date 12: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE12);
352: dbms_output.put_line('global end date 13: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE13);
353: */

Line 350: dbms_output.put_line('global end date 11: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE11);

346: dbms_output.put_line('global end date 7: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE7);
347: dbms_output.put_line('global end date 8: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE8);
348: dbms_output.put_line('global end date 9: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE9);
349: dbms_output.put_line('global end date 10: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE10);
350: dbms_output.put_line('global end date 11: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE11);
351: dbms_output.put_line('global end date 12: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE12);
352: dbms_output.put_line('global end date 13: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE13);
353: */
354: end if;

Line 351: dbms_output.put_line('global end date 12: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE12);

347: dbms_output.put_line('global end date 8: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE8);
348: dbms_output.put_line('global end date 9: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE9);
349: dbms_output.put_line('global end date 10: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE10);
350: dbms_output.put_line('global end date 11: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE11);
351: dbms_output.put_line('global end date 12: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE12);
352: dbms_output.put_line('global end date 13: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE13);
353: */
354: end if;
355:

Line 352: dbms_output.put_line('global end date 13: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE13);

348: dbms_output.put_line('global end date 9: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE9);
349: dbms_output.put_line('global end date 10: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE10);
350: dbms_output.put_line('global end date 11: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE11);
351: dbms_output.put_line('global end date 12: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE12);
352: dbms_output.put_line('global end date 13: '||pa_fin_plan_view_global.G_FP_VIEW_END_DATE13);
353: */
354: end if;
355:
356:

Line 395: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE1;

391:
392: BEGIN
393:
394: l_rownum := p_num_of_periods;
395: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE1;
396: l_period_type := p_period_type;
397:
398: IF p_direction = 'FORWARD' THEN
399:

Line 437: pa_fin_plan_view_global.pa_fp_set_periods (

433:
434: x_start_date := to_char(ll_start_date);
435:
436: /*
437: pa_fin_plan_view_global.pa_fp_set_periods (
438: p_period_start_date =>ll_start_date,
439: p_period_type =>l_period_type,
440: x_return_status =>l_return_status,
441: x_msg_count =>l_msg_count,

Line 699: pa_fin_plan_view_global.G_FP_ADJ_REASON_CODE := p_adj_reason_code;

695:
696:
697:
698:
699: pa_fin_plan_view_global.G_FP_ADJ_REASON_CODE := p_adj_reason_code;
700:
701: l_budget_version_id := p_budget_version_id;
702: l_project_id := p_project_id;
703: l_adj_reason_code := p_adj_reason_code;

Line 707: pa_fin_plan_view_global.pa_fp_set_orgfcst_version_id(

703: l_adj_reason_code := p_adj_reason_code;
704: l_adj_comments := p_adj_comments;
705:
706: /*
707: pa_fin_plan_view_global.pa_fp_set_orgfcst_version_id(
708: p_orgfcst_version_id => l_budget_version_id,
709: x_return_status => l_return_status,
710: x_msg_count => l_msg_count,
711: x_msg_data => l_msg_data

Line 918: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE1;

914: if l_period_name1 is not null then
915:
916: begin
917:
918: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE1;
919: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE1;
920: l_period_amount := p_period1;
921: l_period_name := l_period_name1;
922:

Line 919: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE1;

915:
916: begin
917:
918: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE1;
919: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE1;
920: l_period_amount := p_period1;
921: l_period_name := l_period_name1;
922:
923: select FIN_PLAN_ADJ_LINE_ID

Line 1080: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE2;

1076: /*for period 2*/
1077: if l_period_name2 is not null then
1078: begin
1079:
1080: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE2;
1081: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE2;
1082: l_period_amount := p_period2;
1083: l_period_name := l_period_name2;
1084:

Line 1081: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE2;

1077: if l_period_name2 is not null then
1078: begin
1079:
1080: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE2;
1081: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE2;
1082: l_period_amount := p_period2;
1083: l_period_name := l_period_name2;
1084:
1085: select FIN_PLAN_ADJ_LINE_ID

Line 1238: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE3;

1234: /*for period 3*/
1235: if l_period_name3 is not null then
1236: begin
1237:
1238: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE3;
1239: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE3;
1240: l_period_amount := p_period3;
1241: l_period_name := l_period_name3;
1242:

Line 1239: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE3;

1235: if l_period_name3 is not null then
1236: begin
1237:
1238: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE3;
1239: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE3;
1240: l_period_amount := p_period3;
1241: l_period_name := l_period_name3;
1242:
1243: select FIN_PLAN_ADJ_LINE_ID

Line 1399: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE4;

1395: /*for period 4*/
1396: if l_period_name4 is not null then
1397: begin
1398:
1399: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE4;
1400: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE4;
1401: l_period_amount := p_period4;
1402: l_period_name := l_period_name4;
1403:

Line 1400: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE4;

1396: if l_period_name4 is not null then
1397: begin
1398:
1399: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE4;
1400: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE4;
1401: l_period_amount := p_period4;
1402: l_period_name := l_period_name4;
1403:
1404: select FIN_PLAN_ADJ_LINE_ID

Line 1560: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE5;

1556: /*for period 5*/
1557: if l_period_name5 is not null then
1558: begin
1559:
1560: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE5;
1561: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE5;
1562: l_period_amount := p_period5;
1563: l_period_name := l_period_name5;
1564:

Line 1561: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE5;

1557: if l_period_name5 is not null then
1558: begin
1559:
1560: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE5;
1561: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE5;
1562: l_period_amount := p_period5;
1563: l_period_name := l_period_name5;
1564:
1565: select FIN_PLAN_ADJ_LINE_ID

Line 1719: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE6;

1715: /*for period 6*/
1716: if l_period_name6 is not null then
1717: begin
1718:
1719: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE6;
1720: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE6;
1721: l_period_amount := p_period6;
1722: l_period_name := l_period_name6;
1723:

Line 1720: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE6;

1716: if l_period_name6 is not null then
1717: begin
1718:
1719: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE6;
1720: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE6;
1721: l_period_amount := p_period6;
1722: l_period_name := l_period_name6;
1723:
1724: select FIN_PLAN_ADJ_LINE_ID

Line 1882: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE7;

1878: /*for period 7*/
1879: if l_period_name7 is not null then
1880: begin
1881:
1882: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE7;
1883: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE7;
1884: l_period_amount := p_period7;
1885: l_period_name := l_period_name7;
1886:

Line 1883: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE7;

1879: if l_period_name7 is not null then
1880: begin
1881:
1882: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE7;
1883: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE7;
1884: l_period_amount := p_period7;
1885: l_period_name := l_period_name7;
1886:
1887: select FIN_PLAN_ADJ_LINE_ID

Line 2042: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE8;

2038: /*for period 8*/
2039: if l_period_name8 is not null then
2040: begin
2041:
2042: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE8;
2043: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE8;
2044: l_period_amount := p_period8;
2045: l_period_name := l_period_name8;
2046:

Line 2043: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE8;

2039: if l_period_name8 is not null then
2040: begin
2041:
2042: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE8;
2043: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE8;
2044: l_period_amount := p_period8;
2045: l_period_name := l_period_name8;
2046:
2047: select FIN_PLAN_ADJ_LINE_ID

Line 2198: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE9;

2194: /*for period 9*/
2195: if l_period_name9 is not null then
2196: begin
2197:
2198: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE9;
2199: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE9;
2200: l_period_amount := p_period9;
2201: l_period_name := l_period_name9;
2202:

Line 2199: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE9;

2195: if l_period_name9 is not null then
2196: begin
2197:
2198: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE9;
2199: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE9;
2200: l_period_amount := p_period9;
2201: l_period_name := l_period_name9;
2202:
2203: select FIN_PLAN_ADJ_LINE_ID

Line 2359: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE10;

2355: /*for period 10*/
2356: if l_period_name10 is not null then
2357: begin
2358:
2359: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE10;
2360: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE10;
2361: l_period_amount := p_period10;
2362: l_period_name := l_period_name10;
2363:

Line 2360: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE10;

2356: if l_period_name10 is not null then
2357: begin
2358:
2359: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE10;
2360: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE10;
2361: l_period_amount := p_period10;
2362: l_period_name := l_period_name10;
2363:
2364: select FIN_PLAN_ADJ_LINE_ID

Line 2521: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE11;

2517: /*for period 11*/
2518: if l_period_name11 is not null then
2519: begin
2520:
2521: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE11;
2522: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE11;
2523: l_period_amount := p_period11;
2524: l_period_name := l_period_name11;
2525:

Line 2522: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE11;

2518: if l_period_name11 is not null then
2519: begin
2520:
2521: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE11;
2522: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE11;
2523: l_period_amount := p_period11;
2524: l_period_name := l_period_name11;
2525:
2526: select FIN_PLAN_ADJ_LINE_ID

Line 2680: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE12;

2676: /*for period 12*/
2677: if l_period_name12 is not null then
2678: begin
2679:
2680: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE12;
2681: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE12;
2682: l_period_amount := p_period12;
2683: l_period_name := l_period_name12;
2684:

Line 2681: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE12;

2677: if l_period_name12 is not null then
2678: begin
2679:
2680: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE12;
2681: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE12;
2682: l_period_amount := p_period12;
2683: l_period_name := l_period_name12;
2684:
2685: select FIN_PLAN_ADJ_LINE_ID

Line 2841: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE13;

2837: /*for period 13*/
2838: if l_period_name13 is not null then
2839: begin
2840:
2841: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE13;
2842: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE13;
2843: l_period_amount := p_period13;
2844: l_period_name := l_period_name13;
2845:

Line 2842: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE13;

2838: if l_period_name13 is not null then
2839: begin
2840:
2841: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE13;
2842: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE13;
2843: l_period_amount := p_period13;
2844: l_period_name := l_period_name13;
2845:
2846: select FIN_PLAN_ADJ_LINE_ID

Line 3031: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE1;

3027:
3028: if l_period_name1 is not null then
3029: begin
3030:
3031: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE1;
3032: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE1;
3033: l_period_amount := p_period1;
3034: l_period_name := l_period_name1;
3035:

Line 3032: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE1;

3028: if l_period_name1 is not null then
3029: begin
3030:
3031: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE1;
3032: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE1;
3033: l_period_amount := p_period1;
3034: l_period_name := l_period_name1;
3035:
3036: select FIN_PLAN_ADJ_LINE_ID

Line 3191: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE2;

3187: /*for period 2*/
3188: if l_period_name2 is not null then
3189: begin
3190:
3191: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE2;
3192: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE2;
3193: l_period_amount := p_period2;
3194: l_period_name := l_period_name2;
3195:

Line 3192: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE2;

3188: if l_period_name2 is not null then
3189: begin
3190:
3191: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE2;
3192: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE2;
3193: l_period_amount := p_period2;
3194: l_period_name := l_period_name2;
3195:
3196: select FIN_PLAN_ADJ_LINE_ID

Line 3348: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE3;

3344: /*for period 3*/
3345: if l_period_name3 is not null then
3346: begin
3347:
3348: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE3;
3349: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE3;
3350: l_period_amount := p_period3;
3351: l_period_name := l_period_name3;
3352:

Line 3349: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE3;

3345: if l_period_name3 is not null then
3346: begin
3347:
3348: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE3;
3349: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE3;
3350: l_period_amount := p_period3;
3351: l_period_name := l_period_name3;
3352:
3353: select FIN_PLAN_ADJ_LINE_ID

Line 3509: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE4;

3505: /*for period 4*/
3506: if l_period_name4 is not null then
3507: begin
3508:
3509: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE4;
3510: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE4;
3511: l_period_amount := p_period4;
3512: l_period_name := l_period_name4;
3513:

Line 3510: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE4;

3506: if l_period_name4 is not null then
3507: begin
3508:
3509: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE4;
3510: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE4;
3511: l_period_amount := p_period4;
3512: l_period_name := l_period_name4;
3513:
3514: select FIN_PLAN_ADJ_LINE_ID

Line 3671: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE5;

3667: /*for period 5*/
3668: if l_period_name5 is not null then
3669: begin
3670:
3671: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE5;
3672: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE5;
3673: l_period_amount := p_period5;
3674: l_period_name := l_period_name5;
3675:

Line 3672: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE5;

3668: if l_period_name5 is not null then
3669: begin
3670:
3671: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE5;
3672: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE5;
3673: l_period_amount := p_period5;
3674: l_period_name := l_period_name5;
3675:
3676: select FIN_PLAN_ADJ_LINE_ID

Line 3831: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE6;

3827: /*for period 6*/
3828: if l_period_name6 is not null then
3829: begin
3830:
3831: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE6;
3832: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE6;
3833: l_period_amount := p_period6;
3834: l_period_name := l_period_name6;
3835:

Line 3832: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE6;

3828: if l_period_name6 is not null then
3829: begin
3830:
3831: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE6;
3832: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE6;
3833: l_period_amount := p_period6;
3834: l_period_name := l_period_name6;
3835:
3836: select FIN_PLAN_ADJ_LINE_ID

Line 3993: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE7;

3989: /*for period 7*/
3990: if l_period_name7 is not null then
3991: begin
3992:
3993: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE7;
3994: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE7;
3995: l_period_amount := p_period7;
3996: l_period_name := l_period_name7;
3997:

Line 3994: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE7;

3990: if l_period_name7 is not null then
3991: begin
3992:
3993: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE7;
3994: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE7;
3995: l_period_amount := p_period7;
3996: l_period_name := l_period_name7;
3997:
3998: select FIN_PLAN_ADJ_LINE_ID

Line 4153: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE8;

4149: /*for period 8*/
4150: if l_period_name8 is not null then
4151: begin
4152:
4153: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE8;
4154: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE8;
4155: l_period_amount := p_period8;
4156: l_period_name := l_period_name8;
4157:

Line 4154: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE8;

4150: if l_period_name8 is not null then
4151: begin
4152:
4153: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE8;
4154: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE8;
4155: l_period_amount := p_period8;
4156: l_period_name := l_period_name8;
4157:
4158: select FIN_PLAN_ADJ_LINE_ID

Line 4310: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE9;

4306: /*for period 9*/
4307: if l_period_name9 is not null then
4308: begin
4309:
4310: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE9;
4311: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE9;
4312: l_period_amount := p_period9;
4313: l_period_name := l_period_name9;
4314:

Line 4311: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE9;

4307: if l_period_name9 is not null then
4308: begin
4309:
4310: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE9;
4311: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE9;
4312: l_period_amount := p_period9;
4313: l_period_name := l_period_name9;
4314:
4315: select FIN_PLAN_ADJ_LINE_ID

Line 4471: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE10;

4467: /*for period 10*/
4468: if l_period_name10 is not null then
4469: begin
4470:
4471: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE10;
4472: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE10;
4473: l_period_amount := p_period10;
4474: l_period_name := l_period_name10;
4475:

Line 4472: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE10;

4468: if l_period_name10 is not null then
4469: begin
4470:
4471: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE10;
4472: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE10;
4473: l_period_amount := p_period10;
4474: l_period_name := l_period_name10;
4475:
4476: select FIN_PLAN_ADJ_LINE_ID

Line 4631: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE11;

4627: /*for period 11*/
4628: if l_period_name11 is not null then
4629: begin
4630:
4631: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE11;
4632: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE11;
4633: l_period_amount := p_period11;
4634: l_period_name := l_period_name11;
4635:

Line 4632: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE11;

4628: if l_period_name11 is not null then
4629: begin
4630:
4631: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE11;
4632: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE11;
4633: l_period_amount := p_period11;
4634: l_period_name := l_period_name11;
4635:
4636: select FIN_PLAN_ADJ_LINE_ID

Line 4789: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE12;

4785: /*for period 12*/
4786: if l_period_name12 is not null then
4787: begin
4788:
4789: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE12;
4790: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE12;
4791: l_period_amount := p_period12;
4792: l_period_name := l_period_name12;
4793:

Line 4790: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE12;

4786: if l_period_name12 is not null then
4787: begin
4788:
4789: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE12;
4790: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE12;
4791: l_period_amount := p_period12;
4792: l_period_name := l_period_name12;
4793:
4794: select FIN_PLAN_ADJ_LINE_ID

Line 4949: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE13;

4945: /*for period 13*/
4946: if l_period_name13 is not null then
4947: begin
4948:
4949: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE13;
4950: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE13;
4951: l_period_amount := p_period13;
4952: l_period_name := l_period_name13;
4953:

Line 4950: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE13;

4946: if l_period_name13 is not null then
4947: begin
4948:
4949: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE13;
4950: l_end_date := pa_fin_plan_view_global.G_FP_VIEW_END_DATE13;
4951: l_period_amount := p_period13;
4952: l_period_name := l_period_name13;
4953:
4954: select FIN_PLAN_ADJ_LINE_ID

Line 5134: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE1;

5130:
5131: if l_period_name1 is not null then
5132: /*for l_ra_id_pl project level resource_assignment_id*/
5133:
5134: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE1;
5135: /* Bug fix 2891111*/
5136: /* April 07, 2003*/
5137: --Bug 4947912
5138: Begin

Line 5228: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE2;

5224:
5225: if l_period_name2 is not null then
5226: /*for l_ra_id_pl project level resource_assignment_id*/
5227:
5228: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE2;
5229:
5230: /* Bug fix 2891111*/
5231: /* April 07, 2003*/
5232: --Bug 4947912

Line 5326: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE3;

5322:
5323: /* for period 3 */
5324:
5325: if l_period_name3 is not null then
5326: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE3;
5327: /* Bug fix 2891111*/
5328: /* April 07, 2003*/
5329: --Bug 4947912
5330: Begin

Line 5422: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE4;

5418: /* for Period 4 */
5419:
5420:
5421: if l_period_name4 is not null then
5422: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE4;
5423: /* Bug fix 2891111*/
5424: /* April 07, 2003*/
5425: --Bug 4947912
5426: Begin

Line 5523: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE5;

5519: if l_period_name5 is not null then
5520:
5521: /*for l_ra_id_pl project level resource_assignment_id*/
5522:
5523: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE5;
5524: /* Bug fix 2891111*/
5525: /* April 07, 2003*/
5526: --Bug 4947912
5527: Begin

Line 5622: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE6;

5618: if l_period_name6 is not null then
5619:
5620: /*for l_ra_id_pl project level resource_assignment_id*/
5621:
5622: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE6;
5623: /* Bug fix 2891111*/
5624: /* April 07, 2003*/
5625: --Bug 4947912
5626: Begin

Line 5721: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE7;

5717: if l_period_name7 is not null then
5718:
5719: /*for l_ra_id_pl project level resource_assignment_id*/
5720:
5721: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE7;
5722: /* Bug fix 2891111*/
5723: /* April 07, 2003*/
5724: --Bug 4947912
5725: Begin

Line 5815: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE8;

5811: if l_period_name8 is not null then
5812:
5813: /*for l_ra_id_pl project level resource_assignment_id*/
5814:
5815: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE8;
5816: /* Bug fix 2891111*/
5817: /* April 07, 2003*/
5818: --Bug 4947912
5819: Begin

Line 5909: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE9;

5905: end if;
5906: /* for period 9 */
5907:
5908: if l_period_name9 is not null then
5909: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE9;
5910: /* Bug fix 2891111*/
5911: /* April 07, 2003*/
5912: --Bug 4947912
5913: Begin

Line 6003: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE10;

5999: /* for Period 10 */
6000:
6001: if l_period_name10 is not null then
6002:
6003: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE10;
6004: /* Bug fix 2891111*/
6005: /* April 07, 2003*/
6006: --Bug 4947912
6007: Begin

Line 6101: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE11;

6097: if l_period_name11 is not null then
6098:
6099: /*for l_ra_id_pl project level resource_assignment_id*/
6100:
6101: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE11;
6102: /* Bug fix 2891111*/
6103: /* April 07, 2003*/
6104: --Bug 4947912
6105: Begin

Line 6197: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE12;

6193: if l_period_name12 is not null then
6194:
6195: /*for l_ra_id_pl project level resource_assignment_id*/
6196:
6197: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE12;
6198: /* Bug fix 2891111*/
6199: /* April 07, 2003*/
6200: --Bug 4947912
6201: Begin

Line 6293: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE13;

6289: if l_period_name13 is not null then
6290:
6291: /*for l_ra_id_pl project level resource_assignment_id*/
6292:
6293: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE13;
6294: /* Bug fix 2891111*/
6295: /* April 07, 2003*/
6296: --Bug 4947912
6297: Begin

Line 6396: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE1;

6392: /* for period1 */
6393:
6394: if l_period_name1 is not null then
6395:
6396: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE1;
6397: /* Bug fix 2891111*/
6398: /* April 07, 2003*/
6399: --Bug 4947912
6400: Begin

Line 6488: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE2;

6484: if l_period_name2 is not null then
6485:
6486: /*for l_ra_id_pl project level resource_assignment_id*/
6487:
6488: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE2;
6489: /* Bug fix 2891111*/
6490: /* April 07, 2003*/
6491: --Bug 4947912
6492: Begin

Line 6578: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE3;

6574: /* for period 3 */
6575:
6576: if l_period_name3 is not null then
6577:
6578: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE3;
6579: /* Bug fix 2891111*/
6580: /* April 07, 2003*/
6581: --Bug 4947912
6582: Begin

Line 6667: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE4;

6663: /* for Period 4 */
6664:
6665: if l_period_name4 is not null then
6666:
6667: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE4;
6668: /* Bug fix 2891111*/
6669: /* April 07, 2003*/
6670: --Bug 4947912
6671: Begin

Line 6759: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE5;

6755: if l_period_name5 is not null then
6756:
6757: /*for l_ra_id_pl project level resource_assignment_id*/
6758:
6759: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE5;
6760:
6761: /* Bug fix 2891111*/
6762: /* April 07, 2003*/
6763: --Bug 4947912

Line 6851: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE6;

6847: if l_period_name6 is not null then
6848:
6849: /*for l_ra_id_pl project level resource_assignment_id*/
6850:
6851: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE6;
6852: /* Bug fix 2891111*/
6853: /* April 07, 2003*/
6854: --Bug 4947912
6855: Begin

Line 6943: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE7;

6939:
6940: /* for period 7 */
6941:
6942: if l_period_name7 is not null then
6943: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE7;
6944: /* Bug fix 2891111*/
6945: /* April 07, 2003*/
6946: --Bug 4947912
6947: Begin

Line 7035: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE8;

7031: if l_period_name8 is not null then
7032:
7033: /*for l_ra_id_pl project level resource_assignment_id*/
7034:
7035: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE8;
7036: /* Bug fix 2891111*/
7037: /* April 07, 2003*/
7038: --Bug 4947912
7039: Begin

Line 7125: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE9;

7121: /* for period 9 */
7122:
7123: if l_period_name9 is not null then
7124:
7125: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE9;
7126: /* Bug fix 2891111*/
7127: /* April 07, 2003*/
7128: --Bug 4947912
7129: Begin

Line 7214: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE10;

7210: /* for Period 10 */
7211:
7212: if l_period_name10 is not null then
7213:
7214: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE10;
7215: /* Bug fix 2891111*/
7216: /* April 07, 2003*/
7217: --Bug 4947912
7218: Begin

Line 7306: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE11;

7302: if l_period_name11 is not null then
7303:
7304: /*for l_ra_id_pl project level resource_assignment_id*/
7305:
7306: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE11;
7307: /* Bug fix 2891111*/
7308: /* April 07, 2003*/
7309: --Bug 4947912
7310: Begin

Line 7399: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE12;

7395: if l_period_name12 is not null then
7396:
7397: /*for l_ra_id_pl project level resource_assignment_id*/
7398:
7399: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE12;
7400: /* Bug fix 2891111*/
7401: /* April 07, 2003*/
7402: --Bug 4947912
7403: Begin

Line 7491: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE13;

7487: if l_period_name13 is not null then
7488:
7489: /*for l_ra_id_pl project level resource_assignment_id*/
7490:
7491: l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE13;
7492: /* Bug fix 2891111*/
7493: /* April 07, 2003*/
7494: --Bug 4947912
7495: Begin

Line 10455: return pa_fin_plan_view_global.G_FP_VIEW_VERSION_ID;

10451:
10452:
10453: FUNCTION Get_Version_ID return NUMBER is
10454: BEGIN
10455: return pa_fin_plan_view_global.G_FP_VIEW_VERSION_ID;
10456: END Get_Version_ID;
10457:
10458: FUNCTION Get_Org_ID return NUMBER is
10459: BEGIN

Line 10460: return pa_fin_plan_view_global.G_FP_ORG_ID;

10456: END Get_Version_ID;
10457:
10458: FUNCTION Get_Org_ID return NUMBER is
10459: BEGIN
10460: return pa_fin_plan_view_global.G_FP_ORG_ID;
10461: END Get_Org_ID;
10462:
10463: FUNCTION Get_Plan_Type_ID return NUMBER is
10464: BEGIN

Line 10465: return pa_fin_plan_view_global.G_FP_PLAN_TYPE_ID;

10461: END Get_Org_ID;
10462:
10463: FUNCTION Get_Plan_Type_ID return NUMBER is
10464: BEGIN
10465: return pa_fin_plan_view_global.G_FP_PLAN_TYPE_ID;
10466: END Get_Plan_Type_ID;
10467:
10468: FUNCTION Get_Resource_assignment_ID return NUMBER is
10469: BEGIN

Line 10470: return pa_fin_plan_view_global.G_FP_RA_ID;

10466: END Get_Plan_Type_ID;
10467:
10468: FUNCTION Get_Resource_assignment_ID return NUMBER is
10469: BEGIN
10470: return pa_fin_plan_view_global.G_FP_RA_ID;
10471: END Get_Resource_assignment_ID;
10472:
10473: FUNCTION Get_Amount_Type_code return VARCHAR2 is
10474: BEGIN

Line 10475: return pa_fin_plan_view_global.G_FP_AMOUNT_TYPE_CODE;

10471: END Get_Resource_assignment_ID;
10472:
10473: FUNCTION Get_Amount_Type_code return VARCHAR2 is
10474: BEGIN
10475: return pa_fin_plan_view_global.G_FP_AMOUNT_TYPE_CODE;
10476: END Get_Amount_Type_code;
10477:
10478: FUNCTION Get_Adj_Reason_Code return VARCHAR2 is
10479: BEGIN

Line 10480: return pa_fin_plan_view_global.G_FP_ADJ_REASON_CODE;

10476: END Get_Amount_Type_code;
10477:
10478: FUNCTION Get_Adj_Reason_Code return VARCHAR2 is
10479: BEGIN
10480: return pa_fin_plan_view_global.G_FP_ADJ_REASON_CODE;
10481: END Get_Adj_Reason_Code;
10482:
10483: FUNCTION Get_Period_Start_Date1 return Date is
10484: BEGIN

Line 10485: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE1;

10481: END Get_Adj_Reason_Code;
10482:
10483: FUNCTION Get_Period_Start_Date1 return Date is
10484: BEGIN
10485: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE1;
10486: END Get_Period_Start_Date1;
10487:
10488: FUNCTION Get_Period_Start_Date2 return Date is
10489: BEGIN

Line 10490: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE2;

10486: END Get_Period_Start_Date1;
10487:
10488: FUNCTION Get_Period_Start_Date2 return Date is
10489: BEGIN
10490: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE2;
10491: END Get_Period_Start_Date2;
10492:
10493: FUNCTION Get_Period_Start_Date3 return Date is
10494: BEGIN

Line 10495: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE3;

10491: END Get_Period_Start_Date2;
10492:
10493: FUNCTION Get_Period_Start_Date3 return Date is
10494: BEGIN
10495: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE3;
10496: END Get_Period_Start_Date3;
10497:
10498: FUNCTION Get_Period_Start_Date4 return Date is
10499: BEGIN

Line 10500: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE4;

10496: END Get_Period_Start_Date3;
10497:
10498: FUNCTION Get_Period_Start_Date4 return Date is
10499: BEGIN
10500: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE4;
10501: END Get_Period_Start_Date4;
10502:
10503: FUNCTION Get_Period_Start_Date5 return Date is
10504: BEGIN

Line 10505: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE5;

10501: END Get_Period_Start_Date4;
10502:
10503: FUNCTION Get_Period_Start_Date5 return Date is
10504: BEGIN
10505: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE5;
10506: END Get_Period_Start_Date5;
10507:
10508: FUNCTION Get_Period_Start_Date6 return Date is
10509: BEGIN

Line 10510: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE6;

10506: END Get_Period_Start_Date5;
10507:
10508: FUNCTION Get_Period_Start_Date6 return Date is
10509: BEGIN
10510: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE6;
10511: END Get_Period_Start_Date6;
10512:
10513: FUNCTION Get_Period_Start_Date7 return Date is
10514: BEGIN

Line 10515: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE7;

10511: END Get_Period_Start_Date6;
10512:
10513: FUNCTION Get_Period_Start_Date7 return Date is
10514: BEGIN
10515: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE7;
10516: END Get_Period_Start_Date7;
10517:
10518: FUNCTION Get_Period_Start_Date8 return Date is
10519: BEGIN

Line 10520: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE8;

10516: END Get_Period_Start_Date7;
10517:
10518: FUNCTION Get_Period_Start_Date8 return Date is
10519: BEGIN
10520: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE8;
10521: END Get_Period_Start_Date8;
10522:
10523: FUNCTION Get_Period_Start_Date9 return Date is
10524: BEGIN

Line 10525: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE9;

10521: END Get_Period_Start_Date8;
10522:
10523: FUNCTION Get_Period_Start_Date9 return Date is
10524: BEGIN
10525: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE9;
10526: END Get_Period_Start_Date9;
10527:
10528: FUNCTION Get_Period_Start_Date10 return Date is
10529: BEGIN

Line 10530: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE10;

10526: END Get_Period_Start_Date9;
10527:
10528: FUNCTION Get_Period_Start_Date10 return Date is
10529: BEGIN
10530: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE10;
10531: END Get_Period_Start_Date10;
10532:
10533: FUNCTION Get_Period_Start_Date11 return Date is
10534: BEGIN

Line 10535: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE11;

10531: END Get_Period_Start_Date10;
10532:
10533: FUNCTION Get_Period_Start_Date11 return Date is
10534: BEGIN
10535: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE11;
10536: END Get_Period_Start_Date11;
10537:
10538: FUNCTION Get_Period_Start_Date12 return Date is
10539: BEGIN

Line 10540: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE12;

10536: END Get_Period_Start_Date11;
10537:
10538: FUNCTION Get_Period_Start_Date12 return Date is
10539: BEGIN
10540: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE12;
10541: END Get_Period_Start_Date12;
10542:
10543:
10544: FUNCTION Get_Period_Start_Date13 return Date is

Line 10546: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE13;

10542:
10543:
10544: FUNCTION Get_Period_Start_Date13 return Date is
10545: BEGIN
10546: return pa_fin_plan_view_global.G_FP_VIEW_START_DATE13;
10547: END Get_Period_Start_Date13;
10548:
10549: FUNCTION Get_Plan_Start_Date return Date is
10550: BEGIN

Line 10551: return pa_fin_plan_view_global.G_FP_PLAN_START_DATE;

10547: END Get_Period_Start_Date13;
10548:
10549: FUNCTION Get_Plan_Start_Date return Date is
10550: BEGIN
10551: return pa_fin_plan_view_global.G_FP_PLAN_START_DATE;
10552: END Get_Plan_Start_Date;
10553:
10554: FUNCTION Get_Plan_End_Date return Date is
10555: BEGIN

Line 10556: return pa_fin_plan_view_global.G_FP_PLAN_END_DATE;

10552: END Get_Plan_Start_Date;
10553:
10554: FUNCTION Get_Plan_End_Date return Date is
10555: BEGIN
10556: return pa_fin_plan_view_global.G_FP_PLAN_END_DATE;
10557: END Get_Plan_End_Date;
10558:
10559: FUNCTION Get_Currency_Code return VARCHAR2 is
10560: BEGIN

Line 10561: return pa_fin_plan_view_global.G_FP_CURRENCY_CODE;

10557: END Get_Plan_End_Date;
10558:
10559: FUNCTION Get_Currency_Code return VARCHAR2 is
10560: BEGIN
10561: return pa_fin_plan_view_global.G_FP_CURRENCY_CODE;
10562: END Get_Currency_Code;
10563:
10564: FUNCTION Get_Currency_Type return VARCHAR2 is
10565: BEGIN

Line 10566: return pa_fin_plan_view_global.G_FP_CURRENCY_TYPE;

10562: END Get_Currency_Code;
10563:
10564: FUNCTION Get_Currency_Type return VARCHAR2 is
10565: BEGIN
10566: return pa_fin_plan_view_global.G_FP_CURRENCY_TYPE;
10567: END Get_Currency_Type;
10568:
10569:
10570:

Line 10572: END pa_fin_plan_view_global;

10568:
10569:
10570:
10571:
10572: END pa_fin_plan_view_global;