180: -- PROCEDURE : populate_copy_options
181: -- PURPOSE : This API should be called to populate values for copy options into the global
182: -- temporary table PA_PROJECT_COPY_OPTIONS_TMP
183: PROCEDURE populate_copy_options( p_api_version IN NUMBER := 1.0
184: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
185: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
186: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
187: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
188: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
181: -- PURPOSE : This API should be called to populate values for copy options into the global
182: -- temporary table PA_PROJECT_COPY_OPTIONS_TMP
183: PROCEDURE populate_copy_options( p_api_version IN NUMBER := 1.0
184: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
185: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
186: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
187: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
188: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
189: ,p_debug_mode IN VARCHAR2 := 'N'
182: -- temporary table PA_PROJECT_COPY_OPTIONS_TMP
183: PROCEDURE populate_copy_options( p_api_version IN NUMBER := 1.0
184: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
185: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
186: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
187: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
188: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
189: ,p_debug_mode IN VARCHAR2 := 'N'
190: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
183: PROCEDURE populate_copy_options( p_api_version IN NUMBER := 1.0
184: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
185: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
186: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
187: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
188: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
189: ,p_debug_mode IN VARCHAR2 := 'N'
190: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
191: ,p_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
198: -- PROCEDURE : populate_default_copy_options
199: -- PURPOSE : This API should be called to populate default values for copy options into the global
200: -- temporary table PA_PROJECT_COPY_OPTIONS_TMP
201: PROCEDURE populate_default_copy_options( p_api_version IN NUMBER := 1.0
202: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
203: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
204: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
205: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
206: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
199: -- PURPOSE : This API should be called to populate default values for copy options into the global
200: -- temporary table PA_PROJECT_COPY_OPTIONS_TMP
201: PROCEDURE populate_default_copy_options( p_api_version IN NUMBER := 1.0
202: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
203: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
204: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
205: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
206: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
207: ,p_debug_mode IN VARCHAR2 := 'N'
200: -- temporary table PA_PROJECT_COPY_OPTIONS_TMP
201: PROCEDURE populate_default_copy_options( p_api_version IN NUMBER := 1.0
202: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
203: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
204: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
205: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
206: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
207: ,p_debug_mode IN VARCHAR2 := 'N'
208: ,p_src_project_id IN NUMBER
201: PROCEDURE populate_default_copy_options( p_api_version IN NUMBER := 1.0
202: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
203: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
204: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
205: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
206: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
207: ,p_debug_mode IN VARCHAR2 := 'N'
208: ,p_src_project_id IN NUMBER
209: ,p_src_template_flag IN VARCHAR2
218: /*
219: PROCEDURE COPY_BUDGETORY_CTRL
220: (
221: p_api_version_number IN NUMBER := 1.0
222: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
223: , p_commit IN VARCHAR2 := FND_API.G_FALSE
224: , p_src_project_id IN NUMBER
225: , p_dest_project_id IN NUMBER
226: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
219: PROCEDURE COPY_BUDGETORY_CTRL
220: (
221: p_api_version_number IN NUMBER := 1.0
222: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
223: , p_commit IN VARCHAR2 := FND_API.G_FALSE
224: , p_src_project_id IN NUMBER
225: , p_dest_project_id IN NUMBER
226: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
227: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895