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_ASGMT_WFSTD dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 4402: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type

4398: PROCEDURE process_approval_result
4399: ( p_project_id IN NUMBER
4400: ,p_mode IN VARCHAR2
4401: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
4402: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4403: ,p_group_id IN NUMBER
4404: ,p_approver_group_id IN NUMBER
4405: ,p_routing_order IN NUMBER
4406: ,p_num_of_assignments IN NUMBER

Line 5897: l_recipients_tbl SYSTEM.pa_varchar2_240_tbl_type; /Commented SYSTEM.pa_varchar2_30_tbl_type for the bug 3311991/

5893: l_err_code NUMBER := 0;
5894: l_err_stage VARCHAR2(2000);
5895: l_err_stack VARCHAR2(2000);
5896: l_assignment_id NUMBER;
5897: l_recipients_tbl SYSTEM.pa_varchar2_240_tbl_type; /*Commented SYSTEM.pa_varchar2_30_tbl_type for the bug 3311991*/
5898: l_recipients_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
5899:
5900: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5901: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

Line 5898: l_recipients_type_tbl SYSTEM.pa_varchar2_30_tbl_type;

5894: l_err_stage VARCHAR2(2000);
5895: l_err_stack VARCHAR2(2000);
5896: l_assignment_id NUMBER;
5897: l_recipients_tbl SYSTEM.pa_varchar2_240_tbl_type; /*Commented SYSTEM.pa_varchar2_30_tbl_type for the bug 3311991*/
5898: l_recipients_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
5899:
5900: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5901: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5902: l_number_of_recipients NUMBER := 0;

Line 6455: l_approval_status_tbl SYSTEM.pa_varchar2_30_tbl_type:= SYSTEM.pa_varchar2_30_tbl_type();

6451:
6452: l_project_id pa_project_assignments.project_id%TYPE;
6453: l_mode VARCHAR2(30);
6454: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6455: l_approval_status_tbl SYSTEM.pa_varchar2_30_tbl_type:= SYSTEM.pa_varchar2_30_tbl_type();
6456: l_group_id NUMBER;
6457: l_approver_group_id NUMBER;
6458: l_routing_order NUMBER;
6459: l_num_assignments NUMBER;

Line 6867: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type

6863: PROCEDURE process_approval_result
6864: ( p_project_id IN NUMBER
6865: ,p_mode IN VARCHAR2
6866: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
6867: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type
6868: ,p_group_id IN NUMBER
6869: ,p_approver_group_id IN NUMBER
6870: ,p_routing_order IN NUMBER
6871: ,p_num_of_assignments IN NUMBER

Line 7838: l_approval_status_tbl SYSTEM.pa_varchar2_30_tbl_type:= SYSTEM.pa_varchar2_30_tbl_type();

7834:
7835: l_project_id pa_project_assignments.project_id%TYPE;
7836: l_mode VARCHAR2(30);
7837: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7838: l_approval_status_tbl SYSTEM.pa_varchar2_30_tbl_type:= SYSTEM.pa_varchar2_30_tbl_type();
7839: l_group_id NUMBER;
7840: l_approver_group_id NUMBER;
7841: l_routing_order NUMBER;
7842: l_num_assignments NUMBER;