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_OTC_API dependencies on PA_PROJECTS_ALL

Line 1583: l_Proj_Id Pa_Projects_All.Project_Id%TYPE;

1579:
1580: l_Exp_End_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE;
1581: l_Inc_By_Org_Id Hr_Organization_Units.Organization_Id%TYPE;
1582: l_Exp_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE;
1583: l_Proj_Id Pa_Projects_All.Project_Id%TYPE;
1584: l_Task_Id Pa_Tasks.Task_Id%TYPE;
1585: l_Exp_Type Pa_Expenditure_Types.Expenditure_Type%TYPE;
1586: l_Sys_Link Pa_Expenditure_Items_All.System_Linkage_Function%TYPE;
1587: l_Quantity Pa_Expenditure_Items_All.Quantity%TYPE;

Line 4978: pa_projects_all ppa

4974: into l_closed_proj_flag from dual
4975: where exists (select 1
4976: From
4977: Pa_Expenditure_Items_All ei,
4978: pa_projects_all ppa
4979: Where
4980: ei.project_id <> l_Proj_Attrib_Rec.PROJECT_ID and
4981: ei.project_id = ppa.project_id and
4982: nvl(ei.net_zero_adjustment_flag, 'N') <> 'Y' and

Line 6059: -- P_Project_Id - Pa_Projects_All.Project_Id%TYPE

6055: -- exists in Oracle Projects, X_project_Number will be populated
6056: -- with segment1, else X_project_number will be null.
6057: -- Parameters :
6058: -- IN
6059: -- P_Project_Id - Pa_Projects_All.Project_Id%TYPE
6060: -- OUT
6061: -- X_Error_Code - Varchar2
6062: -- X_Error_Type - Varchar2
6063: -- X_Project_Id - Pa_Projects_All.Segment1%TYPE

Line 6063: -- X_Project_Id - Pa_Projects_All.Segment1%TYPE

6059: -- P_Project_Id - Pa_Projects_All.Project_Id%TYPE
6060: -- OUT
6061: -- X_Error_Code - Varchar2
6062: -- X_Error_Type - Varchar2
6063: -- X_Project_Id - Pa_Projects_All.Segment1%TYPE
6064:
6065: /*-------------------------------------------------------------------------*/
6066:
6067: Procedure Validate_Project_Exists(

Line 6068: P_Project_Id IN Pa_Projects_All.Project_Id%TYPE,

6064:
6065: /*-------------------------------------------------------------------------*/
6066:
6067: Procedure Validate_Project_Exists(
6068: P_Project_Id IN Pa_Projects_All.Project_Id%TYPE,
6069: X_Error_Code OUT NOCOPY Varchar2,
6070: X_Error_Type OUT NOCOPY Varchar2,
6071: X_Project_Number OUT NOCOPY Pa_Projects_All.Segment1%TYPE)
6072: Is

Line 6071: X_Project_Number OUT NOCOPY Pa_Projects_All.Segment1%TYPE)

6067: Procedure Validate_Project_Exists(
6068: P_Project_Id IN Pa_Projects_All.Project_Id%TYPE,
6069: X_Error_Code OUT NOCOPY Varchar2,
6070: X_Error_Type OUT NOCOPY Varchar2,
6071: X_Project_Number OUT NOCOPY Pa_Projects_All.Segment1%TYPE)
6072: Is
6073:
6074: /* begin bug 4766396
6075: Cursor GetProjInfo(P_Proj_Id IN Pa_Projects_All.Project_Id%TYPE) Is

Line 6075: Cursor GetProjInfo(P_Proj_Id IN Pa_Projects_All.Project_Id%TYPE) Is

6071: X_Project_Number OUT NOCOPY Pa_Projects_All.Segment1%TYPE)
6072: Is
6073:
6074: /* begin bug 4766396
6075: Cursor GetProjInfo(P_Proj_Id IN Pa_Projects_All.Project_Id%TYPE) Is
6076: Select
6077: Project_Number
6078: From
6079: Pa_Online_Projects_V

Line 6083: Cursor GetProjInfo(P_Proj_Id IN Pa_Projects_All.Project_Id%TYPE) IS

6079: Pa_Online_Projects_V
6080: Where
6081: Project_Id = P_Proj_Id; */
6082:
6083: Cursor GetProjInfo(P_Proj_Id IN Pa_Projects_All.Project_Id%TYPE) IS
6084: select
6085: p.segment1
6086: from Pa_Online_Projects_V pp,
6087: pa_projects_all p

Line 6087: pa_projects_all p

6083: Cursor GetProjInfo(P_Proj_Id IN Pa_Projects_All.Project_Id%TYPE) IS
6084: select
6085: p.segment1
6086: from Pa_Online_Projects_V pp,
6087: pa_projects_all p
6088: where pp.Project_Id = P_Proj_Id
6089: and pp.project_id = p.project_id;
6090: /* end bug 4766396 */
6091:

Line 6092: l_Proj_Num Pa_Projects_All.Segment1%TYPE := Null;

6088: where pp.Project_Id = P_Proj_Id
6089: and pp.project_id = p.project_id;
6090: /* end bug 4766396 */
6091:
6092: l_Proj_Num Pa_Projects_All.Segment1%TYPE := Null;
6093:
6094: Begin
6095:
6096: G_Stage := 'Entering procedure Validate_Project_Exists().';

Line 6447: -- P_Work_Type_Id - Pa_Projects_All.work_Type_Id%TYPE

6443: -- extensive project related validations. If the work type
6444: -- exists in Oracle Projects, X_Error_Code will be null.
6445: -- Parameters :
6446: -- IN
6447: -- P_Work_Type_Id - Pa_Projects_All.work_Type_Id%TYPE
6448: -- OUT
6449: -- X_Error_Code - Varchar2
6450: -- X_Error_Type - Varchar2
6451:

Line 6734: l_Proj_Id Pa_Projects_All.Project_Id%TYPE;

6730:
6731: l_Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE; -- Added for CBS Enhancement Bug 16220146
6732:
6733: /*Start -changes for bug:7604482 */
6734: l_Proj_Id Pa_Projects_All.Project_Id%TYPE;
6735: l_Task_Id Pa_Tasks.Task_Id%TYPE;
6736: l_Exp_Type Pa_Expenditure_Types.Expenditure_Type%TYPE;
6737: /*End -changes for bug:7604482 */
6738:

Line 8260: Pa_Projects_All P,

8256: FI.Expenditure_Type_Class,
8257: FI.Item_Quantity
8258: From
8259: Pa_Forecast_Items FI,
8260: Pa_Projects_All P,
8261: Pa_Project_Assignments PPA
8262: Where
8263: Person_Id = P_Emp_Id
8264: And Item_Date Between P_Start_Date

Line 8290: Pa_Projects_All P

8286: FI.Expenditure_Type_Class,
8287: FI.Item_Quantity
8288: From
8289: Pa_Forecast_Items FI,
8290: Pa_Projects_All P
8291: Where
8292: Person_Id = P_Emp_Id
8293: And Item_Date Between P_Start_Date
8294: And P_Stop_Date

Line 8318: Pa_Projects_All P,

8314: FI.Expenditure_Type_Class,
8315: FI.Item_Quantity
8316: From
8317: Pa_Forecast_Items FI,
8318: Pa_Projects_All P,
8319: Pa_Resource_Txn_Attributes PTA
8320: Where
8321: PTA.Person_Id = P_Emp_Id
8322: And FI.Resource_id = PTA.Resource_id

Line 8351: -- Cursor ValidateProject ( P_Project_Id IN Pa_Projects_All.Project_Id%TYPE ) Is

8347: -- And nvl(Sys_Link_End_Date_Active, P_Exp_Item_Date);
8348:
8349: PRMAssignRecs PRMAssignments%ROWTYPE;
8350:
8351: -- Cursor ValidateProject ( P_Project_Id IN Pa_Projects_All.Project_Id%TYPE ) Is
8352: -- Select
8353: -- 'Y'
8354: -- From
8355: -- Pa_Online_Projects_V