APPS.PA_UTILS3 dependencies on PA_PROJECTS_ALL

Line 84: Pa_Projects_All

80: Segment1
81: Into
82: X_Project_Number
83: From
84: Pa_Projects_All
85: Where
86: Project_Id = P_Project_Id;
87:
88: -- Add the project number to the pl/sql table using the project_id

Line 391: Function GetCachedProjNum (P_Project_Id IN NUMBER) RETURN pa_projects_all.segment1%TYPE

387: Raise;
388:
389: End GetCachedOrgId;
390:
391: Function GetCachedProjNum (P_Project_Id IN NUMBER) RETURN pa_projects_all.segment1%TYPE
392: Is
393: l_Project_Number pa_projects_all.segment1%TYPE;
394: Begin
395:

Line 393: l_Project_Number pa_projects_all.segment1%TYPE;

389: End GetCachedOrgId;
390:
391: Function GetCachedProjNum (P_Project_Id IN NUMBER) RETURN pa_projects_all.segment1%TYPE
392: Is
393: l_Project_Number pa_projects_all.segment1%TYPE;
394: Begin
395:
396: If P_Project_Id > 0 THEN
397: GetCachedProjNum(P_Project_Id => P_Project_Id,

Line 456: ,pa_projects_all proj

452: BEGIN
453: SELECT proj.segment1||'/'||TASK.task_number
454: INTO l_proj_task_info
455: FROM pa_expenditure_items ei
456: ,pa_projects_all proj
457: ,pa_tasks task
458: WHERE ei.expenditure_item_id = P_Transferred_from_exp_id
459: AND ei.task_id = task.task_id
460: AND proj.project_id = task.project_id;

Line 471: ,pa_projects_all proj

467: BEGIN
468: SELECT proj.segment1||'/'||TASK.task_number
469: INTO l_proj_task_info
470: FROM pa_expenditure_items ei
471: ,pa_projects_all proj
472: ,pa_tasks task
473: WHERE ei.transferred_from_exp_item_id = P_exp_item_id
474: AND ei.task_id = task.task_id
475: AND proj.project_id = task.project_id;

Line 503: (p_project_id IN pa_projects_all.project_id%TYPE,

499: ****************************************************************************/
500:
501:
502: PROCEDURE get_asset_addition_flag
503: (p_project_id IN pa_projects_all.project_id%TYPE,
504: x_asset_addition_flag OUT NOCOPY ap_invoice_distributions_all.assets_addition_flag%TYPE)
505: IS
506:
507: l_project_type_class_code pa_project_types_all.project_type_class_code%TYPE;

Line 515: pa_projects_all proj

511: /* For Given Project Id, Get the Project_Type_Class_Code depending on the Project_Type */
512: SELECT ptype.project_type_class_code
513: INTO l_project_type_class_code
514: FROM pa_project_types_all ptype,
515: pa_projects_all proj
516: WHERE ptype.project_type = proj.project_type
517: AND NVL(ptype.org_id, -99) = NVL(proj.org_id, -99)
518: AND proj.project_id = p_project_id;
519:

Line 549: (p_project_id IN pa_projects_all.project_id%TYPE)RETURN VARCHAR2 IS

545: Returns 'P' if the project is Capital otherwise 'U'
546: ****************************************************************************/
547:
548: FUNCTION Get_Project_Type
549: (p_project_id IN pa_projects_all.project_id%TYPE)RETURN VARCHAR2 IS
550: l_project_type VARCHAR2(1);
551:
552: BEGIN
553:

Line 559: pa_projects_all proj

555:
556: SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
557: INTO l_project_type
558: FROM pa_project_types_all ptype,
559: pa_projects_all proj
560: WHERE proj.project_type = ptype.project_type
561: /* AND NVL(ptype.org_id, -99) = NVL(proj.org_id, -99) commented and removed nvl to make use of the index also in R12, org is populated --Bug 5912873*/
562: AND ptype.org_id = proj.org_id
563: AND proj.project_id = p_project_id ;