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 3352: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

3348:
3349: ----------------------------------- FP_M changes : Begin
3350: -- Refer to tracking bug 3305199
3351: /* Bug #: 3305199 SMukka */
3352: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
3353: /* l_Old_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3354: /* l_New_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3355: l_Old_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3356: l_New_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

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

3351: /* Bug #: 3305199 SMukka */
3352: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
3353: /* l_Old_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3354: /* l_New_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3355: l_Old_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3356: l_New_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3357: Rec_Count NUMBER;
3358: ----------------------------------- FP_M changes : End
3359:

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

3352: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
3353: /* l_Old_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3354: /* l_New_Task_Versions_Tab PA_PLSQL_DATATYPES.IdTabTyp; */
3355: l_Old_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3356: l_New_Task_Versions_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3357: Rec_Count NUMBER;
3358: ----------------------------------- FP_M changes : End
3359:
3360: CURSOR get_product_code ( c_project_id NUMBER ) IS

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

3715: l_copy_external_flag VARCHAR2(1);
3716:
3717: --bug 3301192 fin plan
3718: /* Bug #: 3305199 SMukka */
3719: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
3720: /* l_old_task_ver_ids PA_PLSQL_DATATYPES.IdTabTyp; */
3721: /* l_new_task_ver_ids PA_PLSQL_DATATYPES.IdTabTyp; */
3722: /* l_old_task_ids PA_PLSQL_DATATYPES.IdTabTyp; */
3723: /* l_new_task_ids PA_PLSQL_DATATYPES.IdTabTyp; */

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

3721: /* l_new_task_ver_ids PA_PLSQL_DATATYPES.IdTabTyp; */
3722: /* l_old_task_ids PA_PLSQL_DATATYPES.IdTabTyp; */
3723: /* l_new_task_ids PA_PLSQL_DATATYPES.IdTabTyp; */
3724:
3725: l_old_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3726: l_new_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3727:
3728: l_old_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3729: l_new_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

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

3722: /* l_old_task_ids PA_PLSQL_DATATYPES.IdTabTyp; */
3723: /* l_new_task_ids PA_PLSQL_DATATYPES.IdTabTyp; */
3724:
3725: l_old_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3726: l_new_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3727:
3728: l_old_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3729: l_new_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3730:

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

3724:
3725: l_old_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3726: l_new_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3727:
3728: l_old_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3729: l_new_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3730:
3731: l_lowest_task_flag1 VARCHAR2(1);
3732: l_lowest_task_flag2 VARCHAR2(1);

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

3725: l_old_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3726: l_new_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3727:
3728: l_old_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3729: l_new_task_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
3730:
3731: l_lowest_task_flag1 VARCHAR2(1);
3732: l_lowest_task_flag2 VARCHAR2(1);
3733: l_fin_task_flag VARCHAR2(1); -- fin html changes

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

5002:
5003: --bug 3301192 fin plan changes
5004: declare
5005: /* Bug #: 3305199 SMukka */
5006: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
5007: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
5008: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
5009: /* 4201927 : This value is already derived l_wp_type VARCHAR2(1); */
5010: /* 4201927 : This value is already derived l_copy_external_flag VARCHAR2(1); */

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

5004: declare
5005: /* Bug #: 3305199 SMukka */
5006: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
5007: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
5008: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
5009: /* 4201927 : This value is already derived l_wp_type VARCHAR2(1); */
5010: /* 4201927 : This value is already derived l_copy_external_flag VARCHAR2(1); */
5011: begin
5012:

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

5117: /*Smukka Bug No. 3474141 Date 03/01/2004 */
5118: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
5119: DECLARE
5120: --p1 bug 3888432
5121: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5122: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
5123: SELECT resource_assignment_id
5124: FROM pa_resource_assignments
5125: WHERE wbs_element_Version_id = c_task_ver_id

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

6404:
6405: --bug 3301192 fin plan changes
6406: declare
6407: /* Bug #: 3305199 SMukka */
6408: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
6409: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
6410: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
6411: /*l_wp_type VARCHAR2(1); Commented for 4269830 - This value is already derived*/
6412: begin

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

6406: declare
6407: /* Bug #: 3305199 SMukka */
6408: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
6409: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
6410: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
6411: /*l_wp_type VARCHAR2(1); Commented for 4269830 - This value is already derived*/
6412: begin
6413: /*4269830 Commented for 4269830 - This value is already derived
6414: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_structure_ver_id, 'WORKPLAN');

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

6425: /*Smukka Bug No. 3474141 Date 03/01/2004 */
6426: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
6427: DECLARE
6428: --p1 bug 3888432
6429: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6430: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
6431: SELECT resource_assignment_id
6432: FROM pa_resource_assignments
6433: WHERE wbs_element_Version_id = c_task_ver_id

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

7702: l_Financial_Flag VARCHAR2(1) := 'N';
7703:
7704: --bug 3301192
7705: /* Bug #: 3305199 SMukka */
7706: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
7707: /* l_task_ver_ids PA_PLSQL_DATATYPES.IdTabTyp; */
7708: l_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7709:
7710: BEGIN

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

7704: --bug 3301192
7705: /* Bug #: 3305199 SMukka */
7706: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
7707: /* l_task_ver_ids PA_PLSQL_DATATYPES.IdTabTyp; */
7708: l_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7709:
7710: BEGIN
7711:
7712: --Clear Error Messages.

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

8272: /*Smukka Bug No. 3474141 Date 03/01/2004 */
8273: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
8274: DECLARE
8275: --p1 bug 3888432
8276: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8277: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
8278: SELECT resource_assignment_id
8279: FROM pa_resource_assignments
8280: WHERE wbs_element_Version_id = c_task_ver_id

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

9341: --end bug 3069306
9342:
9343: --bug 3301192
9344: /* Bug #: 3305199 SMukka */
9345: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
9346: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
9347: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
9348: l_lowest_task_flag1 VARCHAR2(1);
9349: l_lowest_task_flag2 VARCHAR2(1);

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

9343: --bug 3301192
9344: /* Bug #: 3305199 SMukka */
9345: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
9346: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
9347: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
9348: l_lowest_task_flag1 VARCHAR2(1);
9349: l_lowest_task_flag2 VARCHAR2(1);
9350: l_fin_task_flag VARCHAR2(1);
9351:

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

10447: /*Smukka Bug No. 3474141 Date 03/01/2004 */
10448: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
10449: DECLARE
10450: --p1 bug 3888432
10451: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10452: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
10453: SELECT resource_assignment_id
10454: FROM pa_resource_assignments
10455: WHERE wbs_element_Version_id = c_task_ver_id

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

10868: --end bug 3069306
10869:
10870: --bug 3301192
10871: /* Bug #: 3305199 SMukka */
10872: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
10873: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
10874: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
10875: l_lowest_task_flag1 VARCHAR2(1);
10876: l_lowest_task_flag2 VARCHAR2(1);

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

10870: --bug 3301192
10871: /* Bug #: 3305199 SMukka */
10872: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
10873: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
10874: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
10875: l_lowest_task_flag1 VARCHAR2(1);
10876: l_lowest_task_flag2 VARCHAR2(1);
10877: l_fin_task_flag VARCHAR2(1);
10878:

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

12084: /*Smukka Bug No. 3474141 Date 03/01/2004 */
12085: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
12086: DECLARE
12087: --p1 bug 3888432
12088: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12089: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
12090: SELECT resource_assignment_id
12091: FROM pa_resource_assignments
12092: WHERE wbs_element_Version_id = c_task_ver_id

