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_PROJECT_STRUCTURE_PVT1 dependencies on PA_NUM_1000_NUM

Line 3166: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

3162: l_proj_completion_date DATE;
3163: l_prefix VARCHAR2(80);
3164:
3165: --Hsiu added for date rollup
3166: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
3167:
3168: --hsiu added for advanced structure changes
3169: cursor sel_other_structure_ver(c_keep_struc_ver_id NUMBER) IS
3170: select b.element_version_id, b.record_version_number

Line 3201: -- Replacing this varray PA_NUM_1000_NUM with t_TBDtasksTable index table.

3197: l_error_message_code VARCHAR2(250);
3198: l_create_task_ver_flag varchar2(1);
3199:
3200: -- Bug # 4691749.
3201: -- Replacing this varray PA_NUM_1000_NUM with t_TBDtasksTable index table.
3202: TYPE t_TBD_tasksTable IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3203: --l_tbd_task_ver_id PA_NUM_1000_NUM := PA_NUM_1000_NUM(); --replacing this varray with t_TBDtasksTable index table.
3204: l_tbd_task_ver_id t_TBD_tasksTable;
3205: l_tbd_index NUMBER := 0;

Line 3203: --l_tbd_task_ver_id PA_NUM_1000_NUM := PA_NUM_1000_NUM(); --replacing this varray with t_TBDtasksTable index table.

3199:
3200: -- Bug # 4691749.
3201: -- Replacing this varray PA_NUM_1000_NUM with t_TBDtasksTable index table.
3202: TYPE t_TBD_tasksTable IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3203: --l_tbd_task_ver_id PA_NUM_1000_NUM := PA_NUM_1000_NUM(); --replacing this varray with t_TBDtasksTable index table.
3204: l_tbd_task_ver_id t_TBD_tasksTable;
3205: l_tbd_index NUMBER := 0;
3206: -- Bug # 4691749.
3207:

Line 3210: l_tbd_task_id PA_NUM_1000_NUM := PA_NUM_1000_NUM();

3206: -- Bug # 4691749.
3207:
3208: -- Added for 4096218
3209: -- This VARRAY will hold the list of to_be_deleted tasks' proj_element_ids
3210: l_tbd_task_id PA_NUM_1000_NUM := PA_NUM_1000_NUM();
3211:
3212: l_del_task_cnt NUMBER;
3213:
3214: CURSOR get_tbd_tasks_info(c_task_ver_id NUMBER) IS

Line 9874: -- l_task_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

9870: l_completion_date DATE;
9871: l_object_type VARCHAR2(30);
9872: l_task_ver_id NUMBER;
9873: /* Bug 2790703 Begin */
9874: -- l_task_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
9875: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;
9876: l_index number :=0 ;
9877: /* Bug 2790703 End */
9878:

Line 14225: -- l_task_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

14221: l_completion_date DATE;
14222: l_object_type VARCHAR2(30);
14223: l_task_ver_id NUMBER;
14224: /* Bug 2790703 Begin */
14225: -- l_task_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
14226: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;
14227: l_index number :=0 ;
14228: /* Bug 2790703 End */
14229: