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_ASSIGNMENTS

Line 341: -- Reference: pa_project_assignments.assignment_id

337: -- Table of requirement records. Please see the REQUIREMENT_IN_TBL_TYPE datatype table.
338: -- OUT :
339: -- x_requirement_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE
340: -- Table to store requirement_ids created by the API.
341: -- Reference: pa_project_assignments.assignment_id
342: -- x_return_status OUT VARCHAR2
343: -- Indicates the return status of the API.
344: -- Valid values are: 'S' for Success, 'E' for Error, 'U' for Unexpected Error
345: -- x_msg_count OUT NUMBER

Line 2505: UPDATE PA_PROJECT_ASSIGNMENTS

2501: IF l_new_assignment_id_tbl.exists(j) THEN
2502: x_requirement_id_tbl.extend(1);
2503: x_requirement_id_tbl(x_requirement_id_tbl.count):= l_new_assignment_id_tbl(j);
2504: IF (l_req_rec.orig_system_code IS NOT NULL OR l_req_rec.orig_system_reference IS NOT NULL) THEN
2505: UPDATE PA_PROJECT_ASSIGNMENTS
2506: SET orig_system_code = l_req_rec.orig_system_code
2507: , orig_system_reference = l_req_rec.orig_system_reference
2508: WHERE assignment_id = l_new_assignment_id_tbl(j);
2509: END IF;

Line 2727: AND object_type = 'PA_PROJECT_ASSIGNMENTS'

2723: CURSOR c_get_subteam_party_id(c_requirement_id NUMBER) IS
2724: SELECT project_subteam_party_id, project_subteam_id
2725: FROM pa_project_subteam_parties
2726: WHERE object_id = c_requirement_id
2727: AND object_type = 'PA_PROJECT_ASSIGNMENTS'
2728: AND primary_subteam_flag = 'Y';
2729:
2730: CURSOR c_get_requirement_details(c_requirement_id NUMBER) IS
2731: SELECT *

Line 2732: FROM pa_project_assignments

2728: AND primary_subteam_flag = 'Y';
2729:
2730: CURSOR c_get_requirement_details(c_requirement_id NUMBER) IS
2731: SELECT *
2732: FROM pa_project_assignments
2733: WHERE assignment_type = 'OPEN_ASSIGNMENT'
2734: AND assignment_id = c_requirement_id;
2735:
2736: CURSOR c_get_system_status_code(c_status_code VARCHAR2, c_status_type VARCHAR2) IS

Line 4064: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

4060:
4061: l_return_status := FND_API.G_RET_STS_SUCCESS;
4062: l_ret_code := 'T';
4063: l_privilege := 'PA_ASN_BASIC_INFO_ED';
4064: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
4065: l_object_key := l_req_rec.requirement_id;
4066:
4067: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4068: x_ret_code => l_ret_code

Line 4127: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

4123:
4124: l_return_status := FND_API.G_RET_STS_SUCCESS;
4125: l_ret_code := 'T';
4126: l_privilege := 'PA_CREATE_CANDIDATES';
4127: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
4128: l_object_key := l_req_rec.requirement_id;
4129:
4130: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4131: x_ret_code => l_ret_code

Line 4190: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

4186:
4187: l_return_status := FND_API.G_RET_STS_SUCCESS;
4188: l_ret_code := 'T';
4189: l_privilege := 'PA_ASN_FCST_INFO_ED';
4190: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
4191: l_object_key := l_req_rec.requirement_id;
4192:
4193: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4194: x_ret_code => l_ret_code

Line 4254: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

4250:
4251: l_return_status := FND_API.G_RET_STS_SUCCESS;
4252: l_ret_code := 'T';
4253: l_privilege := 'PA_ASN_FCST_INFO_BILL_ED';
4254: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
4255: l_object_key := l_req_rec.requirement_id;
4256:
4257: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4258: x_ret_code => l_ret_code

Line 4317: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

