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 4401: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type

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

Line 5861: ( p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type

5857: * assignment and populating pa_wf_ntf_performers table
5858: * Notifications are then sent to recipients from the pa_wf_ntf_performers table
5859: */
5860: PROCEDURE process_mgr_fyi_notification
5861: ( p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
5862: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
5863: ,p_group_id IN NUMBER := FND_API.G_MISS_NUM
5864: ,p_mode IN VARCHAR2
5865: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 5922: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;

5918: l_num_rej_asgns NUMBER ;
5919: l_display_name wf_users.display_name%TYPE; --VARCHAR2(360); Commented VARCHAR2(360) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991
5920: l_approver_name wf_users.display_name%TYPE; --VARCHAR2(320); Commented VARCHAR2(320) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991
5921: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
5922: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
5923:
5924: CURSOR Resource_Manager IS
5925: SELECT distinct res.manager_id
5926: FROM pa_resources_denorm res,

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

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

Line 6866: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type

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

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

6879: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
6880: l_change_id NUMBER;
6881: l_action_code VARCHAR2(30);
6882: l_approver_group_id NUMBER;
6883: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6884: l_msg_index_out NUMBER;
6885: l_msg_count NUMBER;
6886: l_msg_data VARCHAR2(2000);
6887: l_return_status VARCHAR2(1);

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

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

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

8057: l_resource_id pa_resources_denorm.resource_id%TYPE;
8058: l_return_status VARCHAR2(1);
8059: l_group_id NUMBER;
8060: l_project_id NUMBER;
8061: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8062:
8063: BEGIN
8064:
8065: log_message('Inside Abort_Remaining_Trx');