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 392: Function GetCachedProjNum (P_Project_Id IN NUMBER) RETURN pa_projects_all.segment1%TYPE

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

Line 394: l_Project_Number pa_projects_all.segment1%TYPE;

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

Line 458: ,pa_projects_all proj

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

Line 473: ,pa_projects_all proj

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

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

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

Line 517: pa_projects_all proj

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

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

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

Line 561: pa_projects_all proj

557:
558: SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
559: INTO l_project_type
560: FROM pa_project_types_all ptype,
561: pa_projects_all proj
562: WHERE proj.project_type = ptype.project_type
563: /* 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*/
564: AND ptype.org_id = proj.org_id
565: AND proj.project_id = p_project_id ;