DBA Data[Home] [Help]

APPS.PA_TASK_PVT1 dependencies on PA_TASKS_MAINT_PUB

Line 1141: PA_TASKS_MAINT_PUB.CREATE_TASK

1137:
1138: --Bug 3935874 : Changed SUBSTR to SUBSTRB for avoiding MLS problem
1139: -- Also ,Truncated Description to 250 chars as PA_TASKS can hold
1140: -- Only Description upto 250 chars (l_task_description can be upto 2000 chars)
1141: PA_TASKS_MAINT_PUB.CREATE_TASK
1142: (
1143: p_api_version => p_api_version
1144: ,p_init_msg_list => p_init_msg_list
1145: ,p_commit => p_commit

Line 2808: PA_TASKS_MAINT_PUB.UPDATE_TASK

2804: -- Included SUBSTRB for Task Description also ,because Task Description size
2805: -- is only 250 char in PA_TASKS Table ,whereas it can be upto 2000 char in pa_proj_elements
2806: -- These changes have been done for Bug 3935874
2807:
2808: PA_TASKS_MAINT_PUB.UPDATE_TASK
2809: (
2810: p_project_id => l_project_id
2811: ,p_task_id => p_task_id
2812: ,p_task_number => SUBSTRB( l_task_number, 1, 25 ) --Bug 3705333 changed from p_task_number to l_task_number

Line 2863: PA_TASKS_MAINT_PUB.UPDATE_TASK

2859:
2860: -- Changed SUBSTR to SUBSTRB for 3935874
2861: -- Also Truncated Description to 250 chars as PA_TASKS can hold only upto 250 char description
2862: -- whereas l_task_description can be upto 2000 chars
2863: PA_TASKS_MAINT_PUB.UPDATE_TASK
2864: (
2865: p_project_id => l_project_id
2866: ,p_task_id => p_task_id
2867: ,p_task_number => SUBSTRB( l_task_NUMBER, 1, 25 ) --Bug 3705333 changed from p_task_number to l_task_number

Line 5340: PA_TASKS_MAINT_PUB.DELETE_TASK(

5336: IF p_called_from_api <> 'MOVE_TASK_VERSION' AND
5337: p_calling_module NOT IN ( 'FORMS', 'AMG' ) --Added condition to call this api from forms and AMG apis.
5338: --Since forms and AMG already deletes from pa_tasks we do not have to call the following api again.
5339: THEN
5340: PA_TASKS_MAINT_PUB.DELETE_TASK(
5341: p_api_version => p_api_version
5342: ,p_init_msg_list => p_init_msg_list
5343: ,p_commit => p_commit
5344: ,p_validate_only => p_validate_only

Line 5680: PA_TASKS_MAINT_PUB.DELETE_TASK

5676: IF p_called_from_api <> 'MOVE_TASK_VERSION' AND
5677: p_calling_module NOT IN ( 'FORMS', 'AMG' ) --Added condition to call this api from forms and AMG apis.
5678: --Since forms and AMG already deletes from pa_tasks we do not have to call the following api again.
5679: THEN
5680: PA_TASKS_MAINT_PUB.DELETE_TASK
5681: (
5682: p_api_version => p_api_version
5683: ,p_init_msg_list => p_init_msg_list
5684: ,p_commit => p_commit

Line 9220: -- PA_TASKS_MAINT_PUB.DELETE_TASK(

9216: END IF; --called_from_api chk.
9217: CLOSE cur_pa_tasks;
9218:
9219: -- hsiu: bug 2800553: commented for performance improvement
9220: -- PA_TASKS_MAINT_PUB.DELETE_TASK(
9221: -- p_api_version => p_api_version
9222: -- ,p_init_msg_list => p_init_msg_list
9223: -- ,p_commit => p_commit
9224: -- ,p_validate_only => p_validate_only