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_COPY_FROM_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 31: pa_proj_fp_options.proj_fp_options_id%TYPE INDEX BY BINARY_INTEGER;

27:
28: TYPE l_end_date_tbl_typ IS TABLE OF DATE INDEX BY BINARY_INTEGER;
29:
30: TYPE proj_fp_options_id_tbl_typ IS TABLE OF
31: pa_proj_fp_options.proj_fp_options_id%TYPE INDEX BY BINARY_INTEGER;
32:
33: /* PL/SQL table type declaration */
34:
35: TYPE FP_OPTIONS_COLS IS RECORD (

Line 36: proj_fp_options_id PA_PROJ_FP_OPTIONS.proj_fp_options_id%type

32:
33: /* PL/SQL table type declaration */
34:
35: TYPE FP_OPTIONS_COLS IS RECORD (
36: proj_fp_options_id PA_PROJ_FP_OPTIONS.proj_fp_options_id%type
37: ,project_id PA_PROJ_FP_OPTIONS.project_id%type
38: ,fin_plan_type_id PA_PROJ_FP_OPTIONS.fin_plan_type_id%type
39: ,version_type VARCHAR2(30)
40: ,planning_level PA_PROJ_FP_OPTIONS.cost_fin_plan_level_code%type

Line 37: ,project_id PA_PROJ_FP_OPTIONS.project_id%type

33: /* PL/SQL table type declaration */
34:
35: TYPE FP_OPTIONS_COLS IS RECORD (
36: proj_fp_options_id PA_PROJ_FP_OPTIONS.proj_fp_options_id%type
37: ,project_id PA_PROJ_FP_OPTIONS.project_id%type
38: ,fin_plan_type_id PA_PROJ_FP_OPTIONS.fin_plan_type_id%type
39: ,version_type VARCHAR2(30)
40: ,planning_level PA_PROJ_FP_OPTIONS.cost_fin_plan_level_code%type
41: ,resource_list_id PA_PROJ_FP_OPTIONS.cost_resource_list_id%type

Line 38: ,fin_plan_type_id PA_PROJ_FP_OPTIONS.fin_plan_type_id%type

34:
35: TYPE FP_OPTIONS_COLS IS RECORD (
36: proj_fp_options_id PA_PROJ_FP_OPTIONS.proj_fp_options_id%type
37: ,project_id PA_PROJ_FP_OPTIONS.project_id%type
38: ,fin_plan_type_id PA_PROJ_FP_OPTIONS.fin_plan_type_id%type
39: ,version_type VARCHAR2(30)
40: ,planning_level PA_PROJ_FP_OPTIONS.cost_fin_plan_level_code%type
41: ,resource_list_id PA_PROJ_FP_OPTIONS.cost_resource_list_id%type
42: ,time_phased_code PA_PROJ_FP_OPTIONS.cost_time_phased_code%type

Line 40: ,planning_level PA_PROJ_FP_OPTIONS.cost_fin_plan_level_code%type

36: proj_fp_options_id PA_PROJ_FP_OPTIONS.proj_fp_options_id%type
37: ,project_id PA_PROJ_FP_OPTIONS.project_id%type
38: ,fin_plan_type_id PA_PROJ_FP_OPTIONS.fin_plan_type_id%type
39: ,version_type VARCHAR2(30)
40: ,planning_level PA_PROJ_FP_OPTIONS.cost_fin_plan_level_code%type
41: ,resource_list_id PA_PROJ_FP_OPTIONS.cost_resource_list_id%type
42: ,time_phased_code PA_PROJ_FP_OPTIONS.cost_time_phased_code%type
43: ,amount_set_id PA_PROJ_FP_OPTIONS.cost_amount_set_id%type
44: ,projfunc_cost_rate_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_type%type

Line 41: ,resource_list_id PA_PROJ_FP_OPTIONS.cost_resource_list_id%type

37: ,project_id PA_PROJ_FP_OPTIONS.project_id%type
38: ,fin_plan_type_id PA_PROJ_FP_OPTIONS.fin_plan_type_id%type
39: ,version_type VARCHAR2(30)
40: ,planning_level PA_PROJ_FP_OPTIONS.cost_fin_plan_level_code%type
41: ,resource_list_id PA_PROJ_FP_OPTIONS.cost_resource_list_id%type
42: ,time_phased_code PA_PROJ_FP_OPTIONS.cost_time_phased_code%type
43: ,amount_set_id PA_PROJ_FP_OPTIONS.cost_amount_set_id%type
44: ,projfunc_cost_rate_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_type%type
45: ,projfunc_cost_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date_type%type

Line 42: ,time_phased_code PA_PROJ_FP_OPTIONS.cost_time_phased_code%type

38: ,fin_plan_type_id PA_PROJ_FP_OPTIONS.fin_plan_type_id%type
39: ,version_type VARCHAR2(30)
40: ,planning_level PA_PROJ_FP_OPTIONS.cost_fin_plan_level_code%type
41: ,resource_list_id PA_PROJ_FP_OPTIONS.cost_resource_list_id%type
42: ,time_phased_code PA_PROJ_FP_OPTIONS.cost_time_phased_code%type
43: ,amount_set_id PA_PROJ_FP_OPTIONS.cost_amount_set_id%type
44: ,projfunc_cost_rate_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_type%type
45: ,projfunc_cost_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date_type%type
46: ,projfunc_cost_rate_date PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date%type

Line 43: ,amount_set_id PA_PROJ_FP_OPTIONS.cost_amount_set_id%type

39: ,version_type VARCHAR2(30)
40: ,planning_level PA_PROJ_FP_OPTIONS.cost_fin_plan_level_code%type
41: ,resource_list_id PA_PROJ_FP_OPTIONS.cost_resource_list_id%type
42: ,time_phased_code PA_PROJ_FP_OPTIONS.cost_time_phased_code%type
43: ,amount_set_id PA_PROJ_FP_OPTIONS.cost_amount_set_id%type
44: ,projfunc_cost_rate_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_type%type
45: ,projfunc_cost_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date_type%type
46: ,projfunc_cost_rate_date PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date%type
47: ,projfunc_rev_rate_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_type%type

Line 44: ,projfunc_cost_rate_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_type%type

40: ,planning_level PA_PROJ_FP_OPTIONS.cost_fin_plan_level_code%type
41: ,resource_list_id PA_PROJ_FP_OPTIONS.cost_resource_list_id%type
42: ,time_phased_code PA_PROJ_FP_OPTIONS.cost_time_phased_code%type
43: ,amount_set_id PA_PROJ_FP_OPTIONS.cost_amount_set_id%type
44: ,projfunc_cost_rate_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_type%type
45: ,projfunc_cost_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date_type%type
46: ,projfunc_cost_rate_date PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date%type
47: ,projfunc_rev_rate_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_type%type
48: ,projfunc_rev_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date_type%type

Line 45: ,projfunc_cost_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date_type%type

41: ,resource_list_id PA_PROJ_FP_OPTIONS.cost_resource_list_id%type
42: ,time_phased_code PA_PROJ_FP_OPTIONS.cost_time_phased_code%type
43: ,amount_set_id PA_PROJ_FP_OPTIONS.cost_amount_set_id%type
44: ,projfunc_cost_rate_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_type%type
45: ,projfunc_cost_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date_type%type
46: ,projfunc_cost_rate_date PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date%type
47: ,projfunc_rev_rate_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_type%type
48: ,projfunc_rev_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date_type%type
49: ,projfunc_rev_rate_date PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date%type

Line 46: ,projfunc_cost_rate_date PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date%type

42: ,time_phased_code PA_PROJ_FP_OPTIONS.cost_time_phased_code%type
43: ,amount_set_id PA_PROJ_FP_OPTIONS.cost_amount_set_id%type
44: ,projfunc_cost_rate_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_type%type
45: ,projfunc_cost_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date_type%type
46: ,projfunc_cost_rate_date PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date%type
47: ,projfunc_rev_rate_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_type%type
48: ,projfunc_rev_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date_type%type
49: ,projfunc_rev_rate_date PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date%type
50: ,project_cost_rate_type PA_PROJ_FP_OPTIONS.project_cost_rate_type%type

Line 47: ,projfunc_rev_rate_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_type%type

43: ,amount_set_id PA_PROJ_FP_OPTIONS.cost_amount_set_id%type
44: ,projfunc_cost_rate_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_type%type
45: ,projfunc_cost_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date_type%type
46: ,projfunc_cost_rate_date PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date%type
47: ,projfunc_rev_rate_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_type%type
48: ,projfunc_rev_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date_type%type
49: ,projfunc_rev_rate_date PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date%type
50: ,project_cost_rate_type PA_PROJ_FP_OPTIONS.project_cost_rate_type%type
51: ,project_cost_rate_date_type PA_PROJ_FP_OPTIONS.project_cost_rate_date_type%type

Line 48: ,projfunc_rev_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date_type%type

44: ,projfunc_cost_rate_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_type%type
45: ,projfunc_cost_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date_type%type
46: ,projfunc_cost_rate_date PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date%type
47: ,projfunc_rev_rate_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_type%type
48: ,projfunc_rev_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date_type%type
49: ,projfunc_rev_rate_date PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date%type
50: ,project_cost_rate_type PA_PROJ_FP_OPTIONS.project_cost_rate_type%type
51: ,project_cost_rate_date_type PA_PROJ_FP_OPTIONS.project_cost_rate_date_type%type
52: ,project_cost_rate_date PA_PROJ_FP_OPTIONS.project_cost_rate_date%type

Line 49: ,projfunc_rev_rate_date PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date%type

45: ,projfunc_cost_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date_type%type
46: ,projfunc_cost_rate_date PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date%type
47: ,projfunc_rev_rate_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_type%type
48: ,projfunc_rev_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date_type%type
49: ,projfunc_rev_rate_date PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date%type
50: ,project_cost_rate_type PA_PROJ_FP_OPTIONS.project_cost_rate_type%type
51: ,project_cost_rate_date_type PA_PROJ_FP_OPTIONS.project_cost_rate_date_type%type
52: ,project_cost_rate_date PA_PROJ_FP_OPTIONS.project_cost_rate_date%type
53: ,project_rev_rate_type PA_PROJ_FP_OPTIONS.project_rev_rate_type%type

Line 50: ,project_cost_rate_type PA_PROJ_FP_OPTIONS.project_cost_rate_type%type

46: ,projfunc_cost_rate_date PA_PROJ_FP_OPTIONS.projfunc_cost_rate_date%type
47: ,projfunc_rev_rate_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_type%type
48: ,projfunc_rev_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date_type%type
49: ,projfunc_rev_rate_date PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date%type
50: ,project_cost_rate_type PA_PROJ_FP_OPTIONS.project_cost_rate_type%type
51: ,project_cost_rate_date_type PA_PROJ_FP_OPTIONS.project_cost_rate_date_type%type
52: ,project_cost_rate_date PA_PROJ_FP_OPTIONS.project_cost_rate_date%type
53: ,project_rev_rate_type PA_PROJ_FP_OPTIONS.project_rev_rate_type%type
54: ,project_rev_rate_date_type PA_PROJ_FP_OPTIONS.project_rev_rate_date_type%type

Line 51: ,project_cost_rate_date_type PA_PROJ_FP_OPTIONS.project_cost_rate_date_type%type

47: ,projfunc_rev_rate_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_type%type
48: ,projfunc_rev_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date_type%type
49: ,projfunc_rev_rate_date PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date%type
50: ,project_cost_rate_type PA_PROJ_FP_OPTIONS.project_cost_rate_type%type
51: ,project_cost_rate_date_type PA_PROJ_FP_OPTIONS.project_cost_rate_date_type%type
52: ,project_cost_rate_date PA_PROJ_FP_OPTIONS.project_cost_rate_date%type
53: ,project_rev_rate_type PA_PROJ_FP_OPTIONS.project_rev_rate_type%type
54: ,project_rev_rate_date_type PA_PROJ_FP_OPTIONS.project_rev_rate_date_type%type
55: ,project_rev_rate_date PA_PROJ_FP_OPTIONS.project_rev_rate_date%type

Line 52: ,project_cost_rate_date PA_PROJ_FP_OPTIONS.project_cost_rate_date%type

48: ,projfunc_rev_rate_date_type PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date_type%type
49: ,projfunc_rev_rate_date PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date%type
50: ,project_cost_rate_type PA_PROJ_FP_OPTIONS.project_cost_rate_type%type
51: ,project_cost_rate_date_type PA_PROJ_FP_OPTIONS.project_cost_rate_date_type%type
52: ,project_cost_rate_date PA_PROJ_FP_OPTIONS.project_cost_rate_date%type
53: ,project_rev_rate_type PA_PROJ_FP_OPTIONS.project_rev_rate_type%type
54: ,project_rev_rate_date_type PA_PROJ_FP_OPTIONS.project_rev_rate_date_type%type
55: ,project_rev_rate_date PA_PROJ_FP_OPTIONS.project_rev_rate_date%type
56: ,raw_cost_flag PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%type

Line 53: ,project_rev_rate_type PA_PROJ_FP_OPTIONS.project_rev_rate_type%type

49: ,projfunc_rev_rate_date PA_PROJ_FP_OPTIONS.projfunc_rev_rate_date%type
50: ,project_cost_rate_type PA_PROJ_FP_OPTIONS.project_cost_rate_type%type
51: ,project_cost_rate_date_type PA_PROJ_FP_OPTIONS.project_cost_rate_date_type%type
52: ,project_cost_rate_date PA_PROJ_FP_OPTIONS.project_cost_rate_date%type
53: ,project_rev_rate_type PA_PROJ_FP_OPTIONS.project_rev_rate_type%type
54: ,project_rev_rate_date_type PA_PROJ_FP_OPTIONS.project_rev_rate_date_type%type
55: ,project_rev_rate_date PA_PROJ_FP_OPTIONS.project_rev_rate_date%type
56: ,raw_cost_flag PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%type
57: ,burdened_cost_flag PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%type

Line 54: ,project_rev_rate_date_type PA_PROJ_FP_OPTIONS.project_rev_rate_date_type%type

50: ,project_cost_rate_type PA_PROJ_FP_OPTIONS.project_cost_rate_type%type
51: ,project_cost_rate_date_type PA_PROJ_FP_OPTIONS.project_cost_rate_date_type%type
52: ,project_cost_rate_date PA_PROJ_FP_OPTIONS.project_cost_rate_date%type
53: ,project_rev_rate_type PA_PROJ_FP_OPTIONS.project_rev_rate_type%type
54: ,project_rev_rate_date_type PA_PROJ_FP_OPTIONS.project_rev_rate_date_type%type
55: ,project_rev_rate_date PA_PROJ_FP_OPTIONS.project_rev_rate_date%type
56: ,raw_cost_flag PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%type
57: ,burdened_cost_flag PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%type
58: ,revenue_flag PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%type

Line 55: ,project_rev_rate_date PA_PROJ_FP_OPTIONS.project_rev_rate_date%type

51: ,project_cost_rate_date_type PA_PROJ_FP_OPTIONS.project_cost_rate_date_type%type
52: ,project_cost_rate_date PA_PROJ_FP_OPTIONS.project_cost_rate_date%type
53: ,project_rev_rate_type PA_PROJ_FP_OPTIONS.project_rev_rate_type%type
54: ,project_rev_rate_date_type PA_PROJ_FP_OPTIONS.project_rev_rate_date_type%type
55: ,project_rev_rate_date PA_PROJ_FP_OPTIONS.project_rev_rate_date%type
56: ,raw_cost_flag PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%type
57: ,burdened_cost_flag PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%type
58: ,revenue_flag PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%type
59: ,quantity_flag PA_FIN_PLAN_AMOUNT_SETS.revenue_qty_flag%type

Line 267: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE

263: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
264: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
265:
266: PROCEDURE Acquire_Locks_For_Copy_Actual(
267: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
268: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
269: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
270: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
271:

Line 298: (pa_proj_fp_options)

294: the budgets related data from source published version.
295: Synchronisation involves:
296: 1) pa_fp_txn_currencies
297: 2) rate schedules, generation options and plan settings data
298: (pa_proj_fp_options)
299:
300: Stating some of the business rules for clarity:
301: i) If there is a published version, time phasing can not be changed
302: ii) Planning resource list can change only if existing resource list is