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_PUB dependencies on PA_BUDGET_VERSIONS

Line 36: p_project_id IN pa_budget_versions.project_id%TYPE,

32:
33: --Bug 3964755. Introduced the parameter p_calling_context. Valid values are NULL and 'COPY_PROJECT'
34: procedure Submit_Current_Working
35: (p_calling_context IN VARCHAR2 DEFAULT NULL,
36: p_project_id IN pa_budget_versions.project_id%TYPE,
37: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
38: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
39: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
40: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 37: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

33: --Bug 3964755. Introduced the parameter p_calling_context. Valid values are NULL and 'COPY_PROJECT'
34: procedure Submit_Current_Working
35: (p_calling_context IN VARCHAR2 DEFAULT NULL,
36: p_project_id IN pa_budget_versions.project_id%TYPE,
37: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
38: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
39: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
40: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
41: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 38: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

34: procedure Submit_Current_Working
35: (p_calling_context IN VARCHAR2 DEFAULT NULL,
36: p_project_id IN pa_budget_versions.project_id%TYPE,
37: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
38: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
39: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
40: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
41: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
42:

Line 44: (p_project_id IN pa_budget_versions.project_id%TYPE,

40: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
41: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
42:
43: procedure Set_Current_Working
44: (p_project_id IN pa_budget_versions.project_id%TYPE,
45: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
46: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
47: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
48: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,

Line 45: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

41: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
42:
43: procedure Set_Current_Working
44: (p_project_id IN pa_budget_versions.project_id%TYPE,
45: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
46: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
47: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
48: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
49: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 46: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

42:
43: procedure Set_Current_Working
44: (p_project_id IN pa_budget_versions.project_id%TYPE,
45: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
46: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
47: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
48: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
49: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
50: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 47: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

43: procedure Set_Current_Working
44: (p_project_id IN pa_budget_versions.project_id%TYPE,
45: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
46: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
47: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
48: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
49: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
50: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
51: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 48: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,

44: (p_project_id IN pa_budget_versions.project_id%TYPE,
45: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
46: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
47: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
48: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
49: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
50: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
51: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
52:

Line 54: (p_project_id IN pa_budget_versions.project_id%TYPE,

50: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
51: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
52:
53: procedure Rework_Submitted
54: (p_project_id IN pa_budget_versions.project_id%TYPE,
55: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
56: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
57: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
58: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 55: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

51: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
52:
53: procedure Rework_Submitted
54: (p_project_id IN pa_budget_versions.project_id%TYPE,
55: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
56: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
57: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
58: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
59: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 56: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

52:
53: procedure Rework_Submitted
54: (p_project_id IN pa_budget_versions.project_id%TYPE,
55: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
56: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
57: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
58: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
59: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
60:

Line 62: (p_project_id IN pa_budget_versions.project_id%TYPE,

58: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
59: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
60:
61: procedure Mark_As_Original
62: (p_project_id IN pa_budget_versions.project_id%TYPE,
63: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
64: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
65: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
66: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,

Line 63: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

59: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
60:
61: procedure Mark_As_Original
62: (p_project_id IN pa_budget_versions.project_id%TYPE,
63: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
64: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
65: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
66: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
67: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 64: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

60:
61: procedure Mark_As_Original
62: (p_project_id IN pa_budget_versions.project_id%TYPE,
63: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
64: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
65: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
66: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
67: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
68: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 65: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

61: procedure Mark_As_Original
62: (p_project_id IN pa_budget_versions.project_id%TYPE,
63: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
64: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
65: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
66: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
67: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
68: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
69: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 66: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,

62: (p_project_id IN pa_budget_versions.project_id%TYPE,
63: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
64: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
65: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
66: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
67: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
68: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
69: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
70:

Line 72: (p_project_id IN pa_budget_versions.project_id%TYPE,

68: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
69: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
70:
71: procedure Delete_Version
72: (p_project_id IN pa_budget_versions.project_id%TYPE,
73: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
74: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
75: p_context IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET,
76: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 73: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

69: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
70:
71: procedure Delete_Version
72: (p_project_id IN pa_budget_versions.project_id%TYPE,
73: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
74: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
75: p_context IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET,
76: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
77: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 74: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

70:
71: procedure Delete_Version
72: (p_project_id IN pa_budget_versions.project_id%TYPE,
73: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
74: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
75: p_context IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET,
76: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
77: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
78: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 87: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

83: --is passed. Otherwise when p_project_id is passed data for the entire project will be deleted.
84: procedure Delete_Version_Helper
85: (p_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL,
86: p_context IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET,
87: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
88: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
89: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
90: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
91:

Line 94: (p_project_id IN pa_budget_versions.project_id%TYPE,

90: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
91:
92: /* added ... for financial planning copy from needs */
93: procedure Copy_Version
94: (p_project_id IN pa_budget_versions.project_id%TYPE,
95: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
96: p_copy_mode IN VARCHAR2,
97: p_adj_percentage IN NUMBER DEFAULT 0,
98: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,

Line 95: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,

91:
92: /* added ... for financial planning copy from needs */
93: procedure Copy_Version
94: (p_project_id IN pa_budget_versions.project_id%TYPE,
95: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
96: p_copy_mode IN VARCHAR2,
97: p_adj_percentage IN NUMBER DEFAULT 0,
98: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,
99: p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y', --Bug 4200168

Line 100: px_target_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

96: p_copy_mode IN VARCHAR2,
97: p_adj_percentage IN NUMBER DEFAULT 0,
98: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,
99: p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y', --Bug 4200168
100: px_target_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
101: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
102: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
103: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
104:

Line 107: (p_project_id IN pa_budget_versions.project_id%TYPE,

103: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
104:
105:
106: procedure Baseline
107: (p_project_id IN pa_budget_versions.project_id%TYPE,
108: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
109: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
110: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
111: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,

Line 108: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

104:
105:
106: procedure Baseline
107: (p_project_id IN pa_budget_versions.project_id%TYPE,
108: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
109: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
110: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
111: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
112: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 109: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

105:
106: procedure Baseline
107: (p_project_id IN pa_budget_versions.project_id%TYPE,
108: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
109: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
110: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
111: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
112: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
113: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 110: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

106: procedure Baseline
107: (p_project_id IN pa_budget_versions.project_id%TYPE,
108: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
109: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
110: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
111: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
112: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
113: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
114: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 111: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,

107: (p_project_id IN pa_budget_versions.project_id%TYPE,
108: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
109: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
110: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
111: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
112: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
113: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
114: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
115: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 118: (p_project_id IN pa_budget_versions.project_id%TYPE,

114: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
115: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
116:
117: procedure Create_Version_OrgFcst
118: (p_project_id IN pa_budget_versions.project_id%TYPE,
119: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
120: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE default NULL,
121: p_version_name IN pa_budget_versions.version_name%TYPE,
122: p_description IN pa_budget_versions.description%TYPE,

Line 119: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,

115: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
116:
117: procedure Create_Version_OrgFcst
118: (p_project_id IN pa_budget_versions.project_id%TYPE,
119: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
120: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE default NULL,
121: p_version_name IN pa_budget_versions.version_name%TYPE,
122: p_description IN pa_budget_versions.description%TYPE,
123: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,

Line 121: p_version_name IN pa_budget_versions.version_name%TYPE,

117: procedure Create_Version_OrgFcst
118: (p_project_id IN pa_budget_versions.project_id%TYPE,
119: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
120: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE default NULL,
121: p_version_name IN pa_budget_versions.version_name%TYPE,
122: p_description IN pa_budget_versions.description%TYPE,
123: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,
124: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
125: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 122: p_description IN pa_budget_versions.description%TYPE,

118: (p_project_id IN pa_budget_versions.project_id%TYPE,
119: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
120: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE default NULL,
121: p_version_name IN pa_budget_versions.version_name%TYPE,
122: p_description IN pa_budget_versions.description%TYPE,
123: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,
124: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
125: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
126: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 123: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,

119: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
120: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE default NULL,
121: p_version_name IN pa_budget_versions.version_name%TYPE,
122: p_description IN pa_budget_versions.description%TYPE,
123: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,
124: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
125: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
126: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
127: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 124: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

120: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE default NULL,
121: p_version_name IN pa_budget_versions.version_name%TYPE,
122: p_description IN pa_budget_versions.description%TYPE,
123: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,
124: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
125: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
126: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
127: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
128:

Line 130: (p_project_id IN pa_budget_versions.project_id%TYPE,

126: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
127: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
128:
129: procedure Regenerate
130: (p_project_id IN pa_budget_versions.project_id%TYPE,
131: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
132: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
133: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
134: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 131: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

127: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
128:
129: procedure Regenerate
130: (p_project_id IN pa_budget_versions.project_id%TYPE,
131: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
132: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
133: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
134: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
135: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 132: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

128:
129: procedure Regenerate
130: (p_project_id IN pa_budget_versions.project_id%TYPE,
131: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
132: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
133: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
134: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
135: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
136:

Line 138: (p_project_id IN pa_budget_versions.project_id%TYPE

134: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
135: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
136:
137: procedure Update_Version
138: (p_project_id IN pa_budget_versions.project_id%TYPE
139: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
140: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
141: ,p_version_name IN pa_budget_versions.version_name%TYPE
142: ,p_description IN pa_budget_versions.description%TYPE

Line 139: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

135: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
136:
137: procedure Update_Version
138: (p_project_id IN pa_budget_versions.project_id%TYPE
139: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
140: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
141: ,p_version_name IN pa_budget_versions.version_name%TYPE
142: ,p_description IN pa_budget_versions.description%TYPE
143: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE

Line 140: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE

136:
137: procedure Update_Version
138: (p_project_id IN pa_budget_versions.project_id%TYPE
139: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
140: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
141: ,p_version_name IN pa_budget_versions.version_name%TYPE
142: ,p_description IN pa_budget_versions.description%TYPE
143: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
144: -- Start of additional columns for Bug :- 3088010

Line 141: ,p_version_name IN pa_budget_versions.version_name%TYPE

137: procedure Update_Version
138: (p_project_id IN pa_budget_versions.project_id%TYPE
139: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
140: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
141: ,p_version_name IN pa_budget_versions.version_name%TYPE
142: ,p_description IN pa_budget_versions.description%TYPE
143: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
144: -- Start of additional columns for Bug :- 3088010
145: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE default NULL

Line 142: ,p_description IN pa_budget_versions.description%TYPE

138: (p_project_id IN pa_budget_versions.project_id%TYPE
139: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
140: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
141: ,p_version_name IN pa_budget_versions.version_name%TYPE
142: ,p_description IN pa_budget_versions.description%TYPE
143: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
144: -- Start of additional columns for Bug :- 3088010
145: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE default NULL
146: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE default NULL

Line 143: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE

139: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
140: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
141: ,p_version_name IN pa_budget_versions.version_name%TYPE
142: ,p_description IN pa_budget_versions.description%TYPE
143: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
144: -- Start of additional columns for Bug :- 3088010
145: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE default NULL
146: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE default NULL
147: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL

Line 145: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE default NULL

141: ,p_version_name IN pa_budget_versions.version_name%TYPE
142: ,p_description IN pa_budget_versions.description%TYPE
143: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
144: -- Start of additional columns for Bug :- 3088010
145: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE default NULL
146: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE default NULL
147: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL
148: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL
149: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL

Line 146: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE default NULL

142: ,p_description IN pa_budget_versions.description%TYPE
143: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
144: -- Start of additional columns for Bug :- 3088010
145: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE default NULL
146: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE default NULL
147: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL
148: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL
149: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL
150: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL

Line 147: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL

143: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
144: -- Start of additional columns for Bug :- 3088010
145: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE default NULL
146: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE default NULL
147: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL
148: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL
149: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL
150: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL
151: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL

Line 148: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL

144: -- Start of additional columns for Bug :- 3088010
145: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE default NULL
146: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE default NULL
147: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL
148: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL
149: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL
150: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL
151: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL
152: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL

Line 149: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL

145: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE default NULL
146: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE default NULL
147: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL
148: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL
149: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL
150: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL
151: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL
152: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL
153: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL

Line 150: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL

146: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE default NULL
147: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL
148: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL
149: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL
150: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL
151: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL
152: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL
153: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL
154: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL

Line 151: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL

147: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL
148: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL
149: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL
150: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL
151: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL
152: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL
153: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL
154: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL
155: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL

Line 152: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL

148: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL
149: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL
150: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL
151: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL
152: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL
153: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL
154: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL
155: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL
156: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL

Line 153: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL

149: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL
150: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL
151: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL
152: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL
153: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL
154: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL
155: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL
156: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL
157: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL

Line 154: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL

150: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL
151: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL
152: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL
153: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL
154: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL
155: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL
156: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL
157: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL
158: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE default NULL

Line 155: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL

151: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL
152: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL
153: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL
154: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL
155: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL
156: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL
157: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL
158: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE default NULL
159: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE default NULL

Line 156: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL

152: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL
153: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL
154: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL
155: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL
156: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL
157: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL
158: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE default NULL
159: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE default NULL
160: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE default NULL

Line 157: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL

153: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL
154: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL
155: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL
156: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL
157: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL
158: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE default NULL
159: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE default NULL
160: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE default NULL
161: -- End of additional columns for Bug :- 3088010

Line 158: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE default NULL

154: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL
155: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL
156: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL
157: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL
158: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE default NULL
159: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE default NULL
160: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE default NULL
161: -- End of additional columns for Bug :- 3088010
162: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 159: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE default NULL

155: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL
156: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL
157: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL
158: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE default NULL
159: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE default NULL
160: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE default NULL
161: -- End of additional columns for Bug :- 3088010
162: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
163: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 160: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE default NULL

156: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL
157: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL
158: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE default NULL
159: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE default NULL
160: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE default NULL
161: -- End of additional columns for Bug :- 3088010
162: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
163: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
164: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 170: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,

166: /* added for financial planning needs*/
167:
168: procedure Create_Org_Fcst_Elements (
169: p_project_id IN pa_projects_all.project_id%TYPE,
170: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
171: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
172: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
173: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
174: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 171: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,

167:
168: procedure Create_Org_Fcst_Elements (
169: p_project_id IN pa_projects_all.project_id%TYPE,
170: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
171: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
172: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
173: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
174: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
175:

Line 183: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL

179: ,p_element_type IN VARCHAR2
180: ,p_version_name IN VARCHAR2
181: ,p_description IN VARCHAR2
182: -- Start of additional columns for Bug :- 2634900
183: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
184: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
185: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
186: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
187: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL

Line 184: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL

180: ,p_version_name IN VARCHAR2
181: ,p_description IN VARCHAR2
182: -- Start of additional columns for Bug :- 2634900
183: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
184: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
185: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
186: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
187: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
188: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL

Line 185: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL

181: ,p_description IN VARCHAR2
182: -- Start of additional columns for Bug :- 2634900
183: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
184: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
185: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
186: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
187: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
188: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL
189: ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL

Line 186: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL

182: -- Start of additional columns for Bug :- 2634900
183: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
184: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
185: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
186: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
187: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
188: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL
189: ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL
190: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL

Line 187: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL

183: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
184: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
185: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
186: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
187: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
188: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL
189: ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL
190: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL
191: ,p_calling_context IN VARCHAR2 := NULL

Line 188: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL

184: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
185: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
186: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
187: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
188: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL
189: ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL
190: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL
191: ,p_calling_context IN VARCHAR2 := NULL
192: -- End of additional columns for Bug :- 2634900

Line 190: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL

186: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
187: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
188: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL
189: ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL
190: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL
191: ,p_calling_context IN VARCHAR2 := NULL
192: -- End of additional columns for Bug :- 2634900
193: -- Start of additional columns for Bug :- 2649474
194: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := NULL

Line 194: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := NULL

190: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL
191: ,p_calling_context IN VARCHAR2 := NULL
192: -- End of additional columns for Bug :- 2634900
193: -- Start of additional columns for Bug :- 2649474
194: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := NULL
195: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := NULL
196: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := NULL
197: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := NULL
198: ,p_amount_set_id IN pa_proj_fp_options.cost_amount_set_id%TYPE := NULL

Line 201: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE default NULL

197: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := NULL
198: ,p_amount_set_id IN pa_proj_fp_options.cost_amount_set_id%TYPE := NULL
199: -- End of additional columns for Bug :- 2649474
200: -- Start of additional columns for Bug :- 3088010
201: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE default NULL
202: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE default NULL
203: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL
204: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL
205: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL

Line 202: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE default NULL

198: ,p_amount_set_id IN pa_proj_fp_options.cost_amount_set_id%TYPE := NULL
199: -- End of additional columns for Bug :- 2649474
200: -- Start of additional columns for Bug :- 3088010
201: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE default NULL
202: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE default NULL
203: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL
204: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL
205: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL
206: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL

Line 203: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL

199: -- End of additional columns for Bug :- 2649474
200: -- Start of additional columns for Bug :- 3088010
201: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE default NULL
202: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE default NULL
203: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL
204: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL
205: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL
206: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL
207: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL

Line 204: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL

200: -- Start of additional columns for Bug :- 3088010
201: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE default NULL
202: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE default NULL
203: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL
204: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL
205: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL
206: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL
207: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL
208: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL

Line 205: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL

201: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE default NULL
202: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE default NULL
203: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL
204: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL
205: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL
206: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL
207: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL
208: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL
209: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL

Line 206: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL

202: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE default NULL
203: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL
204: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL
205: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL
206: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL
207: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL
208: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL
209: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL
210: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL

Line 207: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL

203: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE default NULL
204: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL
205: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL
206: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL
207: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL
208: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL
209: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL
210: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL
211: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL

Line 208: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL

204: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE default NULL
205: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL
206: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL
207: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL
208: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL
209: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL
210: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL
211: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL
212: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL

Line 209: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL

205: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE default NULL
206: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL
207: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL
208: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL
209: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL
210: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL
211: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL
212: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL
213: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL

Line 210: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL

206: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE default NULL
207: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL
208: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL
209: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL
210: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL
211: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL
212: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL
213: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL
214: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE default NULL

Line 211: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL

207: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE default NULL
208: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL
209: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL
210: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL
211: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL
212: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL
213: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL
214: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE default NULL
215: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE default NULL

Line 212: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL

208: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE default NULL
209: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL
210: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL
211: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL
212: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL
213: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL
214: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE default NULL
215: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE default NULL
216: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE default NULL

Line 213: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL

209: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE default NULL
210: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL
211: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL
212: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL
213: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL
214: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE default NULL
215: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE default NULL
216: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE default NULL
217: -- End of additional columns for Bug :- 3088010

Line 214: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE default NULL

210: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE default NULL
211: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL
212: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL
213: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL
214: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE default NULL
215: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE default NULL
216: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE default NULL
217: -- End of additional columns for Bug :- 3088010
218: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 215: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE default NULL

211: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE default NULL
212: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL
213: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL
214: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE default NULL
215: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE default NULL
216: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE default NULL
217: -- End of additional columns for Bug :- 3088010
218: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
219: ,p_struct_elem_version_id IN pa_proj_element_versions.element_version_id%TYPE default NULL -- BUG 3354518

Line 216: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE default NULL

212: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE default NULL
213: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE default NULL
214: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE default NULL
215: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE default NULL
216: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE default NULL
217: -- End of additional columns for Bug :- 3088010
218: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
219: ,p_struct_elem_version_id IN pa_proj_element_versions.element_version_id%TYPE default NULL -- BUG 3354518
220: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE DEFAULT NULL

Line 220: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE DEFAULT NULL

216: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE default NULL
217: -- End of additional columns for Bug :- 3088010
218: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
219: ,p_struct_elem_version_id IN pa_proj_element_versions.element_version_id%TYPE default NULL -- BUG 3354518
220: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE DEFAULT NULL
221: ,p_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE DEFAULT NULL
222: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE DEFAULT NULL
223: ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' --Bug 4200168
224: ,x_proj_fp_option_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 221: ,p_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE DEFAULT NULL

217: -- End of additional columns for Bug :- 3088010
218: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
219: ,p_struct_elem_version_id IN pa_proj_element_versions.element_version_id%TYPE default NULL -- BUG 3354518
220: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE DEFAULT NULL
221: ,p_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE DEFAULT NULL
222: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE DEFAULT NULL
223: ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' --Bug 4200168
224: ,x_proj_fp_option_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
225: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 222: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE DEFAULT NULL

218: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
219: ,p_struct_elem_version_id IN pa_proj_element_versions.element_version_id%TYPE default NULL -- BUG 3354518
220: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE DEFAULT NULL
221: ,p_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE DEFAULT NULL
222: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE DEFAULT NULL
223: ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' --Bug 4200168
224: ,x_proj_fp_option_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
225: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
226: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 240: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

236: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
237: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
238:
239: PROCEDURE Call_Maintain_Plan_Matrix (
240: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
241: ,p_data_source IN VARCHAR2
242: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
243: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
244: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 274: p_project_id IN pa_budget_versions.project_id%TYPE

270: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
271: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
272:
273: PROCEDURE Refresh_res_list_assignment (
274: p_project_id IN pa_budget_versions.project_id%TYPE
275: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
276: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
277: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
278: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 275: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE

271: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
272:
273: PROCEDURE Refresh_res_list_assignment (
274: p_project_id IN pa_budget_versions.project_id%TYPE
275: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
276: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
277: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
278: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
279:

Line 281: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

277: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
278: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
279:
280: PROCEDURE create_default_plan_txn_rec
281: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
282: p_calling_module IN VARCHAR2,
283: p_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(), /* 7161809 */
284: p_curr_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE(), /* 7161809 */
285: x_return_status OUT NOCOPY VARCHAR2,