APPS.PA_OTC_API dependencies on PA_PROJECTS

Line 5: Project_Number Pa_Projects_All.Segment1%TYPE,

1: Package Pa_Otc_Api AUTHID CURRENT_USER AS
2: --$Header: PAXVOTCS.pls 120.3.12020000.2 2013/03/31 08:05:07 arbandyo ship $
3:
4: TYPE Timecard_Rec IS Record (
5: Project_Number Pa_Projects_All.Segment1%TYPE,
6: Project_Id Pa_Projects_All.Project_Id%TYPE,
7: Task_Number Pa_Tasks.Task_Number%TYPE,
8: Task_Id Pa_Tasks.Task_Id%TYPE,
9: Expenditure_Type Pa_Expenditure_Types.Expenditure_Type%TYPE,

Line 6: Project_Id Pa_Projects_All.Project_Id%TYPE,

2: --$Header: PAXVOTCS.pls 120.3.12020000.2 2013/03/31 08:05:07 arbandyo ship $
3:
4: TYPE Timecard_Rec IS Record (
5: Project_Number Pa_Projects_All.Segment1%TYPE,
6: Project_Id Pa_Projects_All.Project_Id%TYPE,
7: Task_Number Pa_Tasks.Task_Number%TYPE,
8: Task_Id Pa_Tasks.Task_Id%TYPE,
9: Expenditure_Type Pa_Expenditure_Types.Expenditure_Type%TYPE,
10: System_Linkage_Function Pa_System_Linkages.Function%TYPE,

Line 52: Project_Number Pa_Projects_All.Segment1%TYPE,

48: TYPE Timecard_Table IS Table OF Timecard_Rec
49: INDEX BY Binary_Integer;
50:
51: TYPE Project_Attribution_Rec IS Record (
52: Project_Number Pa_Projects_All.Segment1%TYPE,
53: Project_Id Pa_Projects_All.Project_Id%TYPE,
54: Proj_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
55: Proj_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
56: Task_Number Pa_Tasks.Task_Number%TYPE,

Line 53: Project_Id Pa_Projects_All.Project_Id%TYPE,

49: INDEX BY Binary_Integer;
50:
51: TYPE Project_Attribution_Rec IS Record (
52: Project_Number Pa_Projects_All.Segment1%TYPE,
53: Project_Id Pa_Projects_All.Project_Id%TYPE,
54: Proj_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
55: Proj_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
56: Task_Number Pa_Tasks.Task_Number%TYPE,
57: Task_Id Pa_Tasks.Task_Id%TYPE,

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

538: -- Oracle Projects, X_Project_Number will be populated
539: -- with segment1, else X_Project_Number will be null.
540: -- Parameters :
541: -- IN
542: -- P_Project_Id - Pa_Projects_All.Project_Id%TYPE
543: -- OUT
544: -- X_Error_Code - Varchar2
545: -- X_Error_Type - Varchar2
546: -- X_Project_Number - Pa_Projects_All.Segment1%TYPE

Line 546: -- X_Project_Number - Pa_Projects_All.Segment1%TYPE

542: -- P_Project_Id - Pa_Projects_All.Project_Id%TYPE
543: -- OUT
544: -- X_Error_Code - Varchar2
545: -- X_Error_Type - Varchar2
546: -- X_Project_Number - Pa_Projects_All.Segment1%TYPE
547:
548: /*-------------------------------------------------------------------------*/
549:
550: PROCEDURE Validate_Project_Exists(

Line 551: P_Project_Id IN Pa_Projects_All.Project_Id%TYPE,

547:
548: /*-------------------------------------------------------------------------*/
549:
550: PROCEDURE Validate_Project_Exists(
551: P_Project_Id IN Pa_Projects_All.Project_Id%TYPE,
552: X_Error_Code OUT NOCOPY Varchar2,
553: X_Error_Type OUT NOCOPY Varchar2,
554: X_Project_Number OUT NOCOPY Pa_Projects_All.Segment1%TYPE);
555:

Line 554: X_Project_Number OUT NOCOPY Pa_Projects_All.Segment1%TYPE);

550: PROCEDURE Validate_Project_Exists(
551: P_Project_Id IN Pa_Projects_All.Project_Id%TYPE,
552: X_Error_Code OUT NOCOPY Varchar2,
553: X_Error_Type OUT NOCOPY Varchar2,
554: X_Project_Number OUT NOCOPY Pa_Projects_All.Segment1%TYPE);
555:
556:
557: -- =======================================================================
558: -- Start of Comments

Line 572: -- P_Project_Id - Pa_Projects.Project_Id%TYPE

568: -- with Task_Number, else X_Task_Number will be null.
569: -- Parameters :
570: -- IN
571: -- P_Task_Id - Pa_Tasks.Task_Id%TYPE
572: -- P_Project_Id - Pa_Projects.Project_Id%TYPE
573: -- OUT
574: -- X_Error_Code - Varchar2
575: -- X_Error_Type - Varchar2
576: -- X_Task_Number - Pa_Tasks.Task_Number%TYPE

Line 582: P_Project_Id IN Pa_Projects.Project_Id%TYPE,

578: /*-------------------------------------------------------------------------*/
579:
580: Procedure Validate_Task_Exists(
581: P_Task_Id IN Pa_Tasks.Task_Id%TYPE,
582: P_Project_Id IN Pa_Projects.Project_Id%TYPE,
583: X_Error_Code OUT NOCOPY Varchar2,
584: X_Error_Type OUT NOCOPY Varchar2,
585: X_Task_Number OUT NOCOPY Pa_Tasks.Task_Number%TYPE);
586: