DBA Data[Home] [Help]

APPS.PA_TASK_PVT1 dependencies on PA_TASKS_MAINT_PUB

Line 1249: PA_TASKS_MAINT_PUB.CREATE_TASK

1245:
1246: --Bug 3935874 : Changed SUBSTR to SUBSTRB for avoiding MLS problem
1247: -- Also ,Truncated Description to 250 chars as PA_TASKS can hold
1248: -- Only Description upto 250 chars (l_task_description can be upto 2000 chars)
1249: PA_TASKS_MAINT_PUB.CREATE_TASK
1250: (
1251: p_api_version => p_api_version
1252: ,p_init_msg_list => p_init_msg_list
1253: ,p_commit => p_commit

Line 2957: PA_TASKS_MAINT_PUB.UPDATE_TASK

2953: -- Included SUBSTRB for Task Description also ,because Task Description size
2954: -- is only 250 char in PA_TASKS Table ,whereas it can be upto 2000 char in pa_proj_elements
2955: -- These changes have been done for Bug 3935874
2956:
2957: PA_TASKS_MAINT_PUB.UPDATE_TASK
2958: (
2959: p_project_id => l_project_id
2960: ,p_task_id => p_task_id
2961: ,p_task_number => SUBSTRB( l_task_number, 1, 25 ) --Bug 3705333 changed from p_task_number to l_task_number

Line 3013: PA_TASKS_MAINT_PUB.UPDATE_TASK

3009:
3010: -- Changed SUBSTR to SUBSTRB for 3935874
3011: -- Also Truncated Description to 250 chars as PA_TASKS can hold only upto 250 char description
3012: -- whereas l_task_description can be upto 2000 chars
3013: PA_TASKS_MAINT_PUB.UPDATE_TASK
3014: (
3015: p_project_id => l_project_id
3016: ,p_task_id => p_task_id
3017: ,p_task_number => SUBSTRB( l_task_NUMBER, 1, 25 ) --Bug 3705333 changed from p_task_number to l_task_number

Line 5848: PA_TASKS_MAINT_PUB.DELETE_TASK(

5844: IF p_called_from_api <> 'MOVE_TASK_VERSION' AND
5845: p_calling_module NOT IN ( 'FORMS', 'AMG' ) --Added condition to call this api from forms and AMG apis.
5846: --Since forms and AMG already deletes from pa_tasks we do not have to call the following api again.
5847: THEN
5848: PA_TASKS_MAINT_PUB.DELETE_TASK(
5849: p_api_version => p_api_version
5850: ,p_init_msg_list => p_init_msg_list
5851: ,p_commit => p_commit
5852: ,p_validate_only => p_validate_only

Line 6188: PA_TASKS_MAINT_PUB.DELETE_TASK

6184: IF p_called_from_api <> 'MOVE_TASK_VERSION' AND
6185: p_calling_module NOT IN ( 'FORMS', 'AMG' ) --Added condition to call this api from forms and AMG apis.
6186: --Since forms and AMG already deletes from pa_tasks we do not have to call the following api again.
6187: THEN
6188: PA_TASKS_MAINT_PUB.DELETE_TASK
6189: (
6190: p_api_version => p_api_version
6191: ,p_init_msg_list => p_init_msg_list
6192: ,p_commit => p_commit

Line 9968: -- PA_TASKS_MAINT_PUB.DELETE_TASK(

9964: END IF; --called_from_api chk.
9965: CLOSE cur_pa_tasks;
9966:
9967: -- hsiu: bug 2800553: commented for performance improvement
9968: -- PA_TASKS_MAINT_PUB.DELETE_TASK(
9969: -- p_api_version => p_api_version
9970: -- ,p_init_msg_list => p_init_msg_list
9971: -- ,p_commit => p_commit
9972: -- ,p_validate_only => p_validate_only