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 2506: UPDATE PA_PROJECT_ASSIGNMENTS

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

Line 2728: AND object_type = 'PA_PROJECT_ASSIGNMENTS'

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

Line 2733: FROM pa_project_assignments

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

Line 4065: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

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

Line 4128: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

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

Line 4191: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

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

Line 4255: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

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

Line 4318: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

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

Line 4522: UPDATE PA_PROJECT_ASSIGNMENTS

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

Line 4730: FROM pa_project_assignments

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

Line 5150: FROM pa_project_assignments

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

Line 5734: -- Reference: pa_project_assignments.assignment_id

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

Line 5813: FROM pa_project_assignments

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

Line 6161: -- Reference: pa_project_assignments.assignment_id

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

Line 7801: UPDATE PA_PROJECT_ASSIGNMENTS

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

Line 8005: l_assignment_name PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_NAME%TYPE;

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

Line 8006: l_assignment_id PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_ID%TYPE;

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

Line 8007: l_record_version_number PA_PROJECT_ASSIGNMENTS.RECORD_VERSION_NUMBER%TYPE;

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

Line 8008: l_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;

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

Line 8009: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;

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

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

Line 8020: SELECT * from pa_project_assignments

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

Line 8028: AND object_type = 'PA_PROJECT_ASSIGNMENTS'

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

Line 9130: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

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

Line 9205: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

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

Line 9270: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

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

Line 9334: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

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

Line 9509: -- UPDATE PA_PROJECT_ASSIGNMENTS

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

Line 9515: UPDATE PA_PROJECT_ASSIGNMENTS

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

Line 9720: FROM pa_project_assignments

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

Line 10235: FROM pa_project_assignments

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

Line 10906: FROM pa_project_assignments

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

Line 11155: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

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

Line 11482: FROM pa_project_assignments

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

Line 11755: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

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

Line 12058: FROM pa_project_assignments

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

Line 12254: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

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

Line 12554: FROM pa_project_assignments

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

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

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

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

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

Line 12813: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

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

Line 13167: FROM pa_project_assignments

13163: AND project_status_code = c_status_code;
13164:
13165: CURSOR c_get_requirement_info(c_assignment_id NUMBER) IS
13166: SELECT project_id
13167: FROM pa_project_assignments
13168: WHERE assignment_id = c_assignment_id
13169: AND assignment_type = 'OPEN_ASSIGNMENT';
13170:
13171: CURSOR c_get_candidate_details(c_candidate_id NUMBER) IS

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

13353: END IF;
13354:
13355: END IF;
13356:
13357: -- Security Check : Check PA_VIEW_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS as done in CandidatesTopCO.java
13358: -------------------
13359:
13360: IF l_error_flag_local <> 'Y' THEN
13361:

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

13359:
13360: IF l_error_flag_local <> 'Y' THEN
13361:
13362: IF l_debug_mode = 'Y' THEN
13363: pa_debug.write(l_module, 'Checking PA_VIEW_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS for record#'||i, l_log_level);
13364: END IF;
13365:
13366: l_privilege := 'PA_VIEW_CANDIDATES';
13367:

Line 13385: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

13381: , p_object_key => l_object_key
13382: , p_init_msg_list => FND_API.G_FALSE);
13383:
13384: IF nvl(l_ret_code, 'F') = 'F' AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
13385: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
13386: l_object_key := l_candidate_in_rec.requirement_id;
13387:
13388: l_return_status := FND_API.G_RET_STS_SUCCESS;
13389: l_ret_code := 'T';

Line 13666: FROM pa_project_assignments

13662: l_data VARCHAR2(2000);
13663:
13664: CURSOR c_get_requirement_info(c_assignment_id NUMBER) IS
13665: SELECT project_id, record_version_number
13666: FROM pa_project_assignments
13667: WHERE assignment_id = c_assignment_id
13668: AND assignment_type = 'OPEN_ASSIGNMENT';
13669:
13670: BEGIN

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

13797: l_candidate_in_rec.record_version_number := null;
13798:
13799: END IF;
13800:
13801: -- Security Check : Check PA_CREATE_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS as done in AddCandidatesTopCO.java
13802: -------------------
13803:
13804: IF l_error_flag_local <> 'Y' THEN
13805:

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

13803:
13804: IF l_error_flag_local <> 'Y' THEN
13805:
13806: IF l_debug_mode = 'Y' THEN
13807: pa_debug.write(l_module, 'Checking PA_CREATE_CANDIDATES privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS for record#'||i, l_log_level);
13808: END IF;
13809:
13810: l_privilege := 'PA_CREATE_CANDIDATES';
13811:

Line 13829: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

13825: , p_object_key => l_object_key
13826: , p_init_msg_list => FND_API.G_FALSE);
13827:
13828: IF nvl(l_ret_code, 'F') = 'F' AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
13829: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
13830: l_object_key := l_candidate_in_rec.requirement_id;
13831:
13832: l_return_status := FND_API.G_RET_STS_SUCCESS;
13833: l_ret_code := 'T';

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

13885: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.DELETE_CANDIDATES unsuccessful', l_log_level);
13886: END IF;
13887: ELSE
13888: IF l_debug_mode = 'Y' THEN
13889: pa_debug.write(l_module, 'Calling PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW for Record#'||i, l_log_level);
13890: END IF;
13891: -- Set the number of active candidates to zero
13892: PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW
13893: (

Line 13892: PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW

13888: IF l_debug_mode = 'Y' THEN
13889: pa_debug.write(l_module, 'Calling PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW for Record#'||i, l_log_level);
13890: END IF;
13891: -- Set the number of active candidates to zero
13892: PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW
13893: (
13894: p_assignment_id => l_candidate_in_rec.requirement_id
13895: , p_no_of_active_candidates => 0
13896: , p_record_version_number => l_record_version_number

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

13896: , p_record_version_number => l_record_version_number
13897: , x_return_status => l_return_status
13898: );
13899: IF l_debug_mode = 'Y' THEN
13900: pa_debug.write(l_module, 'After call PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW l_return_status='||l_return_status, l_log_level);
13901: END IF;
13902: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13903: l_error_flag_local := 'Y';
13904: IF l_debug_mode = 'Y' THEN

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

13901: END IF;
13902: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13903: l_error_flag_local := 'Y';
13904: IF l_debug_mode = 'Y' THEN
13905: pa_debug.write(l_module, 'PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW unsuccessful', l_log_level);
13906: END IF;
13907: ELSE
13908: IF l_debug_mode = 'Y' THEN
13909: pa_debug.write(l_module, 'PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW and PA_CANDIDATE_PUB.DELETE_CANDIDATES successful', l_log_level);

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

13905: pa_debug.write(l_module, 'PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW unsuccessful', l_log_level);
13906: END IF;
13907: ELSE
13908: IF l_debug_mode = 'Y' THEN
13909: pa_debug.write(l_module, 'PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW and PA_CANDIDATE_PUB.DELETE_CANDIDATES successful', l_log_level);
13910: END IF;
13911: END IF;
13912: END IF;
13913: END IF;

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

14271: IF l_candidate_log_tbl.review_comments = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
14272: l_candidate_log_tbl.review_comments := null;
14273: END IF;
14274:
14275: -- Security Check : Check PA_REVIEW_CANDIDATE_LOG privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS as done in CandRevwLogTopCO.java
14276: -------------------
14277:
14278: IF l_debug_mode = 'Y' THEN
14279: 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 14279: pa_debug.write(l_module, 'Checking PA_REVIEW_CANDIDATE_LOG privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS for record#'||i, l_log_level);

14275: -- Security Check : Check PA_REVIEW_CANDIDATE_LOG privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS as done in CandRevwLogTopCO.java
14276: -------------------
14277:
14278: IF l_debug_mode = 'Y' THEN
14279: pa_debug.write(l_module, 'Checking PA_REVIEW_CANDIDATE_LOG privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS for record#'||i, l_log_level);
14280: END IF;
14281:
14282: l_privilege := 'PA_REVIEW_CANDIDATE_LOG';
14283:

Line 14301: l_object_name := 'PA_PROJECT_ASSIGNMENTS';

14297: , p_object_key => l_object_key
14298: , p_init_msg_list => FND_API.G_FALSE);
14299:
14300: IF nvl(l_ret_code, 'F') = 'F' AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
14301: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
14302: l_object_key := l_cand_rec.assignment_id;
14303:
14304: l_return_status := FND_API.G_RET_STS_SUCCESS;
14305: l_ret_code := 'T';