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

Line 32: (SELECT 'x' FROM pa_project_assignments

28: SELECT 'Y', 'PA_STATUS_EXIST_IN_ASGMT'
29: INTO x_in_use_flag, x_error_message_code
30: FROM dual
31: WHERE EXISTS
32: (SELECT 'x' FROM pa_project_assignments
33: WHERE status_code = p_status_code)
34: OR EXISTS
35: (SELECT 'x' FROM pa_schedules
36: WHERE status_code = p_status_code)

Line 38: (SELECT 'x' FROM pa_project_assignments

34: OR EXISTS
35: (SELECT 'x' FROM pa_schedules
36: WHERE status_code = p_status_code)
37: OR EXISTS
38: (SELECT 'x' FROM pa_project_assignments
39: WHERE apprvl_status_code = p_status_code);
40:
41: SELECT 'Y', 'PA_STATUS_EXIST_IN_ASGMT'
42: INTO x_in_use_flag, x_error_message_code

Line 43: FROM pa_project_assignments ppa,

39: WHERE apprvl_status_code = p_status_code);
40:
41: SELECT 'Y', 'PA_STATUS_EXIST_IN_ASGMT'
42: INTO x_in_use_flag, x_error_message_code
43: FROM pa_project_assignments ppa,
44: pa_schedules ps
45: WHERE
46: ( ( ppa.status_code = p_status_code)
47: OR ( ps.status_code = p_status_code)

Line 55: FROM pa_project_assignments

51:
52: BEGIN
53: SELECT 'Y', 'PA_STATUS_EXIST_IN_ASGMT'
54: INTO x_in_use_flag, x_error_message_code
55: FROM pa_project_assignments
56: WHERE status_code = p_status_code
57: AND rownum = 1;
58: EXCEPTION
59: WHEN NO_DATA_FOUND THEN

Line 67: FROM pa_project_assignments

63: BEGIN
64: IF x_in_use_flag = 'N' THEN
65: SELECT 'Y', 'PA_STATUS_EXIST_IN_ASGMT'
66: INTO x_in_use_flag, x_error_message_code
67: FROM pa_project_assignments
68: WHERE apprvl_status_code = p_status_code
69: AND rownum = 1;
70: END IF;
71: EXCEPTION

Line 129: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE

125: -- to get project business group
126: -- BUG: 1904822
127: PROCEDURE Validate_Asgmt_Competency
128: ( p_project_id IN pa_projects_all.project_id%TYPE
129: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE
130: ,p_competence_id IN per_competences.competence_id%TYPE
131: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
132: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
133: l_comp_bg_id NUMBER := 0;

Line 233: FROM pa_project_assignments

229: BEGIN
230: pa_debug.init_err_stack ('pa_assignment_utils.Get_Project_Id');
231: SELECT project_id
232: INTO l_project_id
233: FROM pa_project_assignments
234: WHERE assignment_id = p_assignment_id ;
235: pa_debug.reset_err_stack;
236: RETURN l_project_id ;
237: EXCEPTION

Line 388: (SELECT 'x' FROM pa_project_assignments

384: SELECT 'Y', 'PA_PROJ_ASSIGNMENTS_EXIST'
385: INTO x_assignments_exist_flag, x_error_message_code
386: FROM dual
387: WHERE EXISTS
388: (SELECT 'x' FROM pa_project_assignments
389: WHERE project_id = p_project_id);
390: */
391: SELECT 'Y', 'PA_PROJ_ASSIGNMENTS_EXIST'
392: INTO x_assignments_exist_flag, x_error_message_code

Line 393: FROM pa_project_assignments

389: WHERE project_id = p_project_id);
390: */
391: SELECT 'Y', 'PA_PROJ_ASSIGNMENTS_EXIST'
392: INTO x_assignments_exist_flag, x_error_message_code
393: FROM pa_project_assignments
394: WHERE project_id = p_project_id
395: AND rownum=1;
396:
397: pa_debug.reset_err_stack;

Line 415: PROCEDURE Check_Assignment_Number_Or_Id( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
412: RAISE;
413: END check_proj_assignments_exist;
414:
415: PROCEDURE Check_Assignment_Number_Or_Id( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
416: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE
417: ,p_check_id_flag IN VARCHAR2 := 'A'
418: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
419: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 416: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE

412: RAISE;
413: END check_proj_assignments_exist;
414:
415: PROCEDURE Check_Assignment_Number_Or_Id( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
416: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE
417: ,p_check_id_flag IN VARCHAR2 := 'A'
418: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
419: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
420: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 418: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895

414:
415: PROCEDURE Check_Assignment_Number_Or_Id( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
416: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE
417: ,p_check_id_flag IN VARCHAR2 := 'A'
418: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
419: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
420: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
421: CURSOR c_ids IS
422: SELECT assignment_id

Line 423: FROM pa_project_assignments

419: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
420: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
421: CURSOR c_ids IS
422: SELECT assignment_id
423: FROM pa_project_assignments
424: WHERE assignment_number = p_assignment_number;
425:
426: l_id_found_flag VARCHAR2(1);
427: l_current_id pa_project_assignments.assignment_id%TYPE;

Line 427: l_current_id pa_project_assignments.assignment_id%TYPE;

423: FROM pa_project_assignments
424: WHERE assignment_number = p_assignment_number;
425:
426: l_id_found_flag VARCHAR2(1);
427: l_current_id pa_project_assignments.assignment_id%TYPE;
428: l_num_ids NUMBER;
429: BEGIN
430: pa_debug.init_err_stack ('pa_assignment_utils.check_assignment_number_or_id');
431: IF p_assignment_id IS NOT NULL AND p_assignment_id <> FND_API.G_MISS_NUM THEN

Line 435: FROM pa_project_assignments

431: IF p_assignment_id IS NOT NULL AND p_assignment_id <> FND_API.G_MISS_NUM THEN
432: IF p_check_id_flag = 'Y' THEN
433: SELECT assignment_id
434: INTO x_assignment_id
435: FROM pa_project_assignments
436: WHERE assignment_number = p_assignment_number;
437: ELSIF p_check_id_flag = 'N' THEN
438: x_assignment_id := p_assignment_id;
439: ELSIF p_check_id_flag = 'A' THEN

Line 474: FROM pa_project_assignments

470: ELSE
471: IF (p_assignment_number IS NOT NULL) THEN
472: SELECT assignment_id
473: INTO x_assignment_id
474: FROM pa_project_assignments
475: WHERE assignment_number = p_assignment_number;
476: ELSE
477: x_assignment_id := NULL;
478: END IF;

Line 504: PROCEDURE Check_STF_PriorityName_Or_Code (p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE

500: x_assignment_id := NULL;
501: RAISE;
502: END Check_Assignment_Number_Or_Id;
503:
504: PROCEDURE Check_STF_PriorityName_Or_Code (p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE
505: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE
506: ,p_check_id_flag IN VARCHAR2
507: ,x_staffing_priority_code OUT NOCOPY pa_project_assignments.staffing_priority_code%TYPE --File.Sql.39 bug 4440895
508: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 507: ,x_staffing_priority_code OUT NOCOPY pa_project_assignments.staffing_priority_code%TYPE --File.Sql.39 bug 4440895

503:
504: PROCEDURE Check_STF_PriorityName_Or_Code (p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE
505: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE
506: ,p_check_id_flag IN VARCHAR2
507: ,x_staffing_priority_code OUT NOCOPY pa_project_assignments.staffing_priority_code%TYPE --File.Sql.39 bug 4440895
508: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
509: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
510: BEGIN
511: pa_debug.init_err_stack ('pa_assignment_utils.Check_STF_PriorityName_Or_Code');

Line 563: l_today_date pa_project_assignments.start_date%TYPE;

559: IS
560:
561: l_lookup_code pa_lookups.lookup_code%TYPE;
562: l_meaning pa_lookups.meaning%TYPE;
563: l_today_date pa_project_assignments.start_date%TYPE;
564:
565: CURSOR get_meaning IS
566: SELECT meaning
567: FROM pa_lookups

Line 610: l_today_date pa_project_assignments.start_date%TYPE;

606: p_num_of_weeks IN NUMBER) RETURN DATE
607: IS
608:
609: l_date DATE;
610: l_today_date pa_project_assignments.start_date%TYPE;
611:
612: BEGIN
613:
614: l_today_date := TRUNC(sysdate);

Line 841: ,p_project_id IN pa_project_assignments.project_id%TYPE

837: -- x_error_message_code OUT
838: --
839: PROCEDURE Get_Person_Asgmt
840: ( p_person_id IN pa_resources_denorm.person_id%TYPE
841: ,p_project_id IN pa_project_assignments.project_id%TYPE
842: ,p_ei_date IN DATE
843: ,x_assignment_name IN OUT NOCOPY pa_project_assignments.assignment_name%TYPE --File.Sql.39 bug 4440895
844: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
845: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 843: ,x_assignment_name IN OUT NOCOPY pa_project_assignments.assignment_name%TYPE --File.Sql.39 bug 4440895

839: PROCEDURE Get_Person_Asgmt
840: ( p_person_id IN pa_resources_denorm.person_id%TYPE
841: ,p_project_id IN pa_project_assignments.project_id%TYPE
842: ,p_ei_date IN DATE
843: ,x_assignment_name IN OUT NOCOPY pa_project_assignments.assignment_name%TYPE --File.Sql.39 bug 4440895
844: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
845: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
846: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
847:

Line 844: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895

840: ( p_person_id IN pa_resources_denorm.person_id%TYPE
841: ,p_project_id IN pa_project_assignments.project_id%TYPE
842: ,p_ei_date IN DATE
843: ,x_assignment_name IN OUT NOCOPY pa_project_assignments.assignment_name%TYPE --File.Sql.39 bug 4440895
844: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
845: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
846: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
847:
848: l_row_count NUMBER := 0;

Line 850: l_assignment_id pa_project_assignments.assignment_id%TYPE;

846: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
847:
848: l_row_count NUMBER := 0;
849: l_found boolean := FALSE;
850: l_assignment_id pa_project_assignments.assignment_id%TYPE;
851: l_assignment_name pa_project_assignments.assignment_name%TYPE;
852:
853: CURSOR get_assignment_with_name IS
854: SELECT assignment_id, assignment_name

Line 851: l_assignment_name pa_project_assignments.assignment_name%TYPE;

847:
848: l_row_count NUMBER := 0;
849: l_found boolean := FALSE;
850: l_assignment_id pa_project_assignments.assignment_id%TYPE;
851: l_assignment_name pa_project_assignments.assignment_name%TYPE;
852:
853: CURSOR get_assignment_with_name IS
854: SELECT assignment_id, assignment_name
855: FROM pa_proj_assignments_actuals_v

Line 977: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

973: -- NOTE: This Function is solely used in discoverer report TR2
974: -- Workbook: Team Role Details Worksheet: Assignment Details
975: ------------------------------------------------------------------------------------
976: FUNCTION Get_Assignment_Measures
977: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
978: ,p_resource_id IN pa_project_assignments.resource_id%TYPE
979: ,p_asgn_effort IN pa_project_assignments.assignment_effort%TYPE
980: ,p_asgn_start_date IN pa_project_assignments.start_date%TYPE
981: ,p_asgn_end_date IN pa_project_assignments.end_date%TYPE

Line 978: ,p_resource_id IN pa_project_assignments.resource_id%TYPE

974: -- Workbook: Team Role Details Worksheet: Assignment Details
975: ------------------------------------------------------------------------------------
976: FUNCTION Get_Assignment_Measures
977: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
978: ,p_resource_id IN pa_project_assignments.resource_id%TYPE
979: ,p_asgn_effort IN pa_project_assignments.assignment_effort%TYPE
980: ,p_asgn_start_date IN pa_project_assignments.start_date%TYPE
981: ,p_asgn_end_date IN pa_project_assignments.end_date%TYPE
982: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE)

Line 979: ,p_asgn_effort IN pa_project_assignments.assignment_effort%TYPE

975: ------------------------------------------------------------------------------------
976: FUNCTION Get_Assignment_Measures
977: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
978: ,p_resource_id IN pa_project_assignments.resource_id%TYPE
979: ,p_asgn_effort IN pa_project_assignments.assignment_effort%TYPE
980: ,p_asgn_start_date IN pa_project_assignments.start_date%TYPE
981: ,p_asgn_end_date IN pa_project_assignments.end_date%TYPE
982: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE)
983: RETURN NUMBER

Line 980: ,p_asgn_start_date IN pa_project_assignments.start_date%TYPE

976: FUNCTION Get_Assignment_Measures
977: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
978: ,p_resource_id IN pa_project_assignments.resource_id%TYPE
979: ,p_asgn_effort IN pa_project_assignments.assignment_effort%TYPE
980: ,p_asgn_start_date IN pa_project_assignments.start_date%TYPE
981: ,p_asgn_end_date IN pa_project_assignments.end_date%TYPE
982: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE)
983: RETURN NUMBER
984: IS

Line 981: ,p_asgn_end_date IN pa_project_assignments.end_date%TYPE

977: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
978: ,p_resource_id IN pa_project_assignments.resource_id%TYPE
979: ,p_asgn_effort IN pa_project_assignments.assignment_effort%TYPE
980: ,p_asgn_start_date IN pa_project_assignments.start_date%TYPE
981: ,p_asgn_end_date IN pa_project_assignments.end_date%TYPE
982: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE)
983: RETURN NUMBER
984: IS
985: l_res_capacity_hrs NUMBER;

Line 982: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE)

978: ,p_resource_id IN pa_project_assignments.resource_id%TYPE
979: ,p_asgn_effort IN pa_project_assignments.assignment_effort%TYPE
980: ,p_asgn_start_date IN pa_project_assignments.start_date%TYPE
981: ,p_asgn_end_date IN pa_project_assignments.end_date%TYPE
982: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE)
983: RETURN NUMBER
984: IS
985: l_res_capacity_hrs NUMBER;
986: l_provisional_flag VARCHAR2(1);

Line 1081: ,p_exp_org_id IN pa_project_assignments.expenditure_org_id%TYPE := NULL

1077: -- effective_start_date and effective_end_date. And commented of the condition ROWNUM =1
1078: ------------------------------------------------------------------------------
1079: PROCEDURE Get_Default_Staffing_Owner
1080: ( p_project_id IN pa_projects_all.project_id%TYPE
1081: ,p_exp_org_id IN pa_project_assignments.expenditure_org_id%TYPE := NULL
1082: ,x_person_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1083: ,x_person_name OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1084: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1085: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 1089: l_exp_org_id pa_project_assignments.expenditure_org_id%TYPE := null;

1085: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
1086:
1087: l_person_id NUMBER := null;
1088: l_person_name PER_PEOPLE_F.full_name%TYPE := null;
1089: l_exp_org_id pa_project_assignments.expenditure_org_id%TYPE := null;
1090:
1091: CURSOR get_team_member(c_project_role_id NUMBER) IS
1092: SELECT pp.resource_source_id, res.full_name
1093: FROM pa_project_parties pp

Line 1158: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

1154: -- HISTORY
1155: -- 29-APR-2003 shyugen Created
1156: ------------------------------------------------------------------------------
1157: PROCEDURE Get_All_Staffing_Owners
1158: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
1159: ,p_project_id IN pa_projects_all.project_id%TYPE
1160: ,x_person_id_tbl OUT NOCOPY system.pa_num_tbl_type --File.Sql.39 bug 4440895
1161: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1162: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 1182: FROM pa_project_assignments,

1178: AND TRUNC ( sysdate ) BETWEEN effective_start_date AND effective_end_date
1179: AND ( ppf.current_employee_flag = 'Y' OR ppf.current_npw_flag = 'Y' )
1180: UNION ALL
1181: SELECT staffing_owner_person_id
1182: FROM pa_project_assignments,
1183: per_all_people_f ppf
1184: WHERE assignment_id = p_assignment_id
1185: AND ppf.person_id = staffing_owner_person_id -- Bug Ref # 6802697
1186: AND TRUNC ( sysdate ) BETWEEN effective_start_date AND effective_end_date

Line 1266: from pa_project_assignments asgn,

1262: asgn.expenditure_organization_id,
1263: asgn.expenditure_type,
1264: asgn.project_role_id,
1265: asgn.assignment_name
1266: from pa_project_assignments asgn,
1267: pa_project_statuses ps
1268: where asgn.project_id = p_project_id
1269: and asgn.assignment_type = 'OPEN_ASSIGNMENT'
1270: and asgn.status_code = ps.project_status_code(+)

Line 1287: from pa_project_assignments asgn,

1283: asgn.expenditure_type,
1284: asgn.project_role_id,
1285: decode(peo.current_employee_flag, 'Y', 'EMP', 'CWK'), --ppt.system_person_type,
1286: asgn.assignment_name
1287: from pa_project_assignments asgn,
1288: pa_project_statuses ps,
1289: per_person_type_usages_f ptuf,
1290: per_person_types ppt,
1291: per_all_assignments_f aaf,

Line 1320: from pa_project_assignments asgn,

1316: asgn.expenditure_type,
1317: asgn.project_role_id,
1318: ppt.system_person_type,
1319: asgn.assignment_name
1320: from pa_project_assignments asgn,
1321: pa_project_statuses ps,
1322: per_person_type_usages_f ptuf,
1323: per_person_types ppt,
1324: per_all_assignments_f aaf,

Line 1340: from pa_project_assignments

1336: and asgn.start_date between ptuf.effective_start_date AND ptuf.effective_end_date;
1337: */
1338: cursor team_role_exists is
1339: SELECT 'T'
1340: from pa_project_assignments
1341: where resource_list_member_id is not null
1342: and project_id = p_project_id
1343: and rownum = 1;
1344:

Line 1463: UPDATE pa_project_assignments

1459: END IF;
1460: END LOOP;
1461:
1462: FORALL i IN l_assignment_id_tbl.FIRST .. l_assignment_id_tbl.LAST
1463: UPDATE pa_project_assignments
1464: SET resource_list_member_id = l_res_list_member_id_tbl(i),
1465: record_version_number = nvl(record_version_number,0) + 1
1466: WHERE assignment_id = l_assignment_id_tbl(i);
1467:

Line 1509: UPDATE pa_project_assignments

1505: END IF;
1506: END LOOP;
1507:
1508: FORALL i IN l_assignment_id_tbl.FIRST .. l_assignment_id_tbl.LAST
1509: UPDATE pa_project_assignments
1510: SET resource_list_member_id = l_res_list_member_id_tbl(i),
1511: record_version_number = nvl(record_version_number, 0) + 1
1512: WHERE assignment_id = l_assignment_id_tbl(i);
1513:

Line 1579: from pa_project_assignments pap, pa_project_statuses stat

1575: p_project_id IN NUMBER) RETURN NUMBER IS
1576:
1577: Cursor C_ASMT_ID IS
1578: select distinct pap.assignment_id
1579: from pa_project_assignments pap, pa_project_statuses stat
1580: where pap.resource_list_member_id = p_resource_list_member_id
1581: and pap.project_id = p_project_id
1582: and pap.STATUS_CODE = stat.PROJECT_STATUS_CODE (+)
1583: and nvl(stat.PROJECT_SYSTEM_STATUS_CODE, '-1') not in ('OPEN_ASGMT_CANCEL','STAFFED_ASGMT_CANCEL', 'OPEN_ASGMT_FILLED');

Line 1608: from pa_project_assignments pap, pa_project_statuses stat

1604: p_project_id IN NUMBER) RETURN VARCHAR2 IS
1605:
1606: Cursor C_ASMT_TYPE IS
1607: select distinct pap.assignment_type
1608: from pa_project_assignments pap, pa_project_statuses stat
1609: where pap.resource_list_member_id = p_resource_list_member_id
1610: and pap.project_id = p_project_id
1611: and pap.STATUS_CODE = stat.PROJECT_STATUS_CODE (+)
1612: and nvl(stat.PROJECT_SYSTEM_STATUS_CODE, '-1') not in ('OPEN_ASGMT_CANCEL','STAFFED_ASGMT_CANCEL', 'OPEN_ASGMT_FILLED');

Line 1660: select count(*) from pa_project_assignments pa

1656:
1657: FUNCTION Get_single_submitted_status(p_project_id IN NUMBER, p_resource_list_member_id IN NUMBER)
1658: RETURN VARCHAR2 IS
1659: Cursor C_Team_Role_Count IS
1660: select count(*) from pa_project_assignments pa
1661: where pa.project_id = p_project_id
1662: and pa.resource_list_member_id = p_resource_list_member_id;
1663:
1664: Cursor C_Submitted_Count IS

Line 1665: select count(*) from pa_project_assignments pa

1661: where pa.project_id = p_project_id
1662: and pa.resource_list_member_id = p_resource_list_member_id;
1663:
1664: Cursor C_Submitted_Count IS
1665: select count(*) from pa_project_assignments pa
1666: where pa.project_id = p_project_id
1667: and pa.resource_list_member_id = p_resource_list_member_id
1668: and pa.APPRVL_STATUS_CODE = 'ASGMT_APPRVL_SUBMITTED';
1669:

Line 1712: from pa_resource_assignments ra , pa_project_assignments pa

1708: RETURN VARCHAR2 IS
1709:
1710: Cursor C_At_Risk_Start IS
1711: select ra.schedule_start_date, pa.start_date, pa.end_date
1712: from pa_resource_assignments ra , pa_project_assignments pa
1713: where pa.assignment_id = ra.project_assignment_id
1714: and ra.project_id = p_project_id
1715: and ra.budget_version_id = p_budget_version_id
1716: and ra.resource_list_member_id = p_resource_list_member_id;

Line 1721: from pa_resource_assignments ra , pa_project_assignments pa

1717: C_At_Risk_Start_Rec C_At_Risk_Start%ROWTYPE;
1718:
1719: Cursor C_At_Risk_End IS
1720: select ra.schedule_end_date, pa.end_date, pa.start_date
1721: from pa_resource_assignments ra , pa_project_assignments pa
1722: where pa.assignment_id = ra.project_assignment_id
1723: and ra.project_id = p_project_id
1724: and ra.budget_version_id = p_budget_version_id
1725: and ra.resource_list_member_id = p_resource_list_member_id;

Line 1799: from pa_project_assignments pap, pa_project_statuses stat

1795: RETURN DATE IS
1796: Cursor C_Team_Role_Start IS
1797:
1798: select min(pap.start_date) team_role_start
1799: from pa_project_assignments pap, pa_project_statuses stat
1800: where
1801: pap.resource_list_member_id = p_resource_list_member_id
1802: and pap.project_id = p_project_id
1803: and

Line 1826: from pa_project_assignments pap, pa_project_statuses stat

1822: FUNCTION Get_Team_Role_End(p_project_id IN NUMBER, p_resource_list_member_id IN NUMBER)
1823: RETURN DATE IS
1824: Cursor C_Team_Role_End IS
1825: select max(pap.End_date) team_role_End
1826: from pa_project_assignments pap, pa_project_statuses stat
1827: where
1828: pap.resource_list_member_id = p_resource_list_member_id
1829: and pap.project_id = p_project_id
1830: and