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 4417: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type

4413: PROCEDURE process_approval_result
4414: ( p_project_id IN NUMBER
4415: ,p_mode IN VARCHAR2
4416: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
4417: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4418: ,p_group_id IN NUMBER
4419: ,p_approver_group_id IN NUMBER
4420: ,p_routing_order IN NUMBER
4421: ,p_num_of_assignments IN NUMBER

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

5909: l_err_code NUMBER := 0;
5910: l_err_stage VARCHAR2(2000);
5911: l_err_stack VARCHAR2(2000);
5912: l_assignment_id NUMBER;
5913: l_recipients_tbl SYSTEM.pa_varchar2_240_tbl_type; /*Commented SYSTEM.pa_varchar2_30_tbl_type for the bug 3311991*/
5914: l_recipients_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
5915:
5916: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5917: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

Line 5914: l_recipients_type_tbl SYSTEM.pa_varchar2_30_tbl_type;

5910: l_err_stage VARCHAR2(2000);
5911: l_err_stack VARCHAR2(2000);
5912: l_assignment_id NUMBER;
5913: l_recipients_tbl SYSTEM.pa_varchar2_240_tbl_type; /*Commented SYSTEM.pa_varchar2_30_tbl_type for the bug 3311991*/
5914: l_recipients_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
5915:
5916: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5917: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5918: l_number_of_recipients NUMBER := 0;

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

6467:
6468: l_project_id pa_project_assignments.project_id%TYPE;
6469: l_mode VARCHAR2(30);
6470: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6471: l_approval_status_tbl SYSTEM.pa_varchar2_30_tbl_type:= SYSTEM.pa_varchar2_30_tbl_type();
6472: l_group_id NUMBER;
6473: l_approver_group_id NUMBER;
6474: l_routing_order NUMBER;
6475: l_num_assignments NUMBER;

Line 6883: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type

6879: PROCEDURE process_approval_result
6880: ( p_project_id IN NUMBER
6881: ,p_mode IN VARCHAR2
6882: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
6883: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type
6884: ,p_group_id IN NUMBER
6885: ,p_approver_group_id IN NUMBER
6886: ,p_routing_order IN NUMBER
6887: ,p_num_of_assignments IN NUMBER

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

7850:
7851: l_project_id pa_project_assignments.project_id%TYPE;
7852: l_mode VARCHAR2(30);
7853: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7854: l_approval_status_tbl SYSTEM.pa_varchar2_30_tbl_type:= SYSTEM.pa_varchar2_30_tbl_type();
7855: l_group_id NUMBER;
7856: l_approver_group_id NUMBER;
7857: l_routing_order NUMBER;
7858: l_num_assignments NUMBER;