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 2228: l_t_calendar_id pa_project_assignments.calendar_id%TYPE; -- to store the value for new creating hours

2224: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2225: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2226: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
2227: IS
2228: l_t_calendar_id pa_project_assignments.calendar_id%TYPE; -- to store the value for new creating hours
2229: l_t_calendar_type pa_project_assignments.calendar_type%TYPE; -- to store the value for new creating hours
2230: l_t_team_player_id NUMBER; -- to store the value for new creating hours
2231:
2232: l_t_resource_id NUMBER; -- to sto

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

2225: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2226: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
2227: IS
2228: l_t_calendar_id pa_project_assignments.calendar_id%TYPE; -- to store the value for new creating hours
2229: l_t_calendar_type pa_project_assignments.calendar_type%TYPE; -- to store the value for new creating hours
2230: l_t_team_player_id NUMBER; -- to store the value for new creating hours
2231:
2232: l_t_resource_id NUMBER; -- to sto
2233: l_t_asgn_type pa_project_assignments.assignment_type%TYPE; /*Bug 5682726*/

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

2229: l_t_calendar_type pa_project_assignments.calendar_type%TYPE; -- to store the value for new creating hours
2230: l_t_team_player_id NUMBER; -- to store the value for new creating hours
2231:
2232: l_t_resource_id NUMBER; -- to sto
2233: l_t_asgn_type pa_project_assignments.assignment_type%TYPE; /*Bug 5682726*/
2234: BEGIN
2235: PA_SCHEDULE_UTILS.log_message(1,'start of create new hours ... ');
2236: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
2237: PA_SCHEDULE_UTILS.log_message(1,'start of create new hours ...change_hours_type ...'||

Line 2267: FROM pa_project_assignments

2263: /* Bug 5682726 - Start Changes */
2264:
2265: SELECT assignment_type
2266: INTO l_t_asgn_type
2267: FROM pa_project_assignments
2268: where assignment_id = p_sch_except_record.assignment_id;
2269:
2270: IF ( l_t_asgn_type = 'STAFFED_ASSIGNMENT' OR l_t_asgn_type =
2271: 'STAFFED_ADMIN_ASSIGNMENT' ) THEN

Line 2277: FROM pa_project_assignments

2273: IF (p_sch_except_record.change_calendar_type_code = 'RESOURCE') THEN /*start bug#10141855*/
2274:
2275: SELECT project_party_id
2276: INTO l_t_team_player_id
2277: FROM pa_project_assignments
2278: WHERE assignment_id = p_sch_except_record.assignment_id;
2279:
2280: SELECT resource_id
2281: INTO l_t_resource_id

Line 2282: FROM pa_project_assignments

2278: WHERE assignment_id = p_sch_except_record.assignment_id;
2279:
2280: SELECT resource_id
2281: INTO l_t_resource_id
2282: FROM pa_project_assignments
2283: WHERE assignment_id = p_sch_except_record.assignment_id;
2284:
2285: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2286: PA_SCHEDULE_UTILS.check_calendar(p_resource_id => l_t_resource_id,

Line 2309: FROM pa_project_assignments

2305: ELSE
2306:
2307: SELECT calendar_id
2308: INTO l_t_calendar_id
2309: FROM pa_project_assignments
2310: where assignment_id = p_sch_except_record.assignment_id;
2311:
2312: PA_SCHEDULE_PVT.get_calendar_schedule( l_t_calendar_id,
2313: p_sch_except_record.start_date,

Line 2326: FROM pa_project_assignments

2322: ELSE
2323: IF ( l_t_asgn_type = 'OPEN_ASSIGNMENT' ) THEN
2324: SELECT calendar_id
2325: INTO l_t_calendar_id
2326: FROM pa_project_assignments
2327: where assignment_id = p_sch_except_record.assignment_id;
2328:
2329: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2330: PA_SCHEDULE_UTILS.check_calendar(p_calendar_id => l_t_calendar_id,

Line 2397: FROM pa_project_assignments

2393:
2394: -- get project_party_id to pass api 'get_resource_schedule'
2395: SELECT project_party_id
2396: INTO l_t_team_player_id
2397: FROM pa_project_assignments
2398: WHERE assignment_id = p_sch_except_record.assignment_id;
2399:
2400: SELECT resource_id
2401: INTO l_t_resource_id

Line 2402: FROM pa_project_assignments

2398: WHERE assignment_id = p_sch_except_record.assignment_id;
2399:
2400: SELECT resource_id
2401: INTO l_t_resource_id
2402: FROM pa_project_assignments
2403: WHERE assignment_id = p_sch_except_record.assignment_id;
2404:
2405: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2406: PA_SCHEDULE_UTILS.check_calendar(p_resource_id => l_t_resource_id,

Line 2550: FROM pa_project_assignments

2546: (p_sch_except_record.schedule_type_code = 'STAFFED_ADMIN_ASSIGNMENT') THEN
2547:
2548: SELECT project_party_id , resource_calendar_percent,calendar_id,calendar_type
2549: INTO l_t_team_player_id,l_t_res_cal_percent,l_t_calendar_id,l_t_calendar_type
2550: FROM pa_project_assignments
2551: WHERE assignment_id = p_sch_except_record.assignment_id;
2552:
2553: IF ( l_t_calendar_type = 'RESOURCE' ) THEN
2554: -- Calling the procedure get_resource_schedule which is assigned to the assignment

Line 3714: -- Bug#9114277 l_new_calendar_id pa_project_assignments.calendar_id%TYPE; ---- bug#9071974

3710: l_t_asgn_end_date DATE ; -- To Store Assignment End Date
3711: l_wf_type VARCHAR2(80);
3712: l_wf_item_type VARCHAR2(2000);
3713: l_wf_process VARCHAR2(2000);
3714: -- Bug#9114277 l_new_calendar_id pa_project_assignments.calendar_id%TYPE; ---- bug#9071974
3715: -- Bug#9114277 l_RESOURCE_CALENDAR_PERCENT pa_project_assignments.RESOURCE_CALENDAR_PERCENT%TYPE; ---- bug#9071974
3716: BEGIN
3717: -- Intilizing the variable */
3718: l_t_multi_flag := 'N';

Line 3715: -- Bug#9114277 l_RESOURCE_CALENDAR_PERCENT pa_project_assignments.RESOURCE_CALENDAR_PERCENT%TYPE; ---- bug#9071974

3711: l_wf_type VARCHAR2(80);
3712: l_wf_item_type VARCHAR2(2000);
3713: l_wf_process VARCHAR2(2000);
3714: -- Bug#9114277 l_new_calendar_id pa_project_assignments.calendar_id%TYPE; ---- bug#9071974
3715: -- Bug#9114277 l_RESOURCE_CALENDAR_PERCENT pa_project_assignments.RESOURCE_CALENDAR_PERCENT%TYPE; ---- bug#9071974
3716: BEGIN
3717: -- Intilizing the variable */
3718: l_t_multi_flag := 'N';
3719: l_change_flag := FALSE;

Line 3778: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row(

3774:
3775: -- if the records is having more than one status then updating the table for it column multi flag */
3776: IF (l_change_flag) THEN
3777: -- bug#9071974
3778: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row(
3779: p_record_version_number => p_record_version_number,
3780: p_assignment_id => l_t_assignment_id,
3781: p_start_date => nvl(l_t_start_date,FND_API.G_MISS_DATE),
3782: p_end_date => nvl(l_t_end_date,FND_API.G_MISS_DATE),

Line 3790: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row(

3786: pa_schedule_utils.get_num_hours(l_t_project_id, l_t_assignment_id),
3787: x_return_status => l_x_return_status );
3788: ELSE
3789: -- bug#9071974
3790: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row(
3791: p_record_version_number => p_record_version_number,
3792: p_assignment_id => l_t_assignment_id,
3793: p_assignment_effort =>
3794: pa_schedule_utils.get_num_hours(l_t_project_id, l_t_assignment_id),

Line 3827: pa_project_assignments proj_asgn

3823: l_t_record_version_number,
3824: l_t_asgn_start_date,
3825: l_t_asgn_end_date
3826: FROM pa_project_parties proj_part,
3827: pa_project_assignments proj_asgn
3828: WHERE proj_asgn.PROJECT_PARTY_ID = proj_part.PROJECT_PARTY_ID
3829: AND proj_asgn.ASSIGNMENT_ID = l_t_assignment_id;
3830:
3831: IF ( l_t_start_date is NULL ) THEN

Line 4240: l_assignment_id PA_PROJECT_ASSIGNMENTS.assignment_id%TYPE;

4236: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4237: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4238: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
4239:
4240: l_assignment_id PA_PROJECT_ASSIGNMENTS.assignment_id%TYPE;
4241: l_assignment_id_tbl PA_ASSIGNMENTS_PUB.assignment_id_tbl_type;
4242: l_x_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
4243: l_current_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
4244: l_temp_number NUMBER;

Line 4559: l_req_start_date PA_PROJECT_ASSIGNMENTS.start_date%TYPE;

4555:
4556: l_x_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- Temporary variable to store the
4557: -- schedule type table of records
4558:
4559: l_req_start_date PA_PROJECT_ASSIGNMENTS.start_date%TYPE;
4560: l_req_end_date pa_project_assignments.end_date%TYPE;
4561: l_calendar_id pa_project_assignments.calendar_id%TYPE;
4562:
4563: l_new_schedule_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

Line 4560: l_req_end_date pa_project_assignments.end_date%TYPE;

4556: l_x_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- Temporary variable to store the
4557: -- schedule type table of records
4558:
4559: l_req_start_date PA_PROJECT_ASSIGNMENTS.start_date%TYPE;
4560: l_req_end_date pa_project_assignments.end_date%TYPE;
4561: l_calendar_id pa_project_assignments.calendar_id%TYPE;
4562:
4563: l_new_schedule_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
4564:

Line 4561: l_calendar_id pa_project_assignments.calendar_id%TYPE;

4557: -- schedule type table of records
4558:
4559: l_req_start_date PA_PROJECT_ASSIGNMENTS.start_date%TYPE;
4560: l_req_end_date pa_project_assignments.end_date%TYPE;
4561: l_calendar_id pa_project_assignments.calendar_id%TYPE;
4562:
4563: l_new_schedule_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
4564:
4565: l_start_date DATE;

Line 4642: from pa_project_assignments

4638:
4639: -- code fix starts for bug 2335580
4640: SELECT start_date, end_date,calendar_id
4641: into l_req_start_date, l_req_end_date, l_calendar_id
4642: from pa_project_assignments
4643: where assignment_id=p_open_assignment_id;
4644:
4645:
4646: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

Line 4856: l_next_status_code pa_project_assignments.status_code%type;

4852: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4853: )
4854: IS
4855:
4856: l_next_status_code pa_project_assignments.status_code%type;
4857: l_temp_status_code pa_project_assignments.status_code%type;
4858: l_project_id pa_project_assignments.project_id%type;
4859: l_calendar_id pa_project_assignments.calendar_id%type;
4860: l_assignment_type pa_project_assignments.assignment_type%type;

Line 4857: l_temp_status_code pa_project_assignments.status_code%type;

4853: )
4854: IS
4855:
4856: l_next_status_code pa_project_assignments.status_code%type;
4857: l_temp_status_code pa_project_assignments.status_code%type;
4858: l_project_id pa_project_assignments.project_id%type;
4859: l_calendar_id pa_project_assignments.calendar_id%type;
4860: l_assignment_type pa_project_assignments.assignment_type%type;
4861: l_asgn_start_date pa_project_assignments.start_date%type;

Line 4858: l_project_id pa_project_assignments.project_id%type;

4854: IS
4855:
4856: l_next_status_code pa_project_assignments.status_code%type;
4857: l_temp_status_code pa_project_assignments.status_code%type;
4858: l_project_id pa_project_assignments.project_id%type;
4859: l_calendar_id pa_project_assignments.calendar_id%type;
4860: l_assignment_type pa_project_assignments.assignment_type%type;
4861: l_asgn_start_date pa_project_assignments.start_date%type;
4862: l_asgn_end_date pa_project_assignments.end_date%type;

Line 4859: l_calendar_id pa_project_assignments.calendar_id%type;

4855:
4856: l_next_status_code pa_project_assignments.status_code%type;
4857: l_temp_status_code pa_project_assignments.status_code%type;
4858: l_project_id pa_project_assignments.project_id%type;
4859: l_calendar_id pa_project_assignments.calendar_id%type;
4860: l_assignment_type pa_project_assignments.assignment_type%type;
4861: l_asgn_start_date pa_project_assignments.start_date%type;
4862: l_asgn_end_date pa_project_assignments.end_date%type;
4863: l_status_type VARCHAR2(30);

Line 4860: l_assignment_type pa_project_assignments.assignment_type%type;

4856: l_next_status_code pa_project_assignments.status_code%type;
4857: l_temp_status_code pa_project_assignments.status_code%type;
4858: l_project_id pa_project_assignments.project_id%type;
4859: l_calendar_id pa_project_assignments.calendar_id%type;
4860: l_assignment_type pa_project_assignments.assignment_type%type;
4861: l_asgn_start_date pa_project_assignments.start_date%type;
4862: l_asgn_end_date pa_project_assignments.end_date%type;
4863: l_status_type VARCHAR2(30);
4864: l_temp_index_out NUMBER;

Line 4861: l_asgn_start_date pa_project_assignments.start_date%type;

4857: l_temp_status_code pa_project_assignments.status_code%type;
4858: l_project_id pa_project_assignments.project_id%type;
4859: l_calendar_id pa_project_assignments.calendar_id%type;
4860: l_assignment_type pa_project_assignments.assignment_type%type;
4861: l_asgn_start_date pa_project_assignments.start_date%type;
4862: l_asgn_end_date pa_project_assignments.end_date%type;
4863: l_status_type VARCHAR2(30);
4864: l_temp_index_out NUMBER;
4865: l_record_version_number NUMBER;

Line 4862: l_asgn_end_date pa_project_assignments.end_date%type;

4858: l_project_id pa_project_assignments.project_id%type;
4859: l_calendar_id pa_project_assignments.calendar_id%type;
4860: l_assignment_type pa_project_assignments.assignment_type%type;
4861: l_asgn_start_date pa_project_assignments.start_date%type;
4862: l_asgn_end_date pa_project_assignments.end_date%type;
4863: l_status_type VARCHAR2(30);
4864: l_temp_index_out NUMBER;
4865: l_record_version_number NUMBER;
4866: -- added for Bug fix: 4537865

Line 4895: FROM pa_project_assignments

4891:
4892: CURSOR C2 IS
4893: SELECT project_id, calendar_id,
4894: assignment_type, start_date, end_date
4895: FROM pa_project_assignments
4896: WHERE assignment_id = p_assignment_id;
4897:
4898: BEGIN
4899: PA_SCHEDULE_UTILS.log_message(1,'Start of the update_sch_wf_success API');

Line 5183: L_next_status_code pa_project_assignments.status_code%type;

5179: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
5180: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5181: )
5182: IS
5183: L_next_status_code pa_project_assignments.status_code%type;
5184: l_temp_status_code pa_project_assignments.status_code%type;
5185: l_project_id pa_project_assignments.project_id%type;
5186: l_calendar_id pa_project_assignments.calendar_id%type;
5187: l_assignment_type pa_project_assignments.assignment_type%type;

Line 5184: l_temp_status_code pa_project_assignments.status_code%type;

5180: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5181: )
5182: IS
5183: L_next_status_code pa_project_assignments.status_code%type;
5184: l_temp_status_code pa_project_assignments.status_code%type;
5185: l_project_id pa_project_assignments.project_id%type;
5186: l_calendar_id pa_project_assignments.calendar_id%type;
5187: l_assignment_type pa_project_assignments.assignment_type%type;
5188: l_asgn_start_date pa_project_assignments.start_date%type;

Line 5185: l_project_id pa_project_assignments.project_id%type;

5181: )
5182: IS
5183: L_next_status_code pa_project_assignments.status_code%type;
5184: l_temp_status_code pa_project_assignments.status_code%type;
5185: l_project_id pa_project_assignments.project_id%type;
5186: l_calendar_id pa_project_assignments.calendar_id%type;
5187: l_assignment_type pa_project_assignments.assignment_type%type;
5188: l_asgn_start_date pa_project_assignments.start_date%type;
5189: l_asgn_end_date pa_project_assignments.end_date%type;

Line 5186: l_calendar_id pa_project_assignments.calendar_id%type;

5182: IS
5183: L_next_status_code pa_project_assignments.status_code%type;
5184: l_temp_status_code pa_project_assignments.status_code%type;
5185: l_project_id pa_project_assignments.project_id%type;
5186: l_calendar_id pa_project_assignments.calendar_id%type;
5187: l_assignment_type pa_project_assignments.assignment_type%type;
5188: l_asgn_start_date pa_project_assignments.start_date%type;
5189: l_asgn_end_date pa_project_assignments.end_date%type;
5190: l_status_type VARCHAR2(30);

Line 5187: l_assignment_type pa_project_assignments.assignment_type%type;

5183: L_next_status_code pa_project_assignments.status_code%type;
5184: l_temp_status_code pa_project_assignments.status_code%type;
5185: l_project_id pa_project_assignments.project_id%type;
5186: l_calendar_id pa_project_assignments.calendar_id%type;
5187: l_assignment_type pa_project_assignments.assignment_type%type;
5188: l_asgn_start_date pa_project_assignments.start_date%type;
5189: l_asgn_end_date pa_project_assignments.end_date%type;
5190: l_status_type VARCHAR2(30);
5191: l_temp_index_out NUMBER;

Line 5188: l_asgn_start_date pa_project_assignments.start_date%type;

5184: l_temp_status_code pa_project_assignments.status_code%type;
5185: l_project_id pa_project_assignments.project_id%type;
5186: l_calendar_id pa_project_assignments.calendar_id%type;
5187: l_assignment_type pa_project_assignments.assignment_type%type;
5188: l_asgn_start_date pa_project_assignments.start_date%type;
5189: l_asgn_end_date pa_project_assignments.end_date%type;
5190: l_status_type VARCHAR2(30);
5191: l_temp_index_out NUMBER;
5192: l_record_version_number NUMBER;

Line 5189: l_asgn_end_date pa_project_assignments.end_date%type;

5185: l_project_id pa_project_assignments.project_id%type;
5186: l_calendar_id pa_project_assignments.calendar_id%type;
5187: l_assignment_type pa_project_assignments.assignment_type%type;
5188: l_asgn_start_date pa_project_assignments.start_date%type;
5189: l_asgn_end_date pa_project_assignments.end_date%type;
5190: l_status_type VARCHAR2(30);
5191: l_temp_index_out NUMBER;
5192: l_record_version_number NUMBER;
5193: -- added for Bug Fix: 4537865

Line 5217: FROM pa_project_assignments

5213:
5214: CURSOR C2 IS
5215: SELECT project_id, calendar_id,
5216: assignment_type, start_date, end_date
5217: FROM pa_project_assignments
5218: WHERE assignment_id = p_assignment_id;
5219:
5220: BEGIN
5221: PA_SCHEDULE_UTILS.log_message(1,'Start of the update_sch_wf_failure API');

Line 5684: l_assignment_type pa_project_assignments.assignment_type%TYPE;

5680: /* End for bug 1635170*/
5681: l_start_date DATE;
5682: l_end_date DATE;
5683: l_project_calendar_id NUMBER;
5684: l_assignment_type pa_project_assignments.assignment_type%TYPE;
5685: l_status_code pa_schedules.status_code%TYPE;
5686: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
5687: l_shifted_days NUMBER;
5688: l_calendar_id NUMBER;

Line 5686: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;

5682: l_end_date DATE;
5683: l_project_calendar_id NUMBER;
5684: l_assignment_type pa_project_assignments.assignment_type%TYPE;
5685: l_status_code pa_schedules.status_code%TYPE;
5686: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
5687: l_shifted_days NUMBER;
5688: l_calendar_id NUMBER;
5689:
5690:

Line 5704: from pa_project_assignments

5700: AND change_id = p_change_id;
5701:
5702: CURSOR get_start_end_date IS
5703: Select start_date, end_date
5704: from pa_project_assignments
5705: where assignment_id = p_assignment_id;
5706:
5707: CURSOR get_apprvl_status_code IS
5708: SELECT apprvl_status_code

Line 5709: FROM pa_project_assignments

5705: where assignment_id = p_assignment_id;
5706:
5707: CURSOR get_apprvl_status_code IS
5708: SELECT apprvl_status_code
5709: FROM pa_project_assignments
5710: WHERE assignment_id = p_assignment_id;
5711:
5712: CURSOR get_project_calendar_id IS
5713: SELECT prj.calendar_id

Line 5715: pa_project_assignments asmt

5711:
5712: CURSOR get_project_calendar_id IS
5713: SELECT prj.calendar_id
5714: FROM pa_projects_all prj,
5715: pa_project_assignments asmt
5716: WHERE asmt.assignment_id = p_assignment_id
5717: AND prj.project_id = asmt.project_id;
5718:
5719: BEGIN

Line 5926: FROM pa_project_assignments

5922: ELSIF (p_exception_type_code = 'CHANGE_HOURS' AND p_change_hours_type_code='PERCENTAGE' AND
5923: p_change_calendar_type_code='PROEJCT') THEN
5924: SELECT calendar_id
5925: INTO l_project_calendar_id
5926: FROM pa_project_assignments
5927: WHERE assignment_id = p_assignment_id;
5928:
5929: -- If Status has been updated, pass appropriate status_code
5930: ELSIF (p_exception_type_code = 'CHANGE_STATUS') THEN

Line 5933: FROM pa_project_assignments

5929: -- If Status has been updated, pass appropriate status_code
5930: ELSIF (p_exception_type_code = 'CHANGE_STATUS') THEN
5931: SELECT assignment_type
5932: INTO l_assignment_type
5933: FROM pa_project_assignments
5934: WHERE assignment_id = p_assignment_id;
5935:
5936: IF (l_assignment_type = 'OPEN_ASSIGNMENT') THEN
5937: l_status_code := p_requirement_status_code;

Line 5999: FROM pa_project_assignments

5995: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
5996:
5997: CURSOR c1 IS
5998: SELECT resource_id, start_date, end_date
5999: FROM pa_project_assignments
6000: WHERE assignment_id = p_assignment_id;
6001:
6002: l_assignment_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6003: l_resource_id NUMBER;

Line 6220: FROM pa_project_assignments

6216: IF v_c1.assignment_id IS NOT NULL THEN
6217: PA_SCHEDULE_UTILS.debug('v_c1.assignment_id = '|| v_c1.assignment_id);
6218: SELECT resource_id, start_date, end_date
6219: INTO l_resource_id, l_start_date, l_end_date
6220: FROM pa_project_assignments
6221: WHERE assignment_id = v_c1.assignment_id;
6222: PA_SCHEDULE_UTILS.debug('l_resource_id = '|| l_resource_id);
6223:
6224: IF G_AVAILABILITY_CAL_PERIOD = 'DAILY' THEN

Line 6618: FROM pa_assignment_conflict_hist hist, pa_project_assignments asgn

6614: SELECT conflict_assignment_id,
6615: decode(asgn.MASS_WF_IN_PROGRESS_FLAG,
6616: 'Y', decode(hist.intra_txn_conflict_flag, 'N', 'Y', 'N'),
6617: decode(asgn.apprvl_status_code, 'ASGMT_APPRVL_SUBMITTED', 'Y', 'N')) locking_flag
6618: FROM pa_assignment_conflict_hist hist, pa_project_assignments asgn
6619: WHERE hist.conflict_assignment_id = asgn.assignment_id
6620: AND hist.conflict_group_id = p_conflict_group_id
6621: AND hist.assignment_id = p_assignment_id
6622: AND hist.processed_flag = 'N'

Line 6637: l_assignment_type pa_project_assignments.assignment_type%TYPE;

6633: -- PA_SCHEDULE_PUB.change_work_pattern.
6634: l_record_version_number NUMBER;
6635: l_project_id NUMBER;
6636: l_calendar_id NUMBER;
6637: l_assignment_type pa_project_assignments.assignment_type%TYPE;
6638: l_start_date DATE;
6639: l_end_date DATE;
6640: l_asgn_start_date DATE;
6641: l_asgn_end_date DATE;

Line 6705: FROM pa_project_assignments

6701: END LOOP;
6702:
6703: SELECT resource_id, start_date, end_date
6704: INTO l_resource_id, l_asn_start_date, l_asn_end_date
6705: FROM pa_project_assignments
6706: WHERE assignment_id = p_assignment_id;
6707:
6708: IF G_AVAILABILITY_CAL_PERIOD = 'DAILY' THEN
6709: l_conflict_start_date := l_asn_start_date;

Line 6898: FROM pa_project_assignments

6894: PA_SCHEDULE_UTILS.debug ('Entering c3 loop');
6895: -- 2167889: null instead of record_version_number
6896: SELECT null, project_id, calendar_id, assignment_type,start_date, end_date
6897: INTO l_record_version_number, l_project_id, l_calendar_id, l_assignment_type, l_asgn_start_date, l_asgn_end_date
6898: FROM pa_project_assignments
6899: WHERE assignment_id = v_c3.conflict_assignment_id;
6900: PA_SCHEDULE_UTILS.debug ('l_work_pattern_tbl.COUNT = '|| l_work_pattern_tbl.COUNT);
6901: FOR i IN l_work_pattern_tbl.FIRST .. l_work_pattern_tbl.LAST LOOP
6902: IF l_work_pattern_tbl(i).assignment_id = v_c3.conflict_assignment_id THEN

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

7330: Also removed distinct and added rownum = 1
7331:
7332: CURSOR c1 IS
7333: SELECT DISTINCT asgn.project_id, proj.name, proj.segment1, proj.person_name, proj.carrying_out_organization_name, proj.customer_name
7334: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_project_lists_v proj
7335: WHERE asgn.assignment_id = hist.assignment_id
7336: AND hist.conflict_group_id = p_conflict_group_id
7337: AND asgn.project_id = proj.project_id;
7338:

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

7341: /* Cursor added for bug 3115273 */
7342:
7343: CURSOR c1 IS
7344: SELECT asgn.project_id, proj.name, proj.segment1, proj.carrying_out_organization_id
7345: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_projects_all proj
7346: WHERE asgn.assignment_id = hist.assignment_id
7347: AND hist.conflict_group_id = p_conflict_group_id
7348: AND asgn.project_id = proj.project_id
7349: AND ROWNUM = 1;

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

7352:
7353: -- Retrieve conflict projects info.
7354: CURSOR c2 IS
7355: SELECT DISTINCT asgn.project_id, proj.name, proj.segment1
7356: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_projects_all proj
7357: WHERE asgn.assignment_id = hist.conflict_assignment_id
7358: AND hist.conflict_group_id = p_conflict_group_id
7359: AND asgn.project_id = proj.project_id
7360: AND hist.self_conflict_flag = 'N';

Line 7792: FROM pa_assignment_conflict_hist conf, pa_project_assignments asgn

7788:
7789: -- 2167889: null instead of record_version_number
7790: CURSOR c1 IS
7791: SELECT DISTINCT conf.assignment_id, null record_version_number, asgn.assignment_type, asgn.start_date, asgn.end_date
7792: FROM pa_assignment_conflict_hist conf, pa_project_assignments asgn
7793: WHERE conf.conflict_group_id = p_conflict_group_id
7794: AND conf.assignment_id = asgn.assignment_id
7795: AND conf.resolve_conflicts_action_code = 'CANCEL_TXN_ITEM'
7796: AND conf.processed_flag = 'N';

Line 7971: FROM pa_assignment_conflict_hist hist, pa_project_assignments asgn

7967: IS
7968:
7969: CURSOR c1 IS
7970: SELECT hist.assignment_id
7971: FROM pa_assignment_conflict_hist hist, pa_project_assignments asgn
7972: WHERE hist.assignment_id = asgn.assignment_id
7973: AND hist.conflict_group_id = p_conflict_group_id
7974: AND asgn.apprvl_status_code = 'ASGMT_APPRVL_WORKING';
7975:

Line 8494: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;

8490: l_previous_value VARCHAR2(240);
8491: l_count NUMBER;
8492: l_multiple VARCHAR2(1);
8493: l_history_exist VARCHAR2(1);
8494: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
8495:
8496: CURSOR C1 IS
8497: SELECT calendar_id, calendar_type, start_date, end_date
8498: FROM pa_assignments_history

Line 8506: FROM pa_project_assignments

8502: v_c1 C1%ROWTYPE;
8503:
8504: CURSOR C1_CURRENT IS
8505: SELECT calendar_id, calendar_type, start_date, end_date
8506: FROM pa_project_assignments
8507: WHERE assignment_id = p_assignment_id;
8508:
8509: v_c1_current C1_CURRENT%ROWTYPE;
8510:

Line 8554: FROM pa_project_assignments

8550: v_c2_current C2_CURRENT%ROWTYPE;
8551:
8552: CURSOR get_apprvl_status_code IS
8553: SELECT apprvl_status_code
8554: FROM pa_project_assignments
8555: WHERE assignment_id = p_assignment_id;
8556:
8557: /* Added for bug 1524874*/
8558: TYPE change_hours_check_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 8959: FROM pa_project_assignments

8955: BEGIN
8956:
8957: SELECT start_date, end_date
8958: INTO l_start_date, l_end_date
8959: FROM pa_project_assignments
8960: WHERE assignment_id = p_assignment_id;
8961:
8962: IF (G_AVAILABILITY_CAL_PERIOD = 'DAILY' OR G_AVAILABILITY_CAL_PERIOD = 'WEEKLY') THEN
8963: SELECT COUNT(*)

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

8973: (select fi1.resource_id,
8974: fi1.item_quantity,
8975: fi1.item_date,
8976: fi1.delete_flag
8977: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
8978: where (fi1.assignment_id = p_assignment_id
8979: or fi1.assignment_id in
8980: (select conflict_assignment_id
8981: from pa_assignment_conflict_hist

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

8995: select fi2.resource_id,
8996: item_quantity,
8997: fi2.item_date,
8998: fi2.delete_flag
8999: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist
9000: where fi2.assignment_id = asgn.assignment_id
9001: and fi2.assignment_id = hist.conflict_assignment_id
9002: and hist.conflict_group_id = p_conflict_group_id
9003: and hist.assignment_id = p_assignment_id

Line 9014: from pa_forecast_items fi2, pa_project_assignments asgn

9010: select fi2.resource_id,
9011: item_quantity,
9012: fi2.item_date,
9013: fi2.delete_flag
9014: from pa_forecast_items fi2, pa_project_assignments asgn
9015: where fi2.assignment_id = p_assignment_id
9016: and fi2.assignment_id = asgn.assignment_id
9017: and fi2.asgmt_sys_status_code = 'STAFFED_ASGMT_CONF'
9018: and asgn.apprvl_status_code in ('ASGMT_APPRVL_APPROVED', 'ASGMT_APPRVL_REJECTED')

Line 9219: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist

9215:
9216: l_affected VARCHAR2(1) := 'N';
9217: CURSOR c1 IS
9218: SELECT DISTINCT asgn.project_id
9219: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist
9220: WHERE asgn.assignment_id = hist.conflict_assignment_id
9221: AND hist.conflict_group_id = p_conflict_group_id
9222: AND hist.assignment_id = p_assignment_id;
9223: