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_SCHEDULE_PVT dependencies on PA_PROJECT_ASSIGNMENTS

Line 2053: l_t_calendar_id pa_project_assignments.calendar_id%TYPE; -- to store the value for new creating hours

2049: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2050: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2051: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
2052: IS
2053: l_t_calendar_id pa_project_assignments.calendar_id%TYPE; -- to store the value for new creating hours
2054: l_t_calendar_type pa_project_assignments.calendar_type%TYPE; -- to store the value for new creating hours
2055: l_t_team_player_id NUMBER; -- to store the value for new creating hours
2056:
2057: l_t_resource_id NUMBER; -- to sto

Line 2054: l_t_calendar_type pa_project_assignments.calendar_type%TYPE; -- to store the value for new creating hours

2050: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2051: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
2052: IS
2053: l_t_calendar_id pa_project_assignments.calendar_id%TYPE; -- to store the value for new creating hours
2054: l_t_calendar_type pa_project_assignments.calendar_type%TYPE; -- to store the value for new creating hours
2055: l_t_team_player_id NUMBER; -- to store the value for new creating hours
2056:
2057: l_t_resource_id NUMBER; -- to sto
2058: l_t_asgn_type pa_project_assignments.assignment_type%TYPE; /*Bug 5682726*/

Line 2058: l_t_asgn_type pa_project_assignments.assignment_type%TYPE; /Bug 5682726/

2054: l_t_calendar_type pa_project_assignments.calendar_type%TYPE; -- to store the value for new creating hours
2055: l_t_team_player_id NUMBER; -- to store the value for new creating hours
2056:
2057: l_t_resource_id NUMBER; -- to sto
2058: l_t_asgn_type pa_project_assignments.assignment_type%TYPE; /*Bug 5682726*/
2059: BEGIN
2060: PA_SCHEDULE_UTILS.log_message(1,'start of create new hours ... ');
2061: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
2062: PA_SCHEDULE_UTILS.log_message(1,'start of create new hours ...change_hours_type ...'||

Line 2092: FROM pa_project_assignments

2088: /* Bug 5682726 - Start Changes */
2089:
2090: SELECT assignment_type
2091: INTO l_t_asgn_type
2092: FROM pa_project_assignments
2093: where assignment_id = p_sch_except_record.assignment_id;
2094:
2095: IF ( l_t_asgn_type = 'STAFFED_ASSIGNMENT' ) THEN
2096: SELECT project_party_id

Line 2098: FROM pa_project_assignments

2094:
2095: IF ( l_t_asgn_type = 'STAFFED_ASSIGNMENT' ) THEN
2096: SELECT project_party_id
2097: INTO l_t_team_player_id
2098: FROM pa_project_assignments
2099: WHERE assignment_id = p_sch_except_record.assignment_id;
2100:
2101: SELECT resource_id
2102: INTO l_t_resource_id

Line 2103: FROM pa_project_assignments

2099: WHERE assignment_id = p_sch_except_record.assignment_id;
2100:
2101: SELECT resource_id
2102: INTO l_t_resource_id
2103: FROM pa_project_assignments
2104: WHERE assignment_id = p_sch_except_record.assignment_id;
2105:
2106: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2107: PA_SCHEDULE_UTILS.check_calendar(p_resource_id => l_t_resource_id,

Line 2131: FROM pa_project_assignments

2127: ELSE
2128: IF ( l_t_asgn_type = 'OPEN_ASSIGNMENT' ) THEN
2129: SELECT calendar_id
2130: INTO l_t_calendar_id
2131: FROM pa_project_assignments
2132: where assignment_id = p_sch_except_record.assignment_id;
2133:
2134: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2135: PA_SCHEDULE_UTILS.check_calendar(p_calendar_id => l_t_calendar_id,

Line 2202: FROM pa_project_assignments

2198:
2199: -- get project_party_id to pass api 'get_resource_schedule'
2200: SELECT project_party_id
2201: INTO l_t_team_player_id
2202: FROM pa_project_assignments
2203: WHERE assignment_id = p_sch_except_record.assignment_id;
2204:
2205: SELECT resource_id
2206: INTO l_t_resource_id

Line 2207: FROM pa_project_assignments

2203: WHERE assignment_id = p_sch_except_record.assignment_id;
2204:
2205: SELECT resource_id
2206: INTO l_t_resource_id
2207: FROM pa_project_assignments
2208: WHERE assignment_id = p_sch_except_record.assignment_id;
2209:
2210: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2211: PA_SCHEDULE_UTILS.check_calendar(p_resource_id => l_t_resource_id,

Line 2339: FROM pa_project_assignments

2335: (p_sch_except_record.schedule_type_code = 'STAFFED_ADMIN_ASSIGNMENT') THEN
2336:
2337: SELECT project_party_id , resource_calendar_percent,calendar_id,calendar_type
2338: INTO l_t_team_player_id,l_t_res_cal_percent,l_t_calendar_id,l_t_calendar_type
2339: FROM pa_project_assignments
2340: WHERE assignment_id = p_sch_except_record.assignment_id;
2341:
2342: IF ( l_t_calendar_type = 'RESOURCE' ) THEN
2343: -- Calling the procedure get_resource_schedule which is assigned to the assignment

Line 3497: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row(

3493: ' ' || x_msg_data);
3494:
3495: -- if the records is having more than one status then updating the table for it column multi flag */
3496: IF (l_change_flag) THEN
3497: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row(
3498: p_record_version_number => p_record_version_number,
3499: p_assignment_id => l_t_assignment_id,
3500: p_start_date => nvl(l_t_start_date,FND_API.G_MISS_DATE),
3501: p_end_date => nvl(l_t_end_date,FND_API.G_MISS_DATE),

Line 3508: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row(

3504: p_assignment_effort =>
3505: pa_schedule_utils.get_num_hours(l_t_project_id, l_t_assignment_id),
3506: x_return_status => l_x_return_status );
3507: ELSE
3508: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row(
3509: p_record_version_number => p_record_version_number,
3510: p_assignment_id => l_t_assignment_id,
3511: p_assignment_effort =>
3512: pa_schedule_utils.get_num_hours(l_t_project_id, l_t_assignment_id),

Line 3545: pa_project_assignments proj_asgn

3541: l_t_record_version_number,
3542: l_t_asgn_start_date,
3543: l_t_asgn_end_date
3544: FROM pa_project_parties proj_part,
3545: pa_project_assignments proj_asgn
3546: WHERE proj_asgn.PROJECT_PARTY_ID = proj_part.PROJECT_PARTY_ID
3547: AND proj_asgn.ASSIGNMENT_ID = l_t_assignment_id;
3548:
3549: IF ( l_t_start_date is NULL ) THEN

Line 3954: l_assignment_id PA_PROJECT_ASSIGNMENTS.assignment_id%TYPE;

3950: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3951: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3952: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
3953:
3954: l_assignment_id PA_PROJECT_ASSIGNMENTS.assignment_id%TYPE;
3955: l_assignment_id_tbl PA_ASSIGNMENTS_PUB.assignment_id_tbl_type;
3956: l_x_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3957: l_current_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3958: l_temp_number NUMBER;

Line 4273: l_req_start_date PA_PROJECT_ASSIGNMENTS.start_date%TYPE;

4269:
4270: l_x_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- Temporary variable to store the
4271: -- schedule type table of records
4272:
4273: l_req_start_date PA_PROJECT_ASSIGNMENTS.start_date%TYPE;
4274: l_req_end_date pa_project_assignments.end_date%TYPE;
4275: l_calendar_id pa_project_assignments.calendar_id%TYPE;
4276:
4277: l_new_schedule_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

Line 4274: l_req_end_date pa_project_assignments.end_date%TYPE;

4270: l_x_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- Temporary variable to store the
4271: -- schedule type table of records
4272:
4273: l_req_start_date PA_PROJECT_ASSIGNMENTS.start_date%TYPE;
4274: l_req_end_date pa_project_assignments.end_date%TYPE;
4275: l_calendar_id pa_project_assignments.calendar_id%TYPE;
4276:
4277: l_new_schedule_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
4278:

Line 4275: l_calendar_id pa_project_assignments.calendar_id%TYPE;

4271: -- schedule type table of records
4272:
4273: l_req_start_date PA_PROJECT_ASSIGNMENTS.start_date%TYPE;
4274: l_req_end_date pa_project_assignments.end_date%TYPE;
4275: l_calendar_id pa_project_assignments.calendar_id%TYPE;
4276:
4277: l_new_schedule_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
4278:
4279: l_start_date DATE;

Line 4356: from pa_project_assignments

4352:
4353: -- code fix starts for bug 2335580
4354: SELECT start_date, end_date,calendar_id
4355: into l_req_start_date, l_req_end_date, l_calendar_id
4356: from pa_project_assignments
4357: where assignment_id=p_open_assignment_id;
4358:
4359:
4360: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

Line 4570: l_next_status_code pa_project_assignments.status_code%type;

4566: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4567: )
4568: IS
4569:
4570: l_next_status_code pa_project_assignments.status_code%type;
4571: l_temp_status_code pa_project_assignments.status_code%type;
4572: l_project_id pa_project_assignments.project_id%type;
4573: l_calendar_id pa_project_assignments.calendar_id%type;
4574: l_assignment_type pa_project_assignments.assignment_type%type;

Line 4571: l_temp_status_code pa_project_assignments.status_code%type;

4567: )
4568: IS
4569:
4570: l_next_status_code pa_project_assignments.status_code%type;
4571: l_temp_status_code pa_project_assignments.status_code%type;
4572: l_project_id pa_project_assignments.project_id%type;
4573: l_calendar_id pa_project_assignments.calendar_id%type;
4574: l_assignment_type pa_project_assignments.assignment_type%type;
4575: l_asgn_start_date pa_project_assignments.start_date%type;

Line 4572: l_project_id pa_project_assignments.project_id%type;

4568: IS
4569:
4570: l_next_status_code pa_project_assignments.status_code%type;
4571: l_temp_status_code pa_project_assignments.status_code%type;
4572: l_project_id pa_project_assignments.project_id%type;
4573: l_calendar_id pa_project_assignments.calendar_id%type;
4574: l_assignment_type pa_project_assignments.assignment_type%type;
4575: l_asgn_start_date pa_project_assignments.start_date%type;
4576: l_asgn_end_date pa_project_assignments.end_date%type;

Line 4573: l_calendar_id pa_project_assignments.calendar_id%type;

4569:
4570: l_next_status_code pa_project_assignments.status_code%type;
4571: l_temp_status_code pa_project_assignments.status_code%type;
4572: l_project_id pa_project_assignments.project_id%type;
4573: l_calendar_id pa_project_assignments.calendar_id%type;
4574: l_assignment_type pa_project_assignments.assignment_type%type;
4575: l_asgn_start_date pa_project_assignments.start_date%type;
4576: l_asgn_end_date pa_project_assignments.end_date%type;
4577: l_status_type VARCHAR2(30);

Line 4574: l_assignment_type pa_project_assignments.assignment_type%type;

4570: l_next_status_code pa_project_assignments.status_code%type;
4571: l_temp_status_code pa_project_assignments.status_code%type;
4572: l_project_id pa_project_assignments.project_id%type;
4573: l_calendar_id pa_project_assignments.calendar_id%type;
4574: l_assignment_type pa_project_assignments.assignment_type%type;
4575: l_asgn_start_date pa_project_assignments.start_date%type;
4576: l_asgn_end_date pa_project_assignments.end_date%type;
4577: l_status_type VARCHAR2(30);
4578: l_temp_index_out NUMBER;

Line 4575: l_asgn_start_date pa_project_assignments.start_date%type;

4571: l_temp_status_code pa_project_assignments.status_code%type;
4572: l_project_id pa_project_assignments.project_id%type;
4573: l_calendar_id pa_project_assignments.calendar_id%type;
4574: l_assignment_type pa_project_assignments.assignment_type%type;
4575: l_asgn_start_date pa_project_assignments.start_date%type;
4576: l_asgn_end_date pa_project_assignments.end_date%type;
4577: l_status_type VARCHAR2(30);
4578: l_temp_index_out NUMBER;
4579: l_record_version_number NUMBER;

Line 4576: l_asgn_end_date pa_project_assignments.end_date%type;

4572: l_project_id pa_project_assignments.project_id%type;
4573: l_calendar_id pa_project_assignments.calendar_id%type;
4574: l_assignment_type pa_project_assignments.assignment_type%type;
4575: l_asgn_start_date pa_project_assignments.start_date%type;
4576: l_asgn_end_date pa_project_assignments.end_date%type;
4577: l_status_type VARCHAR2(30);
4578: l_temp_index_out NUMBER;
4579: l_record_version_number NUMBER;
4580: -- added for Bug fix: 4537865

Line 4609: FROM pa_project_assignments

4605:
4606: CURSOR C2 IS
4607: SELECT project_id, calendar_id,
4608: assignment_type, start_date, end_date
4609: FROM pa_project_assignments
4610: WHERE assignment_id = p_assignment_id;
4611:
4612: BEGIN
4613: PA_SCHEDULE_UTILS.log_message(1,'Start of the update_sch_wf_success API');

Line 4897: L_next_status_code pa_project_assignments.status_code%type;

4893: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4894: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4895: )
4896: IS
4897: L_next_status_code pa_project_assignments.status_code%type;
4898: l_temp_status_code pa_project_assignments.status_code%type;
4899: l_project_id pa_project_assignments.project_id%type;
4900: l_calendar_id pa_project_assignments.calendar_id%type;
4901: l_assignment_type pa_project_assignments.assignment_type%type;

Line 4898: l_temp_status_code pa_project_assignments.status_code%type;

4894: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4895: )
4896: IS
4897: L_next_status_code pa_project_assignments.status_code%type;
4898: l_temp_status_code pa_project_assignments.status_code%type;
4899: l_project_id pa_project_assignments.project_id%type;
4900: l_calendar_id pa_project_assignments.calendar_id%type;
4901: l_assignment_type pa_project_assignments.assignment_type%type;
4902: l_asgn_start_date pa_project_assignments.start_date%type;

Line 4899: l_project_id pa_project_assignments.project_id%type;

4895: )
4896: IS
4897: L_next_status_code pa_project_assignments.status_code%type;
4898: l_temp_status_code pa_project_assignments.status_code%type;
4899: l_project_id pa_project_assignments.project_id%type;
4900: l_calendar_id pa_project_assignments.calendar_id%type;
4901: l_assignment_type pa_project_assignments.assignment_type%type;
4902: l_asgn_start_date pa_project_assignments.start_date%type;
4903: l_asgn_end_date pa_project_assignments.end_date%type;

Line 4900: l_calendar_id pa_project_assignments.calendar_id%type;

4896: IS
4897: L_next_status_code pa_project_assignments.status_code%type;
4898: l_temp_status_code pa_project_assignments.status_code%type;
4899: l_project_id pa_project_assignments.project_id%type;
4900: l_calendar_id pa_project_assignments.calendar_id%type;
4901: l_assignment_type pa_project_assignments.assignment_type%type;
4902: l_asgn_start_date pa_project_assignments.start_date%type;
4903: l_asgn_end_date pa_project_assignments.end_date%type;
4904: l_status_type VARCHAR2(30);

Line 4901: l_assignment_type pa_project_assignments.assignment_type%type;

4897: L_next_status_code pa_project_assignments.status_code%type;
4898: l_temp_status_code pa_project_assignments.status_code%type;
4899: l_project_id pa_project_assignments.project_id%type;
4900: l_calendar_id pa_project_assignments.calendar_id%type;
4901: l_assignment_type pa_project_assignments.assignment_type%type;
4902: l_asgn_start_date pa_project_assignments.start_date%type;
4903: l_asgn_end_date pa_project_assignments.end_date%type;
4904: l_status_type VARCHAR2(30);
4905: l_temp_index_out NUMBER;

Line 4902: l_asgn_start_date pa_project_assignments.start_date%type;

4898: l_temp_status_code pa_project_assignments.status_code%type;
4899: l_project_id pa_project_assignments.project_id%type;
4900: l_calendar_id pa_project_assignments.calendar_id%type;
4901: l_assignment_type pa_project_assignments.assignment_type%type;
4902: l_asgn_start_date pa_project_assignments.start_date%type;
4903: l_asgn_end_date pa_project_assignments.end_date%type;
4904: l_status_type VARCHAR2(30);
4905: l_temp_index_out NUMBER;
4906: l_record_version_number NUMBER;

Line 4903: l_asgn_end_date pa_project_assignments.end_date%type;

4899: l_project_id pa_project_assignments.project_id%type;
4900: l_calendar_id pa_project_assignments.calendar_id%type;
4901: l_assignment_type pa_project_assignments.assignment_type%type;
4902: l_asgn_start_date pa_project_assignments.start_date%type;
4903: l_asgn_end_date pa_project_assignments.end_date%type;
4904: l_status_type VARCHAR2(30);
4905: l_temp_index_out NUMBER;
4906: l_record_version_number NUMBER;
4907: -- added for Bug Fix: 4537865

Line 4931: FROM pa_project_assignments

4927:
4928: CURSOR C2 IS
4929: SELECT project_id, calendar_id,
4930: assignment_type, start_date, end_date
4931: FROM pa_project_assignments
4932: WHERE assignment_id = p_assignment_id;
4933:
4934: BEGIN
4935: PA_SCHEDULE_UTILS.log_message(1,'Start of the update_sch_wf_failure API');

Line 5398: l_assignment_type pa_project_assignments.assignment_type%TYPE;

5394: /* End for bug 1635170*/
5395: l_start_date DATE;
5396: l_end_date DATE;
5397: l_project_calendar_id NUMBER;
5398: l_assignment_type pa_project_assignments.assignment_type%TYPE;
5399: l_status_code pa_schedules.status_code%TYPE;
5400: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
5401: l_shifted_days NUMBER;
5402: l_calendar_id NUMBER;

Line 5400: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;

5396: l_end_date DATE;
5397: l_project_calendar_id NUMBER;
5398: l_assignment_type pa_project_assignments.assignment_type%TYPE;
5399: l_status_code pa_schedules.status_code%TYPE;
5400: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
5401: l_shifted_days NUMBER;
5402: l_calendar_id NUMBER;
5403:
5404: CURSOR C1 IS

Line 5416: from pa_project_assignments

5412: AND change_id = p_change_id;
5413:
5414: CURSOR get_start_end_date IS
5415: Select start_date, end_date
5416: from pa_project_assignments
5417: where assignment_id = p_assignment_id;
5418:
5419: CURSOR get_apprvl_status_code IS
5420: SELECT apprvl_status_code

Line 5421: FROM pa_project_assignments

5417: where assignment_id = p_assignment_id;
5418:
5419: CURSOR get_apprvl_status_code IS
5420: SELECT apprvl_status_code
5421: FROM pa_project_assignments
5422: WHERE assignment_id = p_assignment_id;
5423:
5424: CURSOR get_project_calendar_id IS
5425: SELECT prj.calendar_id

Line 5427: pa_project_assignments asmt

5423:
5424: CURSOR get_project_calendar_id IS
5425: SELECT prj.calendar_id
5426: FROM pa_projects_all prj,
5427: pa_project_assignments asmt
5428: WHERE asmt.assignment_id = p_assignment_id
5429: AND prj.project_id = asmt.project_id;
5430:
5431: BEGIN

Line 5638: FROM pa_project_assignments

5634: ELSIF (p_exception_type_code = 'CHANGE_HOURS' AND p_change_hours_type_code='PERCENTAGE' AND
5635: p_change_calendar_type_code='PROEJCT') THEN
5636: SELECT calendar_id
5637: INTO l_project_calendar_id
5638: FROM pa_project_assignments
5639: WHERE assignment_id = p_assignment_id;
5640:
5641: -- If Status has been updated, pass appropriate status_code
5642: ELSIF (p_exception_type_code = 'CHANGE_STATUS') THEN

Line 5645: FROM pa_project_assignments

5641: -- If Status has been updated, pass appropriate status_code
5642: ELSIF (p_exception_type_code = 'CHANGE_STATUS') THEN
5643: SELECT assignment_type
5644: INTO l_assignment_type
5645: FROM pa_project_assignments
5646: WHERE assignment_id = p_assignment_id;
5647:
5648: IF (l_assignment_type = 'OPEN_ASSIGNMENT') THEN
5649: l_status_code := p_requirement_status_code;

Line 5711: FROM pa_project_assignments

5707: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
5708:
5709: CURSOR c1 IS
5710: SELECT resource_id, start_date, end_date
5711: FROM pa_project_assignments
5712: WHERE assignment_id = p_assignment_id;
5713:
5714: l_assignment_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
5715: l_resource_id NUMBER;

Line 5927: FROM pa_project_assignments

5923: IF v_c1.assignment_id IS NOT NULL THEN
5924: PA_SCHEDULE_UTILS.debug('v_c1.assignment_id = '|| v_c1.assignment_id);
5925: SELECT resource_id, start_date, end_date
5926: INTO l_resource_id, l_start_date, l_end_date
5927: FROM pa_project_assignments
5928: WHERE assignment_id = v_c1.assignment_id;
5929: PA_SCHEDULE_UTILS.debug('l_resource_id = '|| l_resource_id);
5930:
5931: IF G_AVAILABILITY_CAL_PERIOD = 'DAILY' THEN

Line 6325: FROM pa_assignment_conflict_hist hist, pa_project_assignments asgn

6321: SELECT conflict_assignment_id,
6322: decode(asgn.MASS_WF_IN_PROGRESS_FLAG,
6323: 'Y', decode(hist.intra_txn_conflict_flag, 'N', 'Y', 'N'),
6324: decode(asgn.apprvl_status_code, 'ASGMT_APPRVL_SUBMITTED', 'Y', 'N')) locking_flag
6325: FROM pa_assignment_conflict_hist hist, pa_project_assignments asgn
6326: WHERE hist.conflict_assignment_id = asgn.assignment_id
6327: AND hist.conflict_group_id = p_conflict_group_id
6328: AND hist.assignment_id = p_assignment_id
6329: AND hist.processed_flag = 'N'

Line 6344: l_assignment_type pa_project_assignments.assignment_type%TYPE;

6340: -- PA_SCHEDULE_PUB.change_work_pattern.
6341: l_record_version_number NUMBER;
6342: l_project_id NUMBER;
6343: l_calendar_id NUMBER;
6344: l_assignment_type pa_project_assignments.assignment_type%TYPE;
6345: l_start_date DATE;
6346: l_end_date DATE;
6347: l_asgn_start_date DATE;
6348: l_asgn_end_date DATE;

Line 6412: FROM pa_project_assignments

6408: END LOOP;
6409:
6410: SELECT resource_id, start_date, end_date
6411: INTO l_resource_id, l_asn_start_date, l_asn_end_date
6412: FROM pa_project_assignments
6413: WHERE assignment_id = p_assignment_id;
6414:
6415: IF G_AVAILABILITY_CAL_PERIOD = 'DAILY' THEN
6416: l_conflict_start_date := l_asn_start_date;

Line 6605: FROM pa_project_assignments

6601: PA_SCHEDULE_UTILS.debug ('Entering c3 loop');
6602: -- 2167889: null instead of record_version_number
6603: SELECT null, project_id, calendar_id, assignment_type,start_date, end_date
6604: INTO l_record_version_number, l_project_id, l_calendar_id, l_assignment_type, l_asgn_start_date, l_asgn_end_date
6605: FROM pa_project_assignments
6606: WHERE assignment_id = v_c3.conflict_assignment_id;
6607: PA_SCHEDULE_UTILS.debug ('l_work_pattern_tbl.COUNT = '|| l_work_pattern_tbl.COUNT);
6608: FOR i IN l_work_pattern_tbl.FIRST .. l_work_pattern_tbl.LAST LOOP
6609: IF l_work_pattern_tbl(i).assignment_id = v_c3.conflict_assignment_id THEN

Line 7041: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_project_lists_v proj

7037: Also removed distinct and added rownum = 1
7038:
7039: CURSOR c1 IS
7040: SELECT DISTINCT asgn.project_id, proj.name, proj.segment1, proj.person_name, proj.carrying_out_organization_name, proj.customer_name
7041: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_project_lists_v proj
7042: WHERE asgn.assignment_id = hist.assignment_id
7043: AND hist.conflict_group_id = p_conflict_group_id
7044: AND asgn.project_id = proj.project_id;
7045:

Line 7052: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_projects_all proj

7048: /* Cursor added for bug 3115273 */
7049:
7050: CURSOR c1 IS
7051: SELECT asgn.project_id, proj.name, proj.segment1, proj.carrying_out_organization_id
7052: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_projects_all proj
7053: WHERE asgn.assignment_id = hist.assignment_id
7054: AND hist.conflict_group_id = p_conflict_group_id
7055: AND asgn.project_id = proj.project_id
7056: AND ROWNUM = 1;

Line 7063: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_projects_all proj

7059:
7060: -- Retrieve conflict projects info.
7061: CURSOR c2 IS
7062: SELECT DISTINCT asgn.project_id, proj.name, proj.segment1
7063: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_projects_all proj
7064: WHERE asgn.assignment_id = hist.conflict_assignment_id
7065: AND hist.conflict_group_id = p_conflict_group_id
7066: AND asgn.project_id = proj.project_id
7067: AND hist.self_conflict_flag = 'N';

Line 7499: FROM pa_assignment_conflict_hist conf, pa_project_assignments asgn

7495:
7496: -- 2167889: null instead of record_version_number
7497: CURSOR c1 IS
7498: SELECT DISTINCT conf.assignment_id, null record_version_number, asgn.assignment_type, asgn.start_date, asgn.end_date
7499: FROM pa_assignment_conflict_hist conf, pa_project_assignments asgn
7500: WHERE conf.conflict_group_id = p_conflict_group_id
7501: AND conf.assignment_id = asgn.assignment_id
7502: AND conf.resolve_conflicts_action_code = 'CANCEL_TXN_ITEM'
7503: AND conf.processed_flag = 'N';

Line 7678: FROM pa_assignment_conflict_hist hist, pa_project_assignments asgn

7674: IS
7675:
7676: CURSOR c1 IS
7677: SELECT hist.assignment_id
7678: FROM pa_assignment_conflict_hist hist, pa_project_assignments asgn
7679: WHERE hist.assignment_id = asgn.assignment_id
7680: AND hist.conflict_group_id = p_conflict_group_id
7681: AND asgn.apprvl_status_code = 'ASGMT_APPRVL_WORKING';
7682:

Line 8201: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;

8197: l_previous_value VARCHAR2(240);
8198: l_count NUMBER;
8199: l_multiple VARCHAR2(1);
8200: l_history_exist VARCHAR2(1);
8201: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
8202:
8203: CURSOR C1 IS
8204: SELECT calendar_id, calendar_type, start_date, end_date
8205: FROM pa_assignments_history

Line 8213: FROM pa_project_assignments

8209: v_c1 C1%ROWTYPE;
8210:
8211: CURSOR C1_CURRENT IS
8212: SELECT calendar_id, calendar_type, start_date, end_date
8213: FROM pa_project_assignments
8214: WHERE assignment_id = p_assignment_id;
8215:
8216: v_c1_current C1_CURRENT%ROWTYPE;
8217:

Line 8261: FROM pa_project_assignments

8257: v_c2_current C2_CURRENT%ROWTYPE;
8258:
8259: CURSOR get_apprvl_status_code IS
8260: SELECT apprvl_status_code
8261: FROM pa_project_assignments
8262: WHERE assignment_id = p_assignment_id;
8263:
8264: /* Added for bug 1524874*/
8265: TYPE change_hours_check_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 8666: FROM pa_project_assignments

8662: BEGIN
8663:
8664: SELECT start_date, end_date
8665: INTO l_start_date, l_end_date
8666: FROM pa_project_assignments
8667: WHERE assignment_id = p_assignment_id;
8668:
8669: IF (G_AVAILABILITY_CAL_PERIOD = 'DAILY' OR G_AVAILABILITY_CAL_PERIOD = 'WEEKLY') THEN
8670: SELECT COUNT(*)

Line 8684: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

8680: (select fi1.resource_id,
8681: fi1.item_quantity,
8682: fi1.item_date,
8683: fi1.delete_flag
8684: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
8685: where (fi1.assignment_id = p_assignment_id
8686: or fi1.assignment_id in
8687: (select conflict_assignment_id
8688: from pa_assignment_conflict_hist

Line 8706: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist

8702: select fi2.resource_id,
8703: item_quantity,
8704: fi2.item_date,
8705: fi2.delete_flag
8706: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist
8707: where fi2.assignment_id = asgn.assignment_id
8708: and fi2.assignment_id = hist.conflict_assignment_id
8709: and hist.conflict_group_id = p_conflict_group_id
8710: and hist.assignment_id = p_assignment_id

Line 8721: from pa_forecast_items fi2, pa_project_assignments asgn

8717: select fi2.resource_id,
8718: item_quantity,
8719: fi2.item_date,
8720: fi2.delete_flag
8721: from pa_forecast_items fi2, pa_project_assignments asgn
8722: where fi2.assignment_id = p_assignment_id
8723: and fi2.assignment_id = asgn.assignment_id
8724: and fi2.asgmt_sys_status_code = 'STAFFED_ASGMT_CONF'
8725: and asgn.apprvl_status_code in ('ASGMT_APPRVL_APPROVED', 'ASGMT_APPRVL_REJECTED')

Line 8926: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist

8922:
8923: l_affected VARCHAR2(1) := 'N';
8924: CURSOR c1 IS
8925: SELECT DISTINCT asgn.project_id
8926: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist
8927: WHERE asgn.assignment_id = hist.conflict_assignment_id
8928: AND hist.conflict_group_id = p_conflict_group_id
8929: AND hist.assignment_id = p_assignment_id;
8930: