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 2738: FROM pa_project_statuses

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

Line 4735: FROM pa_project_statuses

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

Line 5153: SELECT project_status_name from pa_project_statuses

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

Line 5161: SELECT project_status_name from pa_project_statuses

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

Line 5169: SELECT project_status_code from pa_project_statuses

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

Line 5177: SELECT project_status_code from pa_project_statuses

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

Line 5406: -- pa_project_statuses table

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

Line 5444: -- pa_project_statuses table

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

Line 5817: FROM pa_project_statuses

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

Line 6324: FROM pa_project_statuses

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

Line 6330: FROM pa_project_statuses

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

Line 6334: l_dummy_sys_code pa_project_statuses.project_system_status_code%TYPE;

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

Line 8008: l_apprvl_sys_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;

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

Line 8013: FROM pa_project_statuses

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

Line 9724: FROM pa_project_statuses

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

Line 10248: FROM pa_project_statuses

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

Line 10912: FROM pa_project_statuses

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

Line 11487: FROM pa_project_statuses

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

Line 12063: FROM pa_project_statuses

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

Line 12558: FROM pa_project_statuses

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

Line 13139: SELECT project_system_status_code FROM pa_project_statuses

13135: l_msg_index_out NUMBER;
13136: l_data VARCHAR2(2000);
13137:
13138: CURSOR c_get_system_status_code(c_status_code VARCHAR2) IS
13139: SELECT project_system_status_code FROM pa_project_statuses
13140: WHERE trunc(SYSDATE) BETWEEN start_date_active AND nvl(end_date_active, trunc(SYSDATE))
13141: AND status_type = 'CANDIDATE'
13142: AND project_status_code = c_status_code;
13143:

Line 14085: SELECT project_system_status_code FROM pa_project_statuses

14081: WHERE pc.candidate_id = c_candidate_id
14082: AND pcv.candidate_number = c_candidate_id;
14083:
14084: CURSOR c_get_system_status_code(c_status_code VARCHAR2) IS
14085: SELECT project_system_status_code FROM pa_project_statuses
14086: WHERE trunc(SYSDATE) BETWEEN start_date_active AND nvl(end_date_active, trunc(SYSDATE))
14087: AND status_type = 'CANDIDATE'
14088: AND project_status_code = c_status_code;
14089: