4:
5:
6:
7: PROCEDURE Insert_Row(
8: p_name PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
9: p_description PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
10: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE,
11: p_group_resource_type_id NUMBER,
12: p_start_date_active DATE,
5:
6:
7: PROCEDURE Insert_Row(
8: p_name PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
9: p_description PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
10: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE,
11: p_group_resource_type_id NUMBER,
12: p_start_date_active DATE,
13: p_end_date_active DATE,
6:
7: PROCEDURE Insert_Row(
8: p_name PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
9: p_description PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
10: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE,
11: p_group_resource_type_id NUMBER,
12: p_start_date_active DATE,
13: p_end_date_active DATE,
14: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE,
10: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE,
11: p_group_resource_type_id NUMBER,
12: p_start_date_active DATE,
13: p_end_date_active DATE,
14: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE,
15: p_business_group_id NUMBER,
16: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE,
17: p_job_group_id NUMBER,
18: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE,
12: p_start_date_active DATE,
13: p_end_date_active DATE,
14: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE,
15: p_business_group_id NUMBER,
16: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE,
17: p_job_group_id NUMBER,
18: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE,
19: p_control_flag PA_RESOURCE_LISTS_ALL_BG.control_flag%TYPE,
20: p_use_for_wp_flag PA_RESOURCE_LISTS_ALL_BG.use_for_wp_flag%TYPE,
14: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE,
15: p_business_group_id NUMBER,
16: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE,
17: p_job_group_id NUMBER,
18: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE,
19: p_control_flag PA_RESOURCE_LISTS_ALL_BG.control_flag%TYPE,
20: p_use_for_wp_flag PA_RESOURCE_LISTS_ALL_BG.use_for_wp_flag%TYPE,
21: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE,
22: x_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
15: p_business_group_id NUMBER,
16: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE,
17: p_job_group_id NUMBER,
18: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE,
19: p_control_flag PA_RESOURCE_LISTS_ALL_BG.control_flag%TYPE,
20: p_use_for_wp_flag PA_RESOURCE_LISTS_ALL_BG.use_for_wp_flag%TYPE,
21: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE,
22: x_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
23: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
16: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE,
17: p_job_group_id NUMBER,
18: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE,
19: p_control_flag PA_RESOURCE_LISTS_ALL_BG.control_flag%TYPE,
20: p_use_for_wp_flag PA_RESOURCE_LISTS_ALL_BG.use_for_wp_flag%TYPE,
21: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE,
22: x_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
23: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
24: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
17: p_job_group_id NUMBER,
18: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE,
19: p_control_flag PA_RESOURCE_LISTS_ALL_BG.control_flag%TYPE,
20: p_use_for_wp_flag PA_RESOURCE_LISTS_ALL_BG.use_for_wp_flag%TYPE,
21: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE,
22: x_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
23: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
24: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
25: );