DBA Data[Home] [Help]

APPS.PA_TASK_PUB1 dependencies on PA_VARCHAR2_100_TBL_TYPE

Line 1426: p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE(),

1422: p_debug_mode IN VARCHAR2 :='N',
1423: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1424: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1425: --Begin:5867373:p_task_number_tbl's data-type has been changed to varchar2(100)
1426: p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE(),
1427: --End:5867373:
1428: p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
1429: p_task_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE(),
1430: p_task_manager_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

Line 1539: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE

1535: -- Bug 8566495 E&C enhancement
1536: PROCEDURE APPROVE_TASKS_IN_BULK
1537: (p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1538: ,p_parent_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1539: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
1540: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
1541: ,p_project_id IN NUMBER
1542: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1543: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1540: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE

1536: PROCEDURE APPROVE_TASKS_IN_BULK
1537: (p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1538: ,p_parent_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1539: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
1540: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
1541: ,p_project_id IN NUMBER
1542: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1543: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1544: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895