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

Line 38607: P_TASK_ID_TBL IN SYSTEM.PA_NUM_TBL_TYPE,

38603: P_API_VERSION_NUMBER IN NUMBER,
38604: P_COMMIT IN VARCHAR2,
38605: P_INIT_MSG_LIST IN VARCHAR2,
38606: P_PA_PROJECT_ID IN NUMBER,
38607: P_TASK_ID_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
38608: P_SERVICE_TYPE_CODE_TBL IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE,
38609: P_CHARGEABLE_FLAG_TBL IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE,
38610: P_BILLABLE_FLAG_TBL IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE,
38611: X_MSG_COUNT OUT NOCOPY NUMBER,

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

39588: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
39589: p_debug_mode IN VARCHAR2 := 'N',
39590: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
39591: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
39592: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
39593: p_ref_task_version_id IN NUMBER,
39594: p_ref_project_id IN NUMBER,
39595: p_peer_or_sub IN VARCHAR2,
39596: p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

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

39592: p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
39593: p_ref_task_version_id IN NUMBER,
39594: p_ref_project_id IN NUMBER,
39595: p_peer_or_sub IN VARCHAR2,
39596: p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
39597: x_return_status OUT NOCOPY VARCHAR2,
39598: x_msg_count OUT NOCOPY NUMBER,
39599: x_msg_data OUT NOCOPY VARCHAR2
39600: )

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

40174: and a.object_type_from = 'PA_STRUCTURES';
40175: l_old_par_ver_id NUMBER;
40176: l_new_par_ver_id NUMBER;
40177:
40178: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
40179: l_lowest_task_flag1 VARCHAR2(1);
40180: l_lowest_task_flag2 VARCHAR2(1);
40181: l_fin_task_flag VARCHAR2(1);
40182:

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

41225: --now call call delete planning for task version id.
41226: l_task_ver_ids2.extend(1);
41227: l_task_ver_ids2(1) := p_task_version_id;
41228: DECLARE
41229: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
41230: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
41231: SELECT resource_assignment_id
41232: FROM pa_resource_assignments
41233: WHERE wbs_element_Version_id = c_task_ver_id

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

41649: and a.object_type_from = 'PA_STRUCTURES';
41650: l_old_par_ver_id NUMBER;
41651: l_new_par_ver_id NUMBER;
41652:
41653: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
41654: l_lowest_task_flag1 VARCHAR2(1);
41655: l_lowest_task_flag2 VARCHAR2(1);
41656: l_fin_task_flag VARCHAR2(1);
41657: l_ref_parent_task_id NUMBER;

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

42744: /*Smukka Bug No. 3474141 Date 03/01/2004 */
42745: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
42746: DECLARE
42747: --p1 bug 3888432
42748: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
42749: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
42750: SELECT resource_assignment_id
42751: FROM pa_resource_assignments
42752: WHERE wbs_element_Version_id = c_task_ver_id

Line 43296: l_Proj_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();

43292: IS
43293: l_return_status varchar2(100);
43294:
43295: l_debug_mode varchar2(1) :='N';
43296: l_Proj_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43297: l_Cbs_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43298:
43299: l_project_id Number :=p_pa_project_id;
43300: l_cbs_enabled_flag varchar2(1) :='N';

Line 43297: l_Cbs_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();

43293: l_return_status varchar2(100);
43294:
43295: l_debug_mode varchar2(1) :='N';
43296: l_Proj_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43297: l_Cbs_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43298:
43299: l_project_id Number :=p_pa_project_id;
43300: l_cbs_enabled_flag varchar2(1) :='N';
43301: l_count Number :=0;

Line 43345: lp_Proj_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();

43341:
43342: duplicate Varchar2(1);
43343: j Number;
43344: counter Number;
43345: lp_Proj_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43346: lp_Cbs_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43347:
43348:
43349:

Line 43346: lp_Cbs_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();

43342: duplicate Varchar2(1);
43343: j Number;
43344: counter Number;
43345: lp_Proj_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43346: lp_Cbs_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43347:
43348:
43349:
43350:

Line 43593: l_Proj_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();

43589: IS
43590: l_return_status varchar2(100);
43591:
43592: l_debug_mode varchar2(1) :='N';
43593: l_Proj_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43594: l_Cbs_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43595: l_Alt_Task_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43596:
43597: l_project_id Number :=p_pa_project_id;

Line 43594: l_Cbs_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();

43590: l_return_status varchar2(100);
43591:
43592: l_debug_mode varchar2(1) :='N';
43593: l_Proj_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43594: l_Cbs_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43595: l_Alt_Task_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43596:
43597: l_project_id Number :=p_pa_project_id;
43598: l_cbs_enabled_flag varchar2(1) :='N';

Line 43595: l_Alt_Task_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();

43591:
43592: l_debug_mode varchar2(1) :='N';
43593: l_Proj_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43594: l_Cbs_Element_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43595: l_Alt_Task_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
43596:
43597: l_project_id Number :=p_pa_project_id;
43598: l_cbs_enabled_flag varchar2(1) :='N';
43599: l_count Number :=0;