eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASK_PUB1 dependencies on PA_NUM_TBL_TYPE

Line 3404: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

3400:
3401: ----------------------------------- FP_M changes : Begin
3402: -- Refer to tracking bug 3305199
3403: /* Bug #: 3305199 SMukka */
3404: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
3405: /* l_Old_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3406: /* l_New_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3407: l_Old_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3408: l_New_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

Line 3407: l_Old_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

3403: /* Bug #: 3305199 SMukka */
3404: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
3405: /* l_Old_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3406: /* l_New_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3407: l_Old_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3408: l_New_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3409: Rec_Count NUMBER;
3410: ----------------------------------- FP_M changes : End
3411:

Line 3408: l_New_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

3404: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
3405: /* l_Old_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3406: /* l_New_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3407: l_Old_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3408: l_New_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3409: Rec_Count NUMBER;
3410: ----------------------------------- FP_M changes : End
3411:
3412: --Added for 14209636

Line 3820: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

3816: l_copy_external_flag VARCHAR2(1);
3817:
3818: --bug 3301192 fin plan
3819: /* Bug #: 3305199 SMukka */
3820: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
3821: /* l_old_task_ver_ids PA_PLSQL_DATATYPES.IdTabTyp; */
3822: /* l_new_task_ver_ids PA_PLSQL_DATATYPES.IdTabTyp; */
3823: /* l_old_task_ids PA_PLSQL_DATATYPES.IdTabTyp; */
3824: /* l_new_task_ids PA_PLSQL_DATATYPES.IdTabTyp; */

Line 3826: l_old_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

3822: /* l_new_task_ver_ids PA_PLSQL_DATATYPES.IdTabTyp; */
3823: /* l_old_task_ids PA_PLSQL_DATATYPES.IdTabTyp; */
3824: /* l_new_task_ids PA_PLSQL_DATATYPES.IdTabTyp; */
3825:
3826: l_old_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3827: l_new_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3828:
3829: l_old_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3830: l_new_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

Line 3827: l_new_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

3823: /* l_old_task_ids PA_PLSQL_DATATYPES.IdTabTyp; */
3824: /* l_new_task_ids PA_PLSQL_DATATYPES.IdTabTyp; */
3825:
3826: l_old_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3827: l_new_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3828:
3829: l_old_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3830: l_new_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3831:

Line 3829: l_old_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

3825:
3826: l_old_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3827: l_new_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3828:
3829: l_old_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3830: l_new_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3831:
3832: l_lowest_task_flag1 VARCHAR2(1);
3833: l_lowest_task_flag2 VARCHAR2(1);

Line 3830: l_new_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

3826: l_old_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3827: l_new_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3828:
3829: l_old_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3830: l_new_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3831:
3832: l_lowest_task_flag1 VARCHAR2(1);
3833: l_lowest_task_flag2 VARCHAR2(1);
3834: l_fin_task_flag VARCHAR2(1); -- fin html changes

Line 5281: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

5277:
5278: --bug 3301192 fin plan changes
5279: declare
5280: /* Bug #: 3305199 SMukka */
5281: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
5282: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
5283: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
5284: /* 4201927 : This value is already derived l_wp_type VARCHAR2(1); */
5285: /* 4201927 : This value is already derived l_copy_external_flag VARCHAR2(1); */

Line 5283: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

5279: declare
5280: /* Bug #: 3305199 SMukka */
5281: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
5282: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
5283: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
5284: /* 4201927 : This value is already derived l_wp_type VARCHAR2(1); */
5285: /* 4201927 : This value is already derived l_copy_external_flag VARCHAR2(1); */
5286: begin
5287:

Line 5396: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

5392: /*Smukka Bug No. 3474141 Date 03/01/2004 */
5393: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
5394: DECLARE
5395: --p1 bug 3888432
5396: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5397: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
5398: SELECT resource_assignment_id
5399: FROM pa_resource_assignments
5400: WHERE wbs_element_Version_id = c_task_ver_id

Line 6690: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

6686:
6687: --bug 3301192 fin plan changes
6688: declare
6689: /* Bug #: 3305199 SMukka */
6690: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
6691: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
6692: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
6693: /*l_wp_type VARCHAR2(1); Commented for 4269830 - This value is already derived*/
6694: begin

Line 6692: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

6688: declare
6689: /* Bug #: 3305199 SMukka */
6690: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
6691: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
6692: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
6693: /*l_wp_type VARCHAR2(1); Commented for 4269830 - This value is already derived*/
6694: begin
6695: /*4269830 Commented for 4269830 - This value is already derived
6696: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_structure_ver_id, 'WORKPLAN');

Line 6711: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

6707: /*Smukka Bug No. 3474141 Date 03/01/2004 */
6708: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
6709: DECLARE
6710: --p1 bug 3888432
6711: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6712: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
6713: SELECT resource_assignment_id
6714: FROM pa_resource_assignments
6715: WHERE wbs_element_Version_id = c_task_ver_id

Line 8003: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

7999: l_Financial_Flag VARCHAR2(1) := 'N';
8000:
8001: --bug 3301192
8002: /* Bug #: 3305199 SMukka */
8003: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
8004: /* l_task_ver_ids PA_PLSQL_DATATYPES.IdTabTyp; */
8005: l_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
8006:
8007: BEGIN

Line 8005: l_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

8001: --bug 3301192
8002: /* Bug #: 3305199 SMukka */
8003: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
8004: /* l_task_ver_ids PA_PLSQL_DATATYPES.IdTabTyp; */
8005: l_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
8006:
8007: BEGIN
8008:
8009: --Clear Error Messages.

Line 8639: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

8635: /*Smukka Bug No. 3474141 Date 03/01/2004 */
8636: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
8637: DECLARE
8638: --p1 bug 3888432
8639: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8640: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
8641: SELECT resource_assignment_id
8642: FROM pa_resource_assignments
8643: WHERE wbs_element_Version_id = c_task_ver_id

Line 9708: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

9704: --end bug 3069306
9705:
9706: --bug 3301192
9707: /* Bug #: 3305199 SMukka */
9708: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
9709: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
9710: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
9711: l_lowest_task_flag1 VARCHAR2(1);
9712: l_lowest_task_flag2 VARCHAR2(1);

Line 9710: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

9706: --bug 3301192
9707: /* Bug #: 3305199 SMukka */
9708: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
9709: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
9710: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
9711: l_lowest_task_flag1 VARCHAR2(1);
9712: l_lowest_task_flag2 VARCHAR2(1);
9713: l_fin_task_flag VARCHAR2(1);
9714:

Line 10831: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

10827: /*Smukka Bug No. 3474141 Date 03/01/2004 */
10828: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
10829: DECLARE
10830: --p1 bug 3888432
10831: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10832: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
10833: SELECT resource_assignment_id
10834: FROM pa_resource_assignments
10835: WHERE wbs_element_Version_id = c_task_ver_id

Line 11252: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

11248: --end bug 3069306
11249:
11250: --bug 3301192
11251: /* Bug #: 3305199 SMukka */
11252: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
11253: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
11254: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
11255: l_lowest_task_flag1 VARCHAR2(1);
11256: l_lowest_task_flag2 VARCHAR2(1);

Line 11254: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

11250: --bug 3301192
11251: /* Bug #: 3305199 SMukka */
11252: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
11253: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
11254: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
11255: l_lowest_task_flag1 VARCHAR2(1);
11256: l_lowest_task_flag2 VARCHAR2(1);
11257: l_fin_task_flag VARCHAR2(1);
11258:

Line 12504: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

12500: /*Smukka Bug No. 3474141 Date 03/01/2004 */
12501: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
12502: DECLARE
12503: --p1 bug 3888432
12504: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12505: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
12506: SELECT resource_assignment_id
12507: FROM pa_resource_assignments
12508: WHERE wbs_element_Version_id = c_task_ver_id

Line 12625: (p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

12621:
12622: */
12623:
12624: PROCEDURE DELETE_TASK_VERSION_IN_BULK
12625: (p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
12626: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
12627: ,p_structure_version_id IN NUMBER
12628: ,p_structure_type IN VARCHAR2 :='WORKPLAN' -- 3305199
12629: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 12626: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE

12622: */
12623:
12624: PROCEDURE DELETE_TASK_VERSION_IN_BULK
12625: (p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
12626: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
12627: ,p_structure_version_id IN NUMBER
12628: ,p_structure_type IN VARCHAR2 :='WORKPLAN' -- 3305199
12629: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
12630: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 13616: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

13612: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
13613: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
13614: ) IS
13615: /* Bug #: 3305199 SMukka */
13616: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13617: /* l_task_ver_ids PA_PLSQL_DATATYPES.IdTabTyp; */
13618: l_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13619: l_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13620: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */

Line 13618: l_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

13614: ) IS
13615: /* Bug #: 3305199 SMukka */
13616: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13617: /* l_task_ver_ids PA_PLSQL_DATATYPES.IdTabTyp; */
13618: l_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13619: l_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13620: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
13621: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
13622: l_pm_product_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(); ---bug 3811243

Line 13619: l_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

13615: /* Bug #: 3305199 SMukka */
13616: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13617: /* l_task_ver_ids PA_PLSQL_DATATYPES.IdTabTyp; */
13618: l_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13619: l_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13620: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
13621: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
13622: l_pm_product_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(); ---bug 3811243
13623:

Line 13836: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

13832: --maansari5/9
13833:
13834: l_prev_etc_effort NUMBER := null;
13835:
13836: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13837: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13838: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
13839: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
13840: l_SCHEDULED_START_DATE DATE;

Line 13837: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

13833:
13834: l_prev_etc_effort NUMBER := null;
13835:
13836: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13837: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13838: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
13839: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
13840: l_SCHEDULED_START_DATE DATE;
13841: l_SCHEDULED_END_DATE DATE;

Line 15172: p_src_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

15168: p_src_structure_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15169: p_src_structure_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
15170: p_src_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15171: p_src_structure_version_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
15172: p_src_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15173: p_src_task_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
15174: p_dest_structure_version_id IN NUMBER,
15175: p_dest_task_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15176: p_dest_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 15629: -- p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE N NOT NULL SYSTEM.PA_NUM_TBL_TYPE()

15625: -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
15626: -- p_debug_mode IN VARCHAR2 N Null N
15627: -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
15628: -- p_structure_version_id IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
15629: -- p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE N NOT NULL SYSTEM.PA_NUM_TBL_TYPE()
15630: -- p_ref_task_version_id IN NUMBER N Not Null
15631: -- p_ref_project_id IN NUMBER N Not Null /*4269830*/
15632: -- p_peer_or_sub IN VARCHAR2 N Not Null
15633: -- p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE N NOT NULL SYSTEM.PA_NUM_TBL_TYPE()

Line 15633: -- p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE N NOT NULL SYSTEM.PA_NUM_TBL_TYPE()

15629: -- p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE N NOT NULL SYSTEM.PA_NUM_TBL_TYPE()
15630: -- p_ref_task_version_id IN NUMBER N Not Null
15631: -- p_ref_project_id IN NUMBER N Not Null /*4269830*/
15632: -- p_peer_or_sub IN VARCHAR2 N Not Null
15633: -- p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE N NOT NULL SYSTEM.PA_NUM_TBL_TYPE()
15634: -- x_return_status OUT VARCHAR2 N NULL
15635: -- x_msg_count OUT NUMBER N NULL
15636: -- x_msg_data OUT VARCHAR2 N NULL
15637: --

Line 15653: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

15649: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
15650: p_debug_mode IN VARCHAR2 := 'N',
15651: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15652: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15653: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15654: p_ref_task_version_id IN NUMBER,
15655: p_ref_project_id IN NUMBER, /*4269830*/
15656: p_peer_or_sub IN VARCHAR2,
15657: p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

Line 15657: p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

15653: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15654: p_ref_task_version_id IN NUMBER,
15655: p_ref_project_id IN NUMBER, /*4269830*/
15656: p_peer_or_sub IN VARCHAR2,
15657: p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15658: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
15659: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
15660: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
15661: )

Line 15964: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

15960: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
15961: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
15962: p_debug_mode IN VARCHAR2 :='N',
15963: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15964: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15965: --Begin:5867373:p_task_number_tbl's data-type has been changed to varchar2(100)
15966: p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE(),
15967: --End:5867373:
15968: p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),

Line 15970: p_task_manager_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

15966: p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE(),
15967: --End:5867373:
15968: p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15969: p_task_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE(),
15970: p_task_manager_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15971: p_task_manager_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15972: p_carrying_out_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15973: p_carrying_out_org_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15974: p_priority_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),

Line 15972: p_carrying_out_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

15968: p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15969: p_task_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE(),
15970: p_task_manager_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15971: p_task_manager_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15972: p_carrying_out_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15973: p_carrying_out_org_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15974: p_priority_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15975: p_TYPE_ID_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15976: p_status_code_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),

Line 15975: p_TYPE_ID_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

15971: p_task_manager_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15972: p_carrying_out_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15973: p_carrying_out_org_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15974: p_priority_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15975: p_TYPE_ID_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15976: p_status_code_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15977: p_inc_proj_progress_flag_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15978: p_transaction_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15979: p_transaction_finish_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),

Line 15980: p_work_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

15976: p_status_code_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15977: p_inc_proj_progress_flag_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15978: p_transaction_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15979: p_transaction_finish_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15980: p_work_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15981: p_service_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15982: p_work_item_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15983: p_uom_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15984: p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

Line 15984: p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

15980: p_work_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15981: p_service_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15982: p_work_item_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15983: p_uom_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15984: p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15985: -- Update_Schedule_Version
15986: p_scheduled_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15987: p_scheduled_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15988: p_pev_schedule_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

Line 15988: p_pev_schedule_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

15984: p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15985: -- Update_Schedule_Version
15986: p_scheduled_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15987: p_scheduled_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15988: p_pev_schedule_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15989: p_milestone_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE(),
15990: p_critical_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE(),
15991: p_WQ_PLANNED_QUANTITY_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15992: p_early_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),

Line 15991: p_WQ_PLANNED_QUANTITY_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

15987: p_scheduled_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15988: p_pev_schedule_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15989: p_milestone_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE(),
15990: p_critical_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE(),
15991: p_WQ_PLANNED_QUANTITY_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15992: p_early_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15993: p_early_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15994: p_late_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15995: p_late_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),

Line 15998: p_sch_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

15994: p_late_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15995: p_late_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15996: p_constraint_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15997: p_constraint_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15998: p_sch_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15999: -- update_task_det_sch_info
16000: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16001: p_percent_complete_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16002: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

Line 16000: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

15996: p_constraint_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15997: p_constraint_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15998: p_sch_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15999: -- update_task_det_sch_info
16000: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16001: p_percent_complete_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16002: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16003: p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16004: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

Line 16001: p_percent_complete_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

15997: p_constraint_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15998: p_sch_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15999: -- update_task_det_sch_info
16000: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16001: p_percent_complete_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16002: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16003: p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16004: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16005: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

Line 16002: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

15998: p_sch_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15999: -- update_task_det_sch_info
16000: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16001: p_percent_complete_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16002: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16003: p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16004: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16005: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16006: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

Line 16003: p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

15999: -- update_task_det_sch_info
16000: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16001: p_percent_complete_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16002: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16003: p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16004: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16005: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16006: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16007: -- Update_Task_Weighting

Line 16004: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

16000: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16001: p_percent_complete_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16002: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16003: p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16004: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16005: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16006: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16007: -- Update_Task_Weighting
16008: p_object_relationship_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

Line 16005: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

16001: p_percent_complete_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16002: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16003: p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16004: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16005: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16006: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16007: -- Update_Task_Weighting
16008: p_object_relationship_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16009: p_weighting_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

Line 16006: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

16002: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16003: p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16004: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16005: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16006: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16007: -- Update_Task_Weighting
16008: p_object_relationship_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16009: p_weighting_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16010: p_obj_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

Line 16008: p_object_relationship_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

16004: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16005: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16006: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16007: -- Update_Task_Weighting
16008: p_object_relationship_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16009: p_weighting_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16010: p_obj_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16011: p_task_weight_method IN VARCHAR2,
16012: -- common

Line 16009: p_weighting_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

16005: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16006: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16007: -- Update_Task_Weighting
16008: p_object_relationship_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16009: p_weighting_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16010: p_obj_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16011: p_task_weight_method IN VARCHAR2,
16012: -- common
16013: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 16010: p_obj_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

16006: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16007: -- Update_Task_Weighting
16008: p_object_relationship_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16009: p_weighting_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16010: p_obj_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
16011: p_task_weight_method IN VARCHAR2,
16012: -- common
16013: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
16014: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 16623: ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

16619: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16620: ,p_project_id IN NUMBER
16621: ,p_structure_version_id IN NUMBER
16622: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
16623: ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16624: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16625: ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16626: ,x_return_status OUT NOCOPY VARCHAR2
16627: ,x_msg_count OUT NOCOPY NUMBER

Line 16624: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE

16620: ,p_project_id IN NUMBER
16621: ,p_structure_version_id IN NUMBER
16622: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
16623: ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16624: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16625: ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16626: ,x_return_status OUT NOCOPY VARCHAR2
16627: ,x_msg_count OUT NOCOPY NUMBER
16628: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 16625: ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE

16621: ,p_structure_version_id IN NUMBER
16622: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
16623: ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16624: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16625: ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16626: ,x_return_status OUT NOCOPY VARCHAR2
16627: ,x_msg_count OUT NOCOPY NUMBER
16628: ,x_msg_data OUT NOCOPY VARCHAR2)
16629: IS

Line 16855: ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

16851: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16852: ,p_project_id IN NUMBER
16853: ,p_structure_version_id IN NUMBER
16854: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
16855: ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16856: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16857: ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16858: ,x_return_status OUT NOCOPY VARCHAR2
16859: ,x_msg_count OUT NOCOPY NUMBER

Line 16856: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE

16852: ,p_project_id IN NUMBER
16853: ,p_structure_version_id IN NUMBER
16854: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
16855: ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16856: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16857: ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16858: ,x_return_status OUT NOCOPY VARCHAR2
16859: ,x_msg_count OUT NOCOPY NUMBER
16860: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 16857: ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE

16853: ,p_structure_version_id IN NUMBER
16854: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
16855: ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16856: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16857: ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16858: ,x_return_status OUT NOCOPY VARCHAR2
16859: ,x_msg_count OUT NOCOPY NUMBER
16860: ,x_msg_data OUT NOCOPY VARCHAR2)
16861: IS

Line 17071: (p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

17067: END OUTDENT_MULTI_TASK_VERSION;
17068:
17069: --anuragag bug 8566495 E&C enhancement changes
17070: PROCEDURE APPROVE_TASKS_IN_BULK
17071: (p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
17072: ,p_parent_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
17073: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
17074: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
17075: ,p_project_id IN NUMBER

Line 17072: ,p_parent_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

17068:
17069: --anuragag bug 8566495 E&C enhancement changes
17070: PROCEDURE APPROVE_TASKS_IN_BULK
17071: (p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
17072: ,p_parent_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
17073: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
17074: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
17075: ,p_project_id IN NUMBER
17076: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 17094: l_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

17090: l_dummy_app_name VARCHAR2(30);
17091: l_enc_msg_data VARCHAR2(2000);
17092: l_msg_name VARCHAR2(30);
17093: l_msg_index_out NUMBER ;
17094: l_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
17095:
17096: l_project_id pa_proj_elements.project_id%TYPE;
17097: l_task_start_date DATE;
17098: l_task_finish_date DATE;