DBA Data[Home] [Help]

APPS.PA_TASK_PVT1 dependencies on PA_NUM_TBL_TYPE

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

5034: AND relationship_type = 'M';
5035:
5036: l_fp_task_version_id PA_OBJECT_RELATIONSHIPS.object_id_to1%TYPE;
5037: /* Bug #: 3305199 SMukka */
5038: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
5039: /* l_element_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; */
5040: l_element_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
5041: l_wp_str_exists VARCHAR2(1);
5042: --skannoji

Line 5040: l_element_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

5036: l_fp_task_version_id PA_OBJECT_RELATIONSHIPS.object_id_to1%TYPE;
5037: /* Bug #: 3305199 SMukka */
5038: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
5039: /* l_element_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; */
5040: l_element_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
5041: l_wp_str_exists VARCHAR2(1);
5042: --skannoji
5043: --
5044: --Bug No 3450684 Smukka For Subproject Association

Line 5097: l_task_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

5093: l_structure_type_fin varchar2(1);
5094: -- 4201927 end
5095:
5096: -- 4221374 Added following local variables for perf fix
5097: l_task_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5098: task_index NUMBER;
5099: -- 4221374 end
5100:
5101: -- Begin fix for Bug # 4506308.

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

7330: l_Structure_Version_ID NUMBER; -- FP_M changes 3305199
7331:
7332: --bug 3301192 fp changes
7333: /* Bug #: 3305199 SMukka */
7334: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
7335: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
7336: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7337: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7338: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */

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

7332: --bug 3301192 fp changes
7333: /* Bug #: 3305199 SMukka */
7334: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
7335: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
7336: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7337: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7338: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
7339: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
7340:

Line 7337: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

7333: /* Bug #: 3305199 SMukka */
7334: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
7335: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
7336: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7337: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7338: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
7339: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
7340:
7341: --hsiu: 3453772

Line 7343: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

7339: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
7340:
7341: --hsiu: 3453772
7342: l_old_sch_date DATE;
7343: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
7344: l_planning_start_tbl SYSTEM.pa_date_tbl_type;
7345: l_planning_end_tbl SYSTEM.pa_date_tbl_type;
7346:
7347: l_ext_act_duration NUMBER;

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

8995: AND relationship_type = 'M';
8996:
8997: l_fp_task_version_id PA_OBJECT_RELATIONSHIPS.object_id_to1%TYPE;
8998: /* Bug #: 3305199 SMukka */
8999: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
9000: /* l_element_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; */
9001: l_element_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
9002: --skannoji
9003: --

Line 9001: l_element_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

8997: l_fp_task_version_id PA_OBJECT_RELATIONSHIPS.object_id_to1%TYPE;
8998: /* Bug #: 3305199 SMukka */
8999: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
9000: /* l_element_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; */
9001: l_element_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
9002: --skannoji
9003: --
9004: --Bug No 3450684 Smukka For Subproject Association
9005: CURSOR get_subproj_relation(cp_task_ver_id NUMBER) IS