Line 12209: (p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

12205:
12206: */
12207:
12208: PROCEDURE DELETE_TASK_VERSION_IN_BULK
12209: (p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
12210: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
12211: ,p_structure_version_id IN NUMBER
12212: ,p_structure_type IN VARCHAR2 :='WORKPLAN' -- 3305199
12213: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 12210: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE

12206: */
12207:
12208: PROCEDURE DELETE_TASK_VERSION_IN_BULK
12209: (p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
12210: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
12211: ,p_structure_version_id IN NUMBER
12212: ,p_structure_type IN VARCHAR2 :='WORKPLAN' -- 3305199
12213: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
12214: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

13088: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
13089: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
13090: ) IS
13091: /* Bug #: 3305199 SMukka */
13092: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13093: /* l_task_ver_ids PA_PLSQL_DATATYPES.IdTabTyp; */
13094: l_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13095: l_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13096: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */

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

13090: ) IS
13091: /* Bug #: 3305199 SMukka */
13092: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13093: /* l_task_ver_ids PA_PLSQL_DATATYPES.IdTabTyp; */
13094: l_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13095: l_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13096: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
13097: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
13098: l_pm_product_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(); ---bug 3811243

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

13091: /* Bug #: 3305199 SMukka */
13092: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13093: /* l_task_ver_ids PA_PLSQL_DATATYPES.IdTabTyp; */
13094: l_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13095: l_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
13096: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
13097: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
13098: l_pm_product_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(); ---bug 3811243
13099:

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

13308: --maansari5/9
13309:
13310: l_prev_etc_effort NUMBER := null;
13311:
13312: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13313: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13314: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
13315: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
13316: l_SCHEDULED_START_DATE DATE;

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

13309:
13310: l_prev_etc_effort NUMBER := null;
13311:
13312: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13313: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13314: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
13315: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
13316: l_SCHEDULED_START_DATE DATE;
13317: l_SCHEDULED_END_DATE DATE;

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

14639: p_src_structure_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
14640: p_src_structure_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
14641: p_src_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
14642: p_src_structure_version_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
14643: p_src_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
14644: p_src_task_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
14645: p_dest_structure_version_id IN NUMBER,
14646: p_dest_task_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
14647: p_dest_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

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

15092: -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
15093: -- p_debug_mode IN VARCHAR2 N Null N
15094: -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
15095: -- p_structure_version_id IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
15096: -- p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE N NOT NULL SYSTEM.PA_NUM_TBL_TYPE()
15097: -- p_ref_task_version_id IN NUMBER N Not Null
15098: -- p_ref_project_id IN NUMBER N Not Null /*4269830*/
15099: -- p_peer_or_sub IN VARCHAR2 N Not Null
15100: -- p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE N NOT NULL SYSTEM.PA_NUM_TBL_TYPE()

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

15096: -- p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE N NOT NULL SYSTEM.PA_NUM_TBL_TYPE()
15097: -- p_ref_task_version_id IN NUMBER N Not Null
15098: -- p_ref_project_id IN NUMBER N Not Null /*4269830*/
15099: -- p_peer_or_sub IN VARCHAR2 N Not Null
15100: -- p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE N NOT NULL SYSTEM.PA_NUM_TBL_TYPE()
15101: -- x_return_status OUT VARCHAR2 N NULL
15102: -- x_msg_count OUT NUMBER N NULL
15103: -- x_msg_data OUT VARCHAR2 N NULL
15104: --

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

15116: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
15117: p_debug_mode IN VARCHAR2 := 'N',
15118: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15119: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15120: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15121: p_ref_task_version_id IN NUMBER,
15122: p_ref_project_id IN NUMBER, /*4269830*/
15123: p_peer_or_sub IN VARCHAR2,
15124: p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

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

15120: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15121: p_ref_task_version_id IN NUMBER,
15122: p_ref_project_id IN NUMBER, /*4269830*/
15123: p_peer_or_sub IN VARCHAR2,
15124: p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15125: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
15126: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
15127: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
15128: )

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

15427: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
15428: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
15429: p_debug_mode IN VARCHAR2 :='N',
15430: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
15431: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15432: --Begin:5867373:p_task_number_tbl's data-type has been changed to varchar2(100)
15433: p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE(),
15434: --End:5867373:
15435: p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),

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

15433: p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE(),
15434: --End:5867373:
15435: p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15436: p_task_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE(),
15437: p_task_manager_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15438: p_task_manager_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15439: p_carrying_out_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15440: p_carrying_out_org_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15441: p_priority_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),

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

15435: p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15436: p_task_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE(),
15437: p_task_manager_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15438: p_task_manager_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15439: p_carrying_out_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15440: p_carrying_out_org_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15441: p_priority_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15442: p_TYPE_ID_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15443: p_status_code_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),

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

15438: p_task_manager_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15439: p_carrying_out_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15440: p_carrying_out_org_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15441: p_priority_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15442: p_TYPE_ID_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15443: p_status_code_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15444: p_inc_proj_progress_flag_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15445: p_transaction_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15446: p_transaction_finish_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),

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

15443: p_status_code_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15444: p_inc_proj_progress_flag_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
15445: p_transaction_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15446: p_transaction_finish_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15447: p_work_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15448: p_service_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15449: p_work_item_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15450: p_uom_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15451: p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

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

15447: p_work_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15448: p_service_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15449: p_work_item_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15450: p_uom_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15451: p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15452: -- Update_Schedule_Version
15453: p_scheduled_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15454: p_scheduled_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15455: p_pev_schedule_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

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

15451: p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15452: -- Update_Schedule_Version
15453: p_scheduled_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15454: p_scheduled_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15455: p_pev_schedule_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15456: p_milestone_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE(),
15457: p_critical_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE(),
15458: p_WQ_PLANNED_QUANTITY_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15459: p_early_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),

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

15454: p_scheduled_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15455: p_pev_schedule_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15456: p_milestone_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE(),
15457: p_critical_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE(),
15458: p_WQ_PLANNED_QUANTITY_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15459: p_early_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15460: p_early_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15461: p_late_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15462: p_late_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),

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

15461: p_late_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15462: p_late_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15463: p_constraint_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15464: p_constraint_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15465: p_sch_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15466: -- update_task_det_sch_info
15467: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15468: p_percent_complete_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15469: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

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

15463: p_constraint_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
15464: p_constraint_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15465: p_sch_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15466: -- update_task_det_sch_info
15467: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15468: p_percent_complete_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15469: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15470: p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15471: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

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

15464: p_constraint_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
15465: p_sch_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15466: -- update_task_det_sch_info
15467: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15468: p_percent_complete_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15469: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15470: p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15471: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15472: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

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

15465: p_sch_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15466: -- update_task_det_sch_info
15467: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15468: p_percent_complete_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15469: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15470: p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15471: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15472: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15473: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

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

15466: -- update_task_det_sch_info
15467: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15468: p_percent_complete_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15469: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15470: p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15471: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15472: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15473: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15474: -- Update_Task_Weighting

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

15467: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15468: p_percent_complete_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15469: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15470: p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15471: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15472: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15473: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15474: -- Update_Task_Weighting
15475: p_object_relationship_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

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

15468: p_percent_complete_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15469: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15470: p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15471: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15472: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15473: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15474: -- Update_Task_Weighting
15475: p_object_relationship_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15476: p_weighting_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

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

15469: p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15470: p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15471: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15472: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15473: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15474: -- Update_Task_Weighting
15475: p_object_relationship_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15476: p_weighting_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15477: p_obj_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

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

15471: p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15472: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15473: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15474: -- Update_Task_Weighting
15475: p_object_relationship_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15476: p_weighting_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15477: p_obj_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15478: p_task_weight_method IN VARCHAR2,
15479: -- common

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

15472: p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15473: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15474: -- Update_Task_Weighting
15475: p_object_relationship_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15476: p_weighting_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15477: p_obj_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15478: p_task_weight_method IN VARCHAR2,
15479: -- common
15480: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

15473: p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15474: -- Update_Task_Weighting
15475: p_object_relationship_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15476: p_weighting_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15477: p_obj_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
15478: p_task_weight_method IN VARCHAR2,
15479: -- common
15480: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
15481: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 15966: ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

15962: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
15963: ,p_project_id IN NUMBER
15964: ,p_structure_version_id IN NUMBER
15965: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
15966: ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
15967: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
15968: ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE
15969: ,x_return_status OUT NOCOPY VARCHAR2
15970: ,x_msg_count OUT NOCOPY NUMBER

Line 15967: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE

15963: ,p_project_id IN NUMBER
15964: ,p_structure_version_id IN NUMBER
15965: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
15966: ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
15967: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
15968: ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE
15969: ,x_return_status OUT NOCOPY VARCHAR2
15970: ,x_msg_count OUT NOCOPY NUMBER
15971: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 15968: ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE

15964: ,p_structure_version_id IN NUMBER
15965: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
15966: ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
15967: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
15968: ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE
15969: ,x_return_status OUT NOCOPY VARCHAR2
15970: ,x_msg_count OUT NOCOPY NUMBER
15971: ,x_msg_data OUT NOCOPY VARCHAR2)
15972: IS

Line 16198: ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

16194: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16195: ,p_project_id IN NUMBER
16196: ,p_structure_version_id IN NUMBER
16197: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
16198: ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16199: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16200: ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16201: ,x_return_status OUT NOCOPY VARCHAR2
16202: ,x_msg_count OUT NOCOPY NUMBER

Line 16199: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE

16195: ,p_project_id IN NUMBER
16196: ,p_structure_version_id IN NUMBER
16197: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
16198: ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16199: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16200: ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16201: ,x_return_status OUT NOCOPY VARCHAR2
16202: ,x_msg_count OUT NOCOPY NUMBER
16203: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 16200: ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE

16196: ,p_structure_version_id IN NUMBER
16197: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
16198: ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16199: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16200: ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE
16201: ,x_return_status OUT NOCOPY VARCHAR2
16202: ,x_msg_count OUT NOCOPY NUMBER
16203: ,x_msg_data OUT NOCOPY VARCHAR2)
16204: IS