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_NUM_TBL_TYPE

Line 4416: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type

4412: --Begin Forward declaration
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

Line 5877: ( p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type

5873: * assignment and populating pa_wf_ntf_performers table
5874: * Notifications are then sent to recipients from the pa_wf_ntf_performers table
5875: */
5876: PROCEDURE process_mgr_fyi_notification
5877: ( p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
5878: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
5879: ,p_group_id IN NUMBER := FND_API.G_MISS_NUM
5880: ,p_mode IN VARCHAR2
5881: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 5938: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;

5934: l_num_rej_asgns NUMBER ;
5935: l_display_name wf_users.display_name%TYPE; --VARCHAR2(360); Commented VARCHAR2(360) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991
5936: l_approver_name wf_users.display_name%TYPE; --VARCHAR2(320); Commented VARCHAR2(320) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991
5937: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
5938: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
5939:
5940: CURSOR Resource_Manager IS
5941: SELECT distinct res.manager_id
5942: FROM pa_resources_denorm res,

Line 6470: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

6466: x_msg_data VARCHAR2(2000);
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;

Line 6882: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type

6878: -------------------------------------------------------------------
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

Line 6899: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

6895: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
6896: l_change_id NUMBER;
6897: l_action_code VARCHAR2(30);
6898: l_approver_group_id NUMBER;
6899: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6900: l_msg_index_out NUMBER;
6901: l_msg_count NUMBER;
6902: l_msg_data VARCHAR2(2000);
6903: l_return_status VARCHAR2(1);

Line 7853: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

7849: IS
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;

Line 8077: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

8073: l_resource_id pa_resources_denorm.resource_id%TYPE;
8074: l_return_status VARCHAR2(1);
8075: l_group_id NUMBER;
8076: l_project_id NUMBER;
8077: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8078:
8079: BEGIN
8080:
8081: log_message('Inside Abort_Remaining_Trx');