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_PVT1 dependencies on PA_NUM_TBL_TYPE

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

5534: AND relationship_type = 'M';
5535:
5536: l_fp_task_version_id PA_OBJECT_RELATIONSHIPS.object_id_to1%TYPE;
5537: /* Bug #: 3305199 SMukka */
5538: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
5539: /* l_element_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; */
5540: l_element_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
5541: l_wp_str_exists VARCHAR2(1);
5542: --skannoji

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

5536: l_fp_task_version_id PA_OBJECT_RELATIONSHIPS.object_id_to1%TYPE;
5537: /* Bug #: 3305199 SMukka */
5538: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
5539: /* l_element_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; */
5540: l_element_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
5541: l_wp_str_exists VARCHAR2(1);
5542: --skannoji
5543: --
5544: --Bug No 3450684 Smukka For Subproject Association

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

5593: l_structure_type_fin varchar2(1);
5594: -- 4201927 end
5595:
5596: -- 4221374 Added following local variables for perf fix
5597: l_task_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5598: task_index NUMBER;
5599: -- 4221374 end
5600:
5601: -- Begin fix for Bug # 4506308.

Line 6404: l_alt_task_Ids SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();

6400: * deleting the alt_task_id corresponding to the tasks that are being removed.
6401: */
6402:
6403: Declare
6404: l_alt_task_Ids SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();
6405: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE(); --bug#16461684
6406: cursor alt_task_cur ( l_task_id pa_tasks.task_id%TYPE )
6407: is
6408: select alt_task_id from pa_alternate_tasks

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

7933: l_Structure_Version_ID NUMBER; -- FP_M changes 3305199
7934:
7935: --bug 3301192 fp changes
7936: /* Bug #: 3305199 SMukka */
7937: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
7938: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
7939: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7940: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7941: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */

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

7935: --bug 3301192 fp changes
7936: /* Bug #: 3305199 SMukka */
7937: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
7938: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
7939: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7940: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7941: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
7942: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
7943:

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

7936: /* Bug #: 3305199 SMukka */
7937: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
7938: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
7939: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7940: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7941: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
7942: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
7943:
7944: --hsiu: 3453772

Line 7946: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

7942: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
7943:
7944: --hsiu: 3453772
7945: l_old_sch_date DATE;
7946: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
7947: l_planning_start_tbl SYSTEM.pa_date_tbl_type;
7948: l_planning_end_tbl SYSTEM.pa_date_tbl_type;
7949:
7950: l_ext_act_duration NUMBER;

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

9741: AND relationship_type = 'M';
9742:
9743: l_fp_task_version_id PA_OBJECT_RELATIONSHIPS.object_id_to1%TYPE;
9744: /* Bug #: 3305199 SMukka */
9745: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
9746: /* l_element_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; */
9747: l_element_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
9748: --skannoji
9749: --

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

9743: l_fp_task_version_id PA_OBJECT_RELATIONSHIPS.object_id_to1%TYPE;
9744: /* Bug #: 3305199 SMukka */
9745: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
9746: /* l_element_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; */
9747: l_element_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
9748: --skannoji
9749: --
9750: --Bug No 3450684 Smukka For Subproject Association
9751: CURSOR get_subproj_relation(cp_task_ver_id NUMBER) IS