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_PROJECTS_MAINT_PVT dependencies on PA_PROJECT_TYPES

Line 168: from pa_project_types pt

164:
165: CURSOR l_get_prj_class_code
166: IS
167: select meaning
168: from pa_project_types pt
169: , pa_lookups lps
170: , pa_projects pp
171: where pt.project_type = pp.project_type
172: and lps.lookup_type(+) = 'PROJECT TYPE CLASS'

Line 613: From pa_projects_all pa, pa_project_types_all pt

609:
610: CURSOR l_project_csr (c_project_id NUMBER) -- Bug 6166197: cursor modified to fetch project_type_class_code also
611: Is
612: Select project_currency_code, project_type_class_code
613: From pa_projects_all pa, pa_project_types_all pt
614: Where pa.project_id = c_project_id
615: And pa.project_type = pt.project_type
616: And nvl(pa.org_id,-99) = nvl(pt.org_id,-99);
617:

Line 671: l_proj_type_class_code pa_project_types_all.project_type_class_code%TYPE; -- Bug 6166197

667: l_ship_to_customer_id Number;
668:
669: --customer Account Relationship changes
670:
671: l_proj_type_class_code pa_project_types_all.project_type_class_code%TYPE; -- Bug 6166197
672:
673: -- anlee org role changes
674: l_project_party_id NUMBER;
675: l_resource_id NUMBER;

Line 1194: FROM pa_projects_all ppa, pa_project_types ppt

1190: -- Bug 2904327
1191: CURSOR l_get_project_type_id
1192: IS
1193: SELECT ppt.project_type_id
1194: FROM pa_projects_all ppa, pa_project_types ppt
1195: WHERE ppa.project_id = p_project_id
1196: AND ppa.project_type = ppt.project_type;
1197:
1198: l_old_project_type_id NUMBER;

Line 3440: FROM PA_PROJECT_TYPES_ALL ppta,

3436:
3437: if p_object_type = 'PA_PROJECTS' then
3438: SELECT ppta.project_type_id
3439: INTO l_object_type_id
3440: FROM PA_PROJECT_TYPES_ALL ppta,
3441: PA_PROJECTS_ALL ppa
3442: WHERE ppa.project_id = p_object_id
3443: AND ppa.project_type = ppta.project_type
3444: -- AND NVL(ppa.org_id, -99) = NVL(ppta.org_id, -99); MOAC Changes: Bug 4363092 - removed nvl

Line 3559: FROM PA_PROJECT_TYPES_ALL ppta,

3555:
3556: if p_object_type = 'PA_PROJECTS' then
3557: SELECT ppta.project_type_id
3558: INTO l_object_type_id
3559: FROM PA_PROJECT_TYPES_ALL ppta,
3560: PA_PROJECTS_ALL ppa
3561: WHERE ppa.project_id = p_object_id
3562: AND ppa.project_type = ppta.project_type
3563: -- AND NVL(ppa.org_id, -99) = NVL(ppta.org_id, -99); MOAC Changes: Bug 4363092 - removed nvl

Line 4179: from pa_project_types_all -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all

4175: -- MOAC Changes: Bug 4363092 - removed nvl used with org_id
4176: cursor get_project_type_info (c_project_type VARCHAR2)
4177: IS
4178: select *
4179: from pa_project_types_all -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all
4180: where project_type = c_project_type
4181: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID; -- Added the and condition for Bug#3807805
4182: -- anlee end of changes
4183:

Line 4188: from pa_project_types_all -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all

4184: -- MOAC Changes: Bug 4363092 - removed nvl used with org_id
4185: cursor get_unassigned_time (c_project_type VARCHAR2)
4186: IS
4187: Select unassigned_time
4188: from pa_project_types_all -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all
4189: where project_type = c_project_type
4190: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID; -- Added the and condition for Bug#3807805
4191:
4192: l_unassigned_time pa_project_types.unassigned_time%TYPE;

Line 4192: l_unassigned_time pa_project_types.unassigned_time%TYPE;

4188: from pa_project_types_all -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all
4189: where project_type = c_project_type
4190: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID; -- Added the and condition for Bug#3807805
4191:
4192: l_unassigned_time pa_project_types.unassigned_time%TYPE;
4193: l_project_old_rec pa_projects_all%ROWTYPE; -- Bug#3807805 : Modifed pa_projects to pa_projects_all
4194: l_project_type_rec get_project_type_info%ROWTYPE;
4195: l_probability_member_id number;
4196:

Line 4203: from pa_project_types_all -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all

4199: -- MOAC Changes: Bug 4363092 - removed nvl used with org_id
4200: cursor get_project_type_class_code (c_project_type VARCHAR2)
4201: IS
4202: Select project_type_class_code
4203: from pa_project_types_all -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all
4204: where project_type = c_project_type
4205: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID; -- Added the and condition for Bug#3807805
4206:
4207: cursor get_billable_cap_flag (c_work_type_id NUMBER)

Line 4240: l_old_project_type_class_code pa_project_types.project_type_class_code%TYPE;

4236: l_start_date_error BOOLEAN := FALSE;
4237: l_completion_date_error BOOLEAN := FALSE;
4238: l_distribution_rule pa_project_type_distributions.distribution_rule%TYPE;
4239: l_billable_capitalizable_flag pa_work_types_vl.billable_capitalizable_flag%TYPE;
4240: l_old_project_type_class_code pa_project_types.project_type_class_code%TYPE;
4241: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
4242: l_project_type_error BOOLEAN := FALSE;
4243: -- anlee end of changes
4244:

Line 4241: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;

4237: l_completion_date_error BOOLEAN := FALSE;
4238: l_distribution_rule pa_project_type_distributions.distribution_rule%TYPE;
4239: l_billable_capitalizable_flag pa_work_types_vl.billable_capitalizable_flag%TYPE;
4240: l_old_project_type_class_code pa_project_types.project_type_class_code%TYPE;
4241: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
4242: l_project_type_error BOOLEAN := FALSE;
4243: -- anlee end of changes
4244:
4245: -- anlee project actions changes

Line 4965: from pa_project_types_all pt -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all

4961:
4962: -- MOAC Changes: Bug 4363092 - removed nvl used with org_id
4963: select meaning
4964: into t_project_type_class_code
4965: from pa_project_types_all pt -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all
4966: , pa_lookups lps
4967: where pt.project_type = p_project_type
4968: and lps.lookup_type(+) = 'PROJECT TYPE CLASS'
4969: and lps.lookup_code(+) = pt.project_type_class_code