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_PROJECT_PARTIES_UTILS dependencies on PA_PROJECT_ROLE_TYPES

Line 86: pa_project_role_types_b r1,

82:
83: CURSOR c_duplicate_customer_org IS
84: SELECT 'Y'
85: FROM pa_project_parties ppp,
86: pa_project_role_types_b r1,
87: pa_project_role_types_b r2
88: WHERE r1.project_role_id = p_project_role_id
89: AND r1.role_party_class = 'CUSTOMER'
90: AND ppp.object_id = p_object_id

Line 87: pa_project_role_types_b r2

83: CURSOR c_duplicate_customer_org IS
84: SELECT 'Y'
85: FROM pa_project_parties ppp,
86: pa_project_role_types_b r1,
87: pa_project_role_types_b r2
88: WHERE r1.project_role_id = p_project_role_id
89: AND r1.role_party_class = 'CUSTOMER'
90: AND ppp.object_id = p_object_id
91: AND ppp.object_type = p_object_type

Line 179: FROM pa_project_role_types_b

175: l_dummy := 'N';
176: BEGIN
177: SELECT 'Y'
178: INTO l_dummy
179: FROM pa_project_role_types_b
180: WHERE project_role_id = p_project_role_id
181: AND p_start_date_active BETWEEN start_date_active AND NVL(end_date_active,p_start_date_active)
182: AND (p_end_date_active IS NULL
183: OR p_end_date_active BETWEEN start_date_active AND NVL(end_date_active,p_end_date_active));

Line 596: FROM pa_project_role_types_vl

592: BEGIN
593: IF p_project_role_type IS NOT NULL THEN
594: BEGIN
595: SELECT project_role_id INTO l_project_role_id
596: FROM pa_project_role_types_vl
597: WHERE (meaning = p_project_role_type AND p_calling_module <> 'FORM')
598: OR (project_role_type = p_project_role_type AND p_calling_module = 'FORM');
599: RETURN l_project_role_id;
600: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 706: pa_project_role_types pprt,

702: x_project_role_id,
703: x_project_role_name,
704: x_manager_name
705: FROM pa_project_parties ppp,
706: pa_project_role_types pprt,
707: per_all_people_f pe
708: WHERE ppp.project_id = p_project_id
709: AND ppp.project_role_id = 1
710: AND ppp.project_role_id = pprt.project_role_id

Line 730: pa_project_role_types pprt,

726: x_project_role_id,
727: x_project_role_name,
728: x_manager_name
729: FROM pa_project_parties ppp,
730: pa_project_role_types pprt,
731: per_all_people_f pe
732: WHERE ppp.project_id = p_project_id
733: AND ppp.project_role_id = 1
734: AND ppp.project_role_id = pprt.project_role_id

Line 771: pa_project_role_types_b r,

767: BEGIN
768: SELECT project_party_id
769: INTO ret
770: FROM pa_project_parties p,
771: pa_project_role_types_b r,
772: pa_customers_v c
773: WHERE r.role_party_class = 'CUSTOMER'
774: AND p.project_role_id = r.project_role_id
775: AND p.project_id = p_project_id

Line 793: l_role_party_class pa_project_role_types_b.role_party_class%TYPE;

789: p_resource_source_id IN NUMBER,
790: x_error_occured OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
791:
792: l_party_type VARCHAR2(30) := 'PERSON';
793: l_role_party_class pa_project_role_types_b.role_party_class%TYPE;
794: BEGIN
795: pa_debug.set_err_stack('Validate_role_party');
796:
797: -- Check if the resource is a Person/Organization.

Line 808: FROM pa_project_role_types_b

804:
805: -- Check if the role is for Person/Organization.
806: SELECT role_party_class
807: INTO l_role_party_class
808: FROM pa_project_role_types_b
809: WHERE project_role_id = p_project_role_id;
810:
811: x_error_occured := 'N';
812:

Line 837: --PA_PROJECT_ROLE_TYPES PPRT --bug 4004821

833:
834: CURSOR C1 (c_as_of_date DATE) IS
835: Select PPP.RESOURCE_SOURCE_ID
836: FROM PA_PROJECT_PARTIES PPP ,
837: --PA_PROJECT_ROLE_TYPES PPRT --bug 4004821
838: PA_PROJECT_ROLE_TYPES_B PPRT
839: WHERE
840: PPP.PROJECT_ID = p_project_id
841: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID

Line 838: PA_PROJECT_ROLE_TYPES_B PPRT

834: CURSOR C1 (c_as_of_date DATE) IS
835: Select PPP.RESOURCE_SOURCE_ID
836: FROM PA_PROJECT_PARTIES PPP ,
837: --PA_PROJECT_ROLE_TYPES PPRT --bug 4004821
838: PA_PROJECT_ROLE_TYPES_B PPRT
839: WHERE
840: PPP.PROJECT_ID = p_project_id
841: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID
842: AND ppp.resource_type_id = 101 --Added this condition to improve performance. Bug:4752054

Line 916: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821

912:
913: CURSOR C1 (c_as_of_date DATE) IS
914: Select ppf.full_name
915: FROM PA_PROJECT_PARTIES PPP,
916: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821
917: PA_PROJECT_ROLE_TYPES_B PPRT,
918: per_all_people_f PPF
919: WHERE
920: PPP.PROJECT_ID = p_project_id

Line 917: PA_PROJECT_ROLE_TYPES_B PPRT,

913: CURSOR C1 (c_as_of_date DATE) IS
914: Select ppf.full_name
915: FROM PA_PROJECT_PARTIES PPP,
916: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821
917: PA_PROJECT_ROLE_TYPES_B PPRT,
918: per_all_people_f PPF
919: WHERE
920: PPP.PROJECT_ID = p_project_id
921: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID

Line 1283: --PA_PROJECT_ROLE_TYPES PPRT --bug 4004821

1279:
1280: CURSOR C1 (c_as_of_date DATE) IS
1281: Select PPP.RESOURCE_SOURCE_ID
1282: FROM PA_PROJECT_PARTIES PPP ,
1283: --PA_PROJECT_ROLE_TYPES PPRT --bug 4004821
1284: PA_PROJECT_ROLE_TYPES_B PPRT
1285: WHERE
1286: PPP.PROJECT_ID = p_project_id
1287: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID

Line 1284: PA_PROJECT_ROLE_TYPES_B PPRT

1280: CURSOR C1 (c_as_of_date DATE) IS
1281: Select PPP.RESOURCE_SOURCE_ID
1282: FROM PA_PROJECT_PARTIES PPP ,
1283: --PA_PROJECT_ROLE_TYPES PPRT --bug 4004821
1284: PA_PROJECT_ROLE_TYPES_B PPRT
1285: WHERE
1286: PPP.PROJECT_ID = p_project_id
1287: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID
1288: AND ppp.resource_type_id = 101 --Added this condition to improve performance. Bug:4752054

Line 1328: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821

1324:
1325: CURSOR C1 (c_as_of_date DATE) IS
1326: Select ppf.full_name
1327: FROM PA_PROJECT_PARTIES PPP,
1328: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821
1329: PA_PROJECT_ROLE_TYPES_B PPRT,
1330: per_all_people_f PPF
1331: WHERE
1332: PPP.PROJECT_ID = p_project_id

Line 1329: PA_PROJECT_ROLE_TYPES_B PPRT,

1325: CURSOR C1 (c_as_of_date DATE) IS
1326: Select ppf.full_name
1327: FROM PA_PROJECT_PARTIES PPP,
1328: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821
1329: PA_PROJECT_ROLE_TYPES_B PPRT,
1330: per_all_people_f PPF
1331: WHERE
1332: PPP.PROJECT_ID = p_project_id
1333: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID