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_FP_EXCLUDED_ELEMENTS_PUB dependencies on PA_FP_EXCLUDED_ELEMENTS

Line 1: PACKAGE BODY pa_fp_excluded_elements_pub as

1: PACKAGE BODY pa_fp_excluded_elements_pub as
2: /* $Header: PAFPXEPB.pls 120.1 2005/08/19 16:32:15 mwasowic noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_FP_EXCLUDED_ELEMENTS_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'PAFPXEPB.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_FP_EXCLUDED_ELEMENTS_PUB';

1: PACKAGE BODY pa_fp_excluded_elements_pub as
2: /* $Header: PAFPXEPB.pls 120.1 2005/08/19 16:32:15 mwasowic noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_FP_EXCLUDED_ELEMENTS_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'PAFPXEPB.pls';
6:
7: --This api will creates record for p_to_proj_fp_options_id in pa_fp_excluded_elements copying
8: --them from those of p_from_proj_fp_options_id. If the project ids are different for the two

Line 7: --This api will creates record for p_to_proj_fp_options_id in pa_fp_excluded_elements copying

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_FP_EXCLUDED_ELEMENTS_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'PAFPXEPB.pls';
6:
7: --This api will creates record for p_to_proj_fp_options_id in pa_fp_excluded_elements copying
8: --them from those of p_from_proj_fp_options_id. If the project ids are different for the two
9: --options the records are mapped based on task numbers.
10: PROCEDURE Copy_Excluded_Elements
11: ( p_from_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

Line 123: INSERT INTO pa_fp_excluded_elements

119: pa_debug.g_err_stage:= 'project ids are same. inserting into excluded elements';
120: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
121: END IF;
122:
123: INSERT INTO pa_fp_excluded_elements
124: ( proj_fp_options_id
125: ,project_id
126: ,fin_plan_type_id
127: ,element_type

Line 151: pa_fp_excluded_elements ee

147: ,sysdate creation_date
148: ,fnd_global.user_id created_by
149: ,fnd_global.login_id last_update_login
150: FROM
151: pa_fp_excluded_elements ee
152: WHERE ee.proj_fp_options_id = p_from_proj_fp_options_id
153: AND ee.element_type = DECODE( p_from_element_type,
154: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,ee.element_type,
155: p_from_element_type);

Line 164: INSERT INTO pa_fp_excluded_elements

160: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
161: END IF;
162:
163: --Map the tasks from source to project using the task number.
164: INSERT INTO pa_fp_excluded_elements
165: ( proj_fp_options_id
166: ,project_id
167: ,fin_plan_type_id
168: ,element_type

Line 191: FROM pa_fp_excluded_elements ee,

187: ,fnd_global.user_id last_updated_by
188: ,sysdate creation_date
189: ,fnd_global.user_id created_by
190: ,fnd_global.login_id last_update_login
191: FROM pa_fp_excluded_elements ee,
192: pa_tasks source_pt,
193: pa_tasks target_pt
194: WHERE proj_fp_options_id = p_from_proj_fp_options_id
195: AND target_pt.project_id = l_to_fp_option_info_rec.project_id

Line 256: while copying actuals etc., from pa_fp_excluded_elements.

252: END Copy_Excluded_Elements;
253:
254: /*==================================================================
255: This api is called to delete all the tasks that are made plannable
256: while copying actuals etc., from pa_fp_excluded_elements.
257: ==================================================================*/
258:
259: PROCEDURE Synchronize_Excluded_Elements
260: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

Line 309: * pa_fp_excluded_elements

305: END IF;
306:
307: /*
308: * Delete all the tasks that are made plannable from
309: * pa_fp_excluded_elements
310: * Note: Please note that
311: */
312: DELETE FROM pa_fp_excluded_elements fee
313: WHERE fee.proj_fp_options_id = p_proj_fp_options_id

Line 312: DELETE FROM pa_fp_excluded_elements fee

308: * Delete all the tasks that are made plannable from
309: * pa_fp_excluded_elements
310: * Note: Please note that
311: */
312: DELETE FROM pa_fp_excluded_elements fee
313: WHERE fee.proj_fp_options_id = p_proj_fp_options_id
314: AND fee.element_type = p_element_type
315: AND fee.task_id IN (SELECT pfe.task_id
316: FROM pa_fp_elements pfe

Line 361: /* Called from setup pages to delete from pa_fp_excluded_elements when a task element is

357: pa_debug.reset_curr_function;
358: RAISE;
359: END Synchronize_Excluded_Elements;
360:
361: /* Called from setup pages to delete from pa_fp_excluded_elements when a task element is
362: made plannable. If the task element is not present in pa_fp_excluded_elements, the
363: delete_Row table handler is not called */
364:
365: PROCEDURE Delete_Excluded_Elements

Line 362: made plannable. If the task element is not present in pa_fp_excluded_elements, the

358: RAISE;
359: END Synchronize_Excluded_Elements;
360:
361: /* Called from setup pages to delete from pa_fp_excluded_elements when a task element is
362: made plannable. If the task element is not present in pa_fp_excluded_elements, the
363: delete_Row table handler is not called */
364:
365: PROCEDURE Delete_Excluded_Elements
366: ( p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE

Line 366: ( p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE

362: made plannable. If the task element is not present in pa_fp_excluded_elements, the
363: delete_Row table handler is not called */
364:
365: PROCEDURE Delete_Excluded_Elements
366: ( p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE
367: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE
368: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE
369: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
370: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 367: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE

363: delete_Row table handler is not called */
364:
365: PROCEDURE Delete_Excluded_Elements
366: ( p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE
367: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE
368: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE
369: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
370: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
371: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 368: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE

364:
365: PROCEDURE Delete_Excluded_Elements
366: ( p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE
367: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE
368: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE
369: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
370: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
371: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
372: AS

Line 384: L_PROCEDURE_NAME CONSTANT VARCHAR2(100) := 'Pa_Fp_Excluded_Elements_Pkg.Delete_Excluded_Elements';

380: L_DEBUG_LEVEL2 CONSTANT NUMBER := 2;
381: L_DEBUG_LEVEL3 CONSTANT NUMBER := 3;
382: L_DEBUG_LEVEL4 CONSTANT NUMBER := 4;
383: L_DEBUG_LEVEL5 CONSTANT NUMBER := 5;
384: L_PROCEDURE_NAME CONSTANT VARCHAR2(100) := 'Pa_Fp_Excluded_Elements_Pkg.Delete_Excluded_Elements';
385:
386: CURSOR cur_excl_elems IS
387: SELECT rowid
388: FROM pa_fp_excluded_elements

Line 388: FROM pa_fp_excluded_elements

384: L_PROCEDURE_NAME CONSTANT VARCHAR2(100) := 'Pa_Fp_Excluded_Elements_Pkg.Delete_Excluded_Elements';
385:
386: CURSOR cur_excl_elems IS
387: SELECT rowid
388: FROM pa_fp_excluded_elements
389: WHERE proj_fp_options_id = p_proj_fp_options_id
390: AND element_type = p_element_type
391: AND task_id = p_task_id;
392:

Line 444: pa_debug.g_err_stage:= 'Calling PA_FP_EXCLUDED_ELEMENTS_PKG.DELETE_ROW...';

440:
441: IF cur_excl_elems%FOUND THEN
442:
443: IF l_debug_mode = 'Y' THEN
444: pa_debug.g_err_stage:= 'Calling PA_FP_EXCLUDED_ELEMENTS_PKG.DELETE_ROW...';
445: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,
446: L_DEBUG_LEVEL3);
447: END IF;
448:

Line 449: PA_FP_EXCLUDED_ELEMENTS_PKG.DELETE_ROW(

445: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,
446: L_DEBUG_LEVEL3);
447: END IF;
448:
449: PA_FP_EXCLUDED_ELEMENTS_PKG.DELETE_ROW(
450: p_row_id => excl_elems_rec.rowid,
451: x_return_status => x_return_status);
452:
453: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 455: pa_debug.g_err_stage:= 'Error returned by PA_FP_EXCLUDED_ELEMENTS_PKG.DELETE_ROW';

451: x_return_status => x_return_status);
452:
453: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
454: IF l_debug_mode = 'Y' THEN
455: pa_debug.g_err_stage:= 'Error returned by PA_FP_EXCLUDED_ELEMENTS_PKG.DELETE_ROW';
456: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,
457: L_DEBUG_LEVEL5);
458: END IF;
459: CLOSE cur_excl_elems;

Line 514: ( p_pkg_name => 'pa_fp_excluded_elements_pub'

510: CLOSE cur_excl_elems;
511: END IF;
512:
513: FND_MSG_PUB.add_exc_msg
514: ( p_pkg_name => 'pa_fp_excluded_elements_pub'
515: ,p_procedure_name => 'Delete_Excluded_Elements'
516: ,p_error_text => x_msg_data);
517:
518: IF l_debug_mode = 'Y' THEN

Line 527: END pa_fp_excluded_elements_pub;

523: END IF;
524: RAISE;
525: END Delete_Excluded_Elements;
526:
527: END pa_fp_excluded_elements_pub;