4313:
4314: l_return_status := FND_API.G_RET_STS_SUCCESS;
4315: l_ret_code := 'T';
4316: l_privilege := 'PA_ASN_FCST_INFO_TP_ED';
4317: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
4318: l_object_key := l_req_rec.requirement_id;
4319:
4320: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4321: x_ret_code => l_ret_code

Line 4521: UPDATE PA_PROJECT_ASSIGNMENTS

4517: pa_debug.write(l_module, 'Updating Original System Code and Reference', l_log_level);
4518: END IF;
4519:
4520: IF l_req_rec.orig_system_code IS NOT NULL OR l_req_rec.orig_system_reference IS NOT NULL THEN
4521: UPDATE PA_PROJECT_ASSIGNMENTS
4522: SET orig_system_code = decode(l_req_rec.orig_system_code, null, orig_system_code, l_req_rec.orig_system_code)
4523: , orig_system_reference = decode(l_req_rec.orig_system_reference, null, orig_system_reference, l_req_rec.orig_system_reference)
4524: WHERE assignment_id = l_req_rec.requirement_id;
4525: END IF;

Line 4729: FROM pa_project_assignments

4725: l_system_status_code VARCHAR2(30);
4726:
4727: CURSOR c_derive_values(p_requirement_id IN NUMBER) IS
4728: SELECT ROWID,project_id,record_version_number,ASSIGNMENT_TEMPLATE_ID,assignment_number,status_code
4729: FROM pa_project_assignments
4730: WHERE assignment_id = p_requirement_id
4731: AND ASSIGNMENT_TYPE = l_assignment_type ;
4732:
4733: CURSOR c_get_system_status IS

Line 5149: FROM pa_project_assignments

5145: l_out_resource_id NUMBER;
5146:
5147: CURSOR c_derive_values(c_source_reqmt_id IN NUMBER) IS
5148: SELECT project_id,ASSIGNMENT_TEMPLATE_ID ,status_code,start_date,end_date
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

Line 5733: -- Reference: pa_project_assignments.assignment_id

5729: -- p_api_version_number IN NUMBER Required
5730: -- To be compliant with Applications API coding standards.
5731: -- p_req_asgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE Required
5732: -- Table of requirement or assignment ids.
5733: -- Reference: pa_project_assignments.assignment_id
5734: -- OUT :
5735: -- x_req_asgn_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE
5736: -- Table to store the created requirement or assignment ids
5737: -- x_return_status OUT VARCHAR2

Line 5812: FROM pa_project_assignments

5808: l_status_code VARCHAR2(30);
5809:
5810: CURSOR c_derive_values(p_req_asgn_id IN NUMBER) IS
5811: SELECT project_id,ASSIGNMENT_TEMPLATE_ID,status_code
5812: FROM pa_project_assignments
5813: WHERE assignment_id = p_req_asgn_id ;
5814:
5815: CURSOR c_get_system_status IS
5816: SELECT PROJECT_SYSTEM_STATUS_CODE

Line 6160: -- Reference: pa_project_assignments.assignment_id

6156: -- Please see the ASSIGNMENT_IN_TBL_TYPE datatype table.
6157: -- OUT :
6158: -- x_assignment_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE
6159: -- Table to store assignment ids created by the API.
6160: -- Reference: pa_project_assignments.assignment_id
6161: -- x_return_status OUT VARCHAR2
6162: -- Indicates the return status of the API.
6163: -- Valid values are: 'S' for Success, 'E' for Error, 'U' for Unexpected Error
6164: -- x_msg_count OUT NUMBER

Line 7799: UPDATE PA_PROJECT_ASSIGNMENTS

7795: IF l_new_assignment_id_tbl.exists(j) THEN
7796: x_assignment_id_tbl.extend(1);
7797: x_assignment_id_tbl(x_assignment_id_tbl.count):= l_new_assignment_id_tbl(j);
7798: IF (l_asgn_rec.orig_system_code IS NOT NULL OR l_asgn_rec.orig_system_reference IS NOT NULL) THEN
7799: UPDATE PA_PROJECT_ASSIGNMENTS
7800: SET orig_system_code = l_asgn_rec.orig_system_code
7801: , orig_system_reference = l_asgn_rec.orig_system_reference
7802: WHERE assignment_id = l_new_assignment_id_tbl(j);
7803: END IF;

Line 8003: l_assignment_name PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_NAME%TYPE;

7999:
8000: l_before_api_msg_count NUMBER;
8001: l_after_api_msg_count NUMBER;
8002:
8003: l_assignment_name PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_NAME%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;

Line 8004: l_assignment_id PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_ID%TYPE;

8000: l_before_api_msg_count NUMBER;
8001: l_after_api_msg_count NUMBER;
8002:
8003: l_assignment_name PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_NAME%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;

Line 8005: l_record_version_number PA_PROJECT_ASSIGNMENTS.RECORD_VERSION_NUMBER%TYPE;

8001: l_after_api_msg_count NUMBER;
8002:
8003: l_assignment_name PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_NAME%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 ;

Line 8006: l_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;

8002:
8003: l_assignment_name PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_NAME%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:

Line 8007: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;

8003: l_assignment_name PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_NAME%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

Line 8009: l_mass_wf_in_progress_flag PA_PROJECT_ASSIGNMENTS.MASS_WF_IN_PROGRESS_FLAG%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
8013: FROM pa_project_statuses

Line 8018: SELECT * from pa_project_assignments

8014: WHERE project_status_code = l_in_status_code
8015: AND status_type= 'ASGMT_APPRVL';
8016:
8017: CURSOR c_asgn_db_values IS
8018: SELECT * from pa_project_assignments
8019: WHERE assignment_id = l_assignment_id
8020: AND assignment_type <> 'OPEN_ASSIGNMENT' ;
8021:
8022: CURSOR c_get_subteam_party_id(l_in_assignment_id IN NUMBER) IS

Line 8026: AND object_type = 'PA_PROJECT_ASSIGNMENTS'

8022: CURSOR c_get_subteam_party_id(l_in_assignment_id IN NUMBER) IS
8023: SELECT project_subteam_party_id, project_subteam_id
8024: FROM pa_project_subteam_parties
8025: WHERE object_id = l_in_assignment_id
8026: AND object_type = 'PA_PROJECT_ASSIGNMENTS'
8027: AND primary_subteam_flag = 'Y';
8028:
8029: CURSOR get_bill_rate_override_flags(c_project_id NUMBER) IS
8030: SELECT impl.rate_discount_reason_flag ,impl.br_override_flag, impl.br_discount_override_flag

Line 9128: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

9124: ELSIF l_asgn_db_values_rec.assignment_type = 'STAFFED_ADMIN_ASSIGNMENT' THEN
9125: l_privilege := 'PA_ADM_ASN_CR_AND_DL';
9126: END IF;
9127:
9128: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
9129: l_object_key := l_asgn_rec.assignment_id;
9130:
9131: l_before_api_msg_count := FND_MSG_PUB.COUNT_MSG;
9132: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

Line 9203: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

9199: ELSIF l_asgn_db_values_rec.assignment_type = 'STAFFED_ADMIN_ASSIGNMENT' THEN
9200: l_privilege := 'PA_ADM_ASN_FCST_INFO_ED';
9201: END IF;
9202:
9203: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
9204: l_object_key := l_asgn_rec.assignment_id;
9205:
9206: l_before_api_msg_count := FND_MSG_PUB.COUNT_MSG;
9207: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

Line 9268: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

9264:
9265: l_return_status := FND_API.G_RET_STS_SUCCESS;
9266: l_ret_code := 'T';
9267: l_privilege := 'PA_ASN_FCST_INFO_BILL_ED';
9268: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
9269: l_object_key := l_asgn_rec.assignment_id;
9270:
9271: l_before_api_msg_count := FND_MSG_PUB.COUNT_MSG;
9272: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

Line 9332: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

9328:
9329: l_return_status := FND_API.G_RET_STS_SUCCESS;
9330: l_ret_code := 'T';
9331: l_privilege := 'PA_ASN_FCST_INFO_TP_ED';
9332: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
9333: l_object_key := l_asgn_rec.assignment_id;
9334:
9335: l_before_api_msg_count := FND_MSG_PUB.COUNT_MSG;
9336: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

Line 9507: -- UPDATE PA_PROJECT_ASSIGNMENTS

9503: pa_debug.write(l_module, 'Updating Original System Code and Reference', l_log_level);
9504: END IF;
9505:
9506: --IF l_asgn_rec.orig_system_code IS NOT NULL OR l_asgn_rec.orig_system_reference IS NOT NULL THEN
9507: -- UPDATE PA_PROJECT_ASSIGNMENTS
9508: -- SET orig_system_code = decode(l_asgn_rec.orig_system_code, null, orig_system_code, l_asgn_rec.orig_system_code)
9509: -- , orig_system_reference = decode(l_asgn_rec.orig_system_reference, null, orig_system_reference, l_asgn_rec.orig_system_reference)
9510: -- WHERE assignment_id = l_asgn_rec.assignment_id;
9511: --END IF;

Line 9513: UPDATE PA_PROJECT_ASSIGNMENTS

9509: -- , orig_system_reference = decode(l_asgn_rec.orig_system_reference, null, orig_system_reference, l_asgn_rec.orig_system_reference)
9510: -- WHERE assignment_id = l_asgn_rec.assignment_id;
9511: --END IF;
9512:
9513: UPDATE PA_PROJECT_ASSIGNMENTS
9514: SET orig_system_code = l_asgn_rec.orig_system_code
9515: , orig_system_reference = l_asgn_rec.orig_system_reference
9516: WHERE assignment_id = l_asgn_rec.assignment_id;
9517:

Line 9718: FROM pa_project_assignments

9714:
9715: CURSOR CUR_ASSIGNMENT_DETAILS(l_assignment_id NUMBER ) IS
9716: SELECT ROWID , assignment_type, status_code, project_id, record_version_number, assignment_number,
9717: resource_id, start_date, mass_wf_in_progress_flag, apprvl_status_code
9718: FROM pa_project_assignments
9719: WHERE assignment_id=l_assignment_id
9720: AND assignment_type <> 'OPEN_ASSIGNMENT' ;
9721:
9722: CURSOR cur_get_system_status(l_status_code VARCHAR2 ) IS

Line 10233: FROM pa_project_assignments

10229: l_valid VARCHAR2(1); -- Bug 5175869
10230:
10231: CURSOR c_valid_asgn_id(p_assignment_id IN NUMBER) IS
10232: SELECT project_id , resource_id,start_date,assignment_type,mass_wf_in_progress_flag ,apprvl_status_code,record_version_number
10233: FROM pa_project_assignments
10234: WHERE assignment_type <> 'OPEN_ASSIGNMENT'
10235: AND assignment_id = p_assignment_id ;
10236:
10237: CURSOR get_person_type(p_person_id IN NUMBER) IS

Line 10904: FROM pa_project_assignments

10900:
10901: -- This cursor is used to Retrive the Info Regarding the given Requirement
10902: CURSOR cur_assign_info (l_requirement_id NUMBER ) IS
10903: SELECT project_id,status_code,mass_wf_in_progress_flag
10904: FROM pa_project_assignments
10905: where assignment_id = l_requirement_id
10906: AND assignment_type = 'OPEN_ASSIGNMENT'
10907: AND nvl(template_flag,'N') = 'N';
10908:

Line 11153: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

11149: IF l_debug_mode = 'Y' THEN
11150: pa_debug.write(l_module, 'No Access Found at Project level checking at Requirement level', l_debug_level);
11151: END IF ;
11152: l_privilege := 'PA_ASN_BASIC_INFO_ED';
11153: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
11154: l_object_key := l_requirement_id;
11155: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
11156: x_ret_code => l_ret_code
11157: , x_return_status => l_return_status

Line 11480: FROM pa_project_assignments

11476: -- This cursor is used to get the information like which Requirement
11477: -- competence belong to and validity .
11478: CURSOR cur_assign_info (l_requirement_id IN NUMBER ) IS
11479: SELECT project_id,assignment_template_id,status_code,mass_wf_in_progress_flag
11480: FROM pa_project_assignments
11481: where assignment_id = l_requirement_id;
11482:
11483: -- To get the project system status code for
11484: -- perticular requirement.

Line 11753: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

11749: pa_debug.write(l_module,'No Access Found at Project level checking at Requirement level', l_debug_level);
11750: END IF ;
11751:
11752: l_privilege := 'PA_ASN_BASIC_INFO_ED';
11753: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
11754: l_object_key := l_requirement_id;
11755: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
11756: x_ret_code => l_ret_code
11757: , x_return_status => l_return_status

Line 12056: FROM pa_project_assignments

12052: -- This cursor is used to get the information like which Requirement
12053: -- competence belong to and validity .
12054: CURSOR cur_assign_info (l_requirement_id IN NUMBER ) IS
12055: SELECT project_id,assignment_template_id,status_code,mass_wf_in_progress_flag
12056: FROM pa_project_assignments
12057: where assignment_id = l_requirement_id;
12058:
12059: -- To get the project system status code for
12060: -- perticular requirement.

Line 12252: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

12248: pa_debug.write(l_module,'No Access Found at Project level checking at Requirement level', l_debug_level);
12249: END IF ;
12250:
12251: l_privilege := 'PA_ASN_BASIC_INFO_ED';
12252: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
12253: l_object_key := l_requirement_id;
12254: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
12255: x_ret_code => l_ret_code
12256: , x_return_status => l_return_status

Line 12552: FROM pa_project_assignments

12548: l_data VARCHAR2(2000);
12549:
12550: CURSOR c_get_requirement_info(c_assignment_id NUMBER) IS
12551: SELECT project_id, start_date, status_code, mass_wf_in_progress_flag
12552: FROM pa_project_assignments
12553: WHERE assignment_id = c_assignment_id
12554: AND assignment_type = 'OPEN_ASSIGNMENT';
12555:
12556: CURSOR c_get_system_status_code(c_status_code VARCHAR2, c_status_type VARCHAR2) IS

Line 12785: -- Check PA_CREATE_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS as done in AddCandidatesTopCO.java

12781: END IF;
12782:
12783: -- Security Check
12784: -----------------
12785: -- Check PA_CREATE_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS as done in AddCandidatesTopCO.java
12786: IF l_error_flag_local <> 'Y' THEN
12787:
12788: IF l_debug_mode = 'Y' THEN
12789: pa_debug.write(l_module, 'Checking PA_CREATE_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS for record#'||i, l_log_level);

Line 12789: pa_debug.write(l_module, 'Checking PA_CREATE_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS for record#'||i, l_log_level);

12785: -- Check PA_CREATE_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS as done in AddCandidatesTopCO.java
12786: IF l_error_flag_local <> 'Y' THEN
12787:
12788: IF l_debug_mode = 'Y' THEN
12789: pa_debug.write(l_module, 'Checking PA_CREATE_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS for record#'||i, l_log_level);
12790: END IF;
12791:
12792: l_privilege := 'PA_CREATE_CANDIDATES';
12793: l_object_name := 'PA_PROJECTS';

Line 12811: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

12807: , p_init_msg_list => FND_API.G_FALSE);
12808:
12809: IF nvl(l_ret_code, 'F') = 'F' AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
12810: l_privilege := 'PA_CREATE_CANDIDATES';
12811: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
12812: l_object_key := l_candidate_in_rec.requirement_id;
12813:
12814: l_return_status := FND_API.G_RET_STS_SUCCESS;
12815: l_ret_code := 'T';

Line 13146: FROM pa_project_assignments

13142: AND project_status_code = c_status_code;
13143:
13144: CURSOR c_get_requirement_info(c_assignment_id NUMBER) IS
13145: SELECT project_id
13146: FROM pa_project_assignments
13147: WHERE assignment_id = c_assignment_id
13148: AND assignment_type = 'OPEN_ASSIGNMENT';
13149:
13150: CURSOR c_get_candidate_details(c_candidate_id NUMBER) IS

Line 13336: -- Security Check : Check PA_VIEW_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS as done in CandidatesTopCO.java

13332: END IF;
13333:
13334: END IF;
13335:
13336: -- Security Check : Check PA_VIEW_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS as done in CandidatesTopCO.java
13337: -------------------
13338:
13339: IF l_error_flag_local <> 'Y' THEN
13340:

Line 13342: pa_debug.write(l_module, 'Checking PA_VIEW_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS for record#'||i, l_log_level);

13338:
13339: IF l_error_flag_local <> 'Y' THEN
13340:
13341: IF l_debug_mode = 'Y' THEN
13342: pa_debug.write(l_module, 'Checking PA_VIEW_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS for record#'||i, l_log_level);
13343: END IF;
13344:
13345: l_privilege := 'PA_VIEW_CANDIDATES';
13346:

Line 13364: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

13360: , p_object_key => l_object_key
13361: , p_init_msg_list => FND_API.G_FALSE);
13362:
13363: IF nvl(l_ret_code, 'F') = 'F' AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
13364: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
13365: l_object_key := l_candidate_in_rec.requirement_id;
13366:
13367: l_return_status := FND_API.G_RET_STS_SUCCESS;
13368: l_ret_code := 'T';

Line 13628: FROM pa_project_assignments

13624: l_data VARCHAR2(2000);
13625:
13626: CURSOR c_get_requirement_info(c_assignment_id NUMBER) IS
13627: SELECT project_id, record_version_number
13628: FROM pa_project_assignments
13629: WHERE assignment_id = c_assignment_id
13630: AND assignment_type = 'OPEN_ASSIGNMENT';
13631:
13632: BEGIN

Line 13763: -- Security Check : Check PA_CREATE_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS as done in AddCandidatesTopCO.java

13759: l_candidate_in_rec.record_version_number := null;
13760:
13761: END IF;
13762:
13763: -- Security Check : Check PA_CREATE_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS as done in AddCandidatesTopCO.java
13764: -------------------
13765:
13766: IF l_error_flag_local <> 'Y' THEN
13767:

Line 13769: pa_debug.write(l_module, 'Checking PA_CREATE_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS for record#'||i, l_log_level);

13765:
13766: IF l_error_flag_local <> 'Y' THEN
13767:
13768: IF l_debug_mode = 'Y' THEN
13769: pa_debug.write(l_module, 'Checking PA_CREATE_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS for record#'||i, l_log_level);
13770: END IF;
13771:
13772: l_privilege := 'PA_CREATE_CANDIDATES';
13773:

Line 13791: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

13787: , p_object_key => l_object_key
13788: , p_init_msg_list => FND_API.G_FALSE);
13789:
13790: IF nvl(l_ret_code, 'F') = 'F' AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
13791: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
13792: l_object_key := l_candidate_in_rec.requirement_id;
13793:
13794: l_return_status := FND_API.G_RET_STS_SUCCESS;
13795: l_ret_code := 'T';

Line 13851: pa_debug.write(l_module, 'Calling PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW for Record#'||i, l_log_level);

13847: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.DELETE_CANDIDATES unsuccessful', l_log_level);
13848: END IF;
13849: ELSE
13850: IF l_debug_mode = 'Y' THEN
13851: pa_debug.write(l_module, 'Calling PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW for Record#'||i, l_log_level);
13852: END IF;
13853: -- Set the number of active candidates to zero
13854: PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW
13855: (

Line 13854: PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW

13850: IF l_debug_mode = 'Y' THEN
13851: pa_debug.write(l_module, 'Calling PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW for Record#'||i, l_log_level);
13852: END IF;
13853: -- Set the number of active candidates to zero
13854: PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW
13855: (
13856: p_assignment_id => l_candidate_in_rec.requirement_id
13857: , p_no_of_active_candidates => 0
13858: , p_record_version_number => l_record_version_number

Line 13862: pa_debug.write(l_module, 'After call PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW l_return_status='||l_return_status, l_log_level);

13858: , p_record_version_number => l_record_version_number
13859: , x_return_status => l_return_status
13860: );
13861: IF l_debug_mode = 'Y' THEN
13862: pa_debug.write(l_module, 'After call PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW l_return_status='||l_return_status, l_log_level);
13863: END IF;
13864: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13865: l_error_flag_local := 'Y';
13866: IF l_debug_mode = 'Y' THEN

Line 13867: pa_debug.write(l_module, 'PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW unsuccessful', l_log_level);

13863: END IF;
13864: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13865: l_error_flag_local := 'Y';
13866: IF l_debug_mode = 'Y' THEN
13867: pa_debug.write(l_module, 'PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW unsuccessful', l_log_level);
13868: END IF;
13869: ELSE
13870: IF l_debug_mode = 'Y' THEN
13871: pa_debug.write(l_module, 'PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW and PA_CANDIDATE_PUB.DELETE_CANDIDATES successful', l_log_level);

Line 13871: pa_debug.write(l_module, 'PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW and PA_CANDIDATE_PUB.DELETE_CANDIDATES successful', l_log_level);

13867: pa_debug.write(l_module, 'PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW unsuccessful', l_log_level);
13868: END IF;
13869: ELSE
13870: IF l_debug_mode = 'Y' THEN
13871: pa_debug.write(l_module, 'PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW and PA_CANDIDATE_PUB.DELETE_CANDIDATES successful', l_log_level);
13872: END IF;
13873: END IF;
13874: END IF;
13875: END IF;

Line 14237: -- Security Check : Check PA_REVIEW_CANDIDATE_LOG privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS as done in CandRevwLogTopCO.java

14233: IF l_candidate_log_tbl.review_comments = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
14234: l_candidate_log_tbl.review_comments := null;
14235: END IF;
14236:
14237: -- Security Check : Check PA_REVIEW_CANDIDATE_LOG privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS as done in CandRevwLogTopCO.java
14238: -------------------
14239:
14240: IF l_debug_mode = 'Y' THEN
14241: pa_debug.write(l_module, 'Checking PA_REVIEW_CANDIDATE_LOG privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS for record#'||i, l_log_level);

Line 14241: pa_debug.write(l_module, 'Checking PA_REVIEW_CANDIDATE_LOG privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS for record#'||i, l_log_level);

14237: -- Security Check : Check PA_REVIEW_CANDIDATE_LOG privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS as done in CandRevwLogTopCO.java
14238: -------------------
14239:
14240: IF l_debug_mode = 'Y' THEN
14241: pa_debug.write(l_module, 'Checking PA_REVIEW_CANDIDATE_LOG privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS for record#'||i, l_log_level);
14242: END IF;
14243:
14244: l_privilege := 'PA_REVIEW_CANDIDATE_LOG';
14245:

Line 14263: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

14259: , p_object_key => l_object_key
14260: , p_init_msg_list => FND_API.G_FALSE);
14261:
14262: IF nvl(l_ret_code, 'F') = 'F' AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
14263: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
14264: l_object_key := l_cand_rec.assignment_id;
14265:
14266: l_return_status := FND_API.G_RET_STS_SUCCESS;
14267: l_ret_code := 'T';