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_RES_MANAGEMENT_AMG_PUB dependencies on PA_PROJECT_STATUSES

Line 2739: FROM pa_project_statuses

2735: AND assignment_id = c_requirement_id;
2736:
2737: CURSOR c_get_system_status_code(c_status_code VARCHAR2, c_status_type VARCHAR2) IS
2738: SELECT project_system_status_code
2739: FROM pa_project_statuses
2740: WHERE status_type = c_status_type
2741: AND project_status_code = c_status_code;
2742:
2743: CURSOR c_get_location(c_location_id NUMBER) IS

Line 4736: FROM pa_project_statuses

4732: AND ASSIGNMENT_TYPE = l_assignment_type ;
4733:
4734: CURSOR c_get_system_status IS
4735: SELECT PROJECT_SYSTEM_STATUS_CODE
4736: FROM pa_project_statuses
4737: WHERE project_status_code = l_status_code
4738: AND status_type = 'OPEN_ASGMT';
4739:
4740: BEGIN

Line 5154: SELECT project_status_name from pa_project_statuses

5150: FROM pa_project_assignments
5151: WHERE assignment_id = c_source_reqmt_id ;
5152:
5153: CURSOR c_valid_status_code IS
5154: SELECT project_status_name from pa_project_statuses
5155: where
5156: status_type = 'STAFFED_ASGMT'
5157: and project_status_code = l_assignment_status_code
5158: and trunc(SYSDATE) between start_date_active and nvl(end_date_active, trunc(SYSDATE))

Line 5162: SELECT project_status_name from pa_project_statuses

5158: and trunc(SYSDATE) between start_date_active and nvl(end_date_active, trunc(SYSDATE))
5159: and starting_status_flag = 'Y' and project_system_status_code <> 'STAFFED_ASGMT_CONF';
5160:
5161: CURSOR c_valid_unfilled_status_code IS
5162: SELECT project_status_name from pa_project_statuses
5163: where
5164: status_type = 'OPEN_ASGMT'
5165: and project_status_code = l_unfilled_assign_status_code
5166: and trunc(SYSDATE) between start_date_active and nvl(end_date_active, trunc(SYSDATE))

Line 5170: SELECT project_status_code from pa_project_statuses

5166: and trunc(SYSDATE) between start_date_active and nvl(end_date_active, trunc(SYSDATE))
5167: and starting_status_flag = 'Y' ;
5168:
5169: CURSOR c_valid_status_name IS
5170: SELECT project_status_code from pa_project_statuses
5171: where
5172: status_type = 'STAFFED_ASGMT'
5173: and project_status_name = l_assignment_status_name
5174: and trunc(SYSDATE) between start_date_active and nvl(end_date_active, trunc(SYSDATE))

Line 5178: SELECT project_status_code from pa_project_statuses

5174: and trunc(SYSDATE) between start_date_active and nvl(end_date_active, trunc(SYSDATE))
5175: and starting_status_flag = 'Y' and project_system_status_code <> 'STAFFED_ASGMT_CONF';
5176:
5177: CURSOR c_valid_unfilled_status_name IS
5178: SELECT project_status_code from pa_project_statuses
5179: where
5180: status_type = 'OPEN_ASGMT'
5181: and project_status_name = l_unfilled_assign_status_name
5182: and trunc(SYSDATE) between start_date_active and nvl(end_date_active, trunc(SYSDATE))

Line 5407: -- pa_project_statuses table

5403:
5404: -- 2) Assignment Status Code Validation
5405: IF l_assignment_status_code IS NOT NULL THEN
5406: -- Anusha : Existing API just checks whether the status code name exists in
5407: -- pa_project_statuses table
5408:
5409: -- It does not check whether the status is a valid starting status and not
5410: -- Confirmed etc.
5411:

Line 5445: -- pa_project_statuses table

5441: -- 3) Validate the unfilled open assignment status value passed
5442: IF l_unfilled_assign_status_code is not NULL THEN
5443:
5444: -- Anusha : Existing API just checks whether the status code name exists in
5445: -- pa_project_statuses table
5446:
5447: -- It does not check whether the status is a valid starting status and
5448: -- whether its a status specific to Open Requirements .
5449: -- In SS ,this condition is controlled by Poplist query.So,here we need to

Line 5818: FROM pa_project_statuses

5814: WHERE assignment_id = p_req_asgn_id ;
5815:
5816: CURSOR c_get_system_status IS
5817: SELECT PROJECT_SYSTEM_STATUS_CODE
5818: FROM pa_project_statuses
5819: WHERE project_status_code = l_status_code
5820: AND status_type in ('OPEN_ASGMT','STAFFED_ASGMT');
5821:
5822: l_system_status_code VARCHAR2(30);

Line 6325: FROM pa_project_statuses

6321:
6322: -- Bug 5175060
6323: CURSOR c_get_system_status_code(c_status_code VARCHAR2, c_status_type VARCHAR2) IS
6324: SELECT project_system_status_code,starting_status_flag
6325: FROM pa_project_statuses
6326: WHERE status_type = c_status_type
6327: AND project_status_code = c_status_code;
6328:
6329: CURSOR c_get_sys_code_from_name(c_status_name VARCHAR2, c_status_type VARCHAR2) IS

Line 6331: FROM pa_project_statuses

6327: AND project_status_code = c_status_code;
6328:
6329: CURSOR c_get_sys_code_from_name(c_status_name VARCHAR2, c_status_type VARCHAR2) IS
6330: SELECT project_system_status_code,starting_status_flag
6331: FROM pa_project_statuses
6332: WHERE status_type = c_status_type
6333: AND project_status_name = c_status_name;
6334:
6335: l_dummy_sys_code pa_project_statuses.project_system_status_code%TYPE;

Line 6335: l_dummy_sys_code pa_project_statuses.project_system_status_code%TYPE;

6331: FROM pa_project_statuses
6332: WHERE status_type = c_status_type
6333: AND project_status_name = c_status_name;
6334:
6335: l_dummy_sys_code pa_project_statuses.project_system_status_code%TYPE;
6336: --End 5175060
6337:
6338: l_starting_status_flag VARCHAR2(1);
6339:

Line 8010: l_apprvl_sys_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;

8006: l_assignment_id PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_ID%TYPE;
8007: l_record_version_number PA_PROJECT_ASSIGNMENTS.RECORD_VERSION_NUMBER%TYPE;
8008: l_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
8009: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;
8010: l_apprvl_sys_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
8011: l_mass_wf_in_progress_flag PA_PROJECT_ASSIGNMENTS.MASS_WF_IN_PROGRESS_FLAG%TYPE ;
8012:
8013: CURSOR c_sys_status_code(l_in_status_code IN VARCHAR2 ) IS
8014: SELECT project_system_status_code

Line 8015: FROM pa_project_statuses

8011: l_mass_wf_in_progress_flag PA_PROJECT_ASSIGNMENTS.MASS_WF_IN_PROGRESS_FLAG%TYPE ;
8012:
8013: CURSOR c_sys_status_code(l_in_status_code IN VARCHAR2 ) IS
8014: SELECT project_system_status_code
8015: FROM pa_project_statuses
8016: WHERE project_status_code = l_in_status_code
8017: AND status_type= 'ASGMT_APPRVL';
8018:
8019: CURSOR c_asgn_db_values IS

Line 9726: FROM pa_project_statuses

9722: AND assignment_type <> 'OPEN_ASSIGNMENT' ;
9723:
9724: CURSOR cur_get_system_status(l_status_code VARCHAR2 ) IS
9725: SELECT PROJECT_SYSTEM_STATUS_CODE
9726: FROM pa_project_statuses
9727: WHERE project_status_code = l_status_code ;
9728:
9729: BEGIN
9730:

Line 10250: FROM pa_project_statuses

10246: WHERE pf.person_id = p_person_id);
10247:
10248: CURSOR c_sys_status_code(l_in_status_code IN VARCHAR2 ) IS
10249: SELECT project_system_status_code
10250: FROM pa_project_statuses
10251: WHERE project_status_code = l_in_status_code
10252: AND status_type= 'ASGMT_APPRVL';
10253:
10254: BEGIN

Line 10914: FROM pa_project_statuses

10910:
10911: -- This cursor is used to get the system status code of the Given Requirement
10912: CURSOR cur_status_code(l_status_code VARCHAR2 ) IS
10913: SELECT project_system_status_code
10914: FROM pa_project_statuses
10915: WHERE project_status_code = l_status_code
10916: AND status_type= 'OPEN_ASGMT';
10917:
10918: BEGIN

Line 11489: FROM pa_project_statuses

11485: -- To get the project system status code for
11486: -- perticular requirement.
11487: CURSOR cur_status_code(l_status_code VARCHAR2 ) IS
11488: SELECT project_system_status_code
11489: FROM pa_project_statuses
11490: WHERE project_status_code = l_status_code;
11491:
11492: -- To Hold the values used.
11493: l_cur_competence_in_rec PA_OPEN_ASGMT_COMPETENCES_V%ROWTYPE;

Line 12065: FROM pa_project_statuses

12061: -- To get the project system status code for
12062: -- perticular requirement.
12063: CURSOR cur_status_code(l_status_code VARCHAR2 ) IS
12064: SELECT project_system_status_code
12065: FROM pa_project_statuses
12066: WHERE project_status_code = l_status_code
12067: AND status_type= 'OPEN_ASGMT';
12068:
12069: -- Record type

Line 12560: FROM pa_project_statuses

12556: AND assignment_type = 'OPEN_ASSIGNMENT';
12557:
12558: CURSOR c_get_system_status_code(c_status_code VARCHAR2, c_status_type VARCHAR2) IS
12559: SELECT project_system_status_code
12560: FROM pa_project_statuses
12561: WHERE trunc(SYSDATE) BETWEEN start_date_active AND nvl(end_date_active, trunc(SYSDATE))
12562: AND status_type = c_status_type
12563: AND project_status_code = c_status_code;
12564:

Line 13160: SELECT project_system_status_code FROM pa_project_statuses

13156: l_msg_index_out NUMBER;
13157: l_data VARCHAR2(2000);
13158:
13159: CURSOR c_get_system_status_code(c_status_code VARCHAR2) IS
13160: SELECT project_system_status_code FROM pa_project_statuses
13161: WHERE trunc(SYSDATE) BETWEEN start_date_active AND nvl(end_date_active, trunc(SYSDATE))
13162: AND status_type = 'CANDIDATE'
13163: AND project_status_code = c_status_code;
13164:

Line 14123: SELECT project_system_status_code FROM pa_project_statuses

14119: WHERE pc.candidate_id = c_candidate_id
14120: AND pcv.candidate_number = c_candidate_id;
14121:
14122: CURSOR c_get_system_status_code(c_status_code VARCHAR2) IS
14123: SELECT project_system_status_code FROM pa_project_statuses
14124: WHERE trunc(SYSDATE) BETWEEN start_date_active AND nvl(end_date_active, trunc(SYSDATE))
14125: AND status_type = 'CANDIDATE'
14126: AND project_status_code = c_status_code;
14127: