DBA Data[Home] [Help]

APPS.PA_OTC_API dependencies on PA_PROJECTS_ALL

Line 5: Project_Number Pa_Projects_All.Segment1%TYPE,

1: Package Pa_Otc_Api AS
2: --$Header: PAXVOTCS.pls 120.2 2005/12/01 08:53:40 eyefimov noship $
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.2 2005/12/01 08:53:40 eyefimov noship $
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 45: Project_Number Pa_Projects_All.Segment1%TYPE,

41: TYPE Timecard_Table IS Table OF Timecard_Rec
42: INDEX BY Binary_Integer;
43:
44: TYPE Project_Attribution_Rec IS Record (
45: Project_Number Pa_Projects_All.Segment1%TYPE,
46: Project_Id Pa_Projects_All.Project_Id%TYPE,
47: Proj_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
48: Proj_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
49: Task_Number Pa_Tasks.Task_Number%TYPE,

Line 46: Project_Id Pa_Projects_All.Project_Id%TYPE,

42: INDEX BY Binary_Integer;
43:
44: TYPE Project_Attribution_Rec IS Record (
45: Project_Number Pa_Projects_All.Segment1%TYPE,
46: Project_Id Pa_Projects_All.Project_Id%TYPE,
47: Proj_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
48: Proj_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
49: Task_Number Pa_Tasks.Task_Number%TYPE,
50: Task_Id Pa_Tasks.Task_Id%TYPE,

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

521: -- Oracle Projects, X_Project_Number will be populated
522: -- with segment1, else X_Project_Number will be null.
523: -- Parameters :
524: -- IN
525: -- P_Project_Id - Pa_Projects_All.Project_Id%TYPE
526: -- OUT
527: -- X_Error_Code - Varchar2
528: -- X_Error_Type - Varchar2
529: -- X_Project_Number - Pa_Projects_All.Segment1%TYPE

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

525: -- P_Project_Id - Pa_Projects_All.Project_Id%TYPE
526: -- OUT
527: -- X_Error_Code - Varchar2
528: -- X_Error_Type - Varchar2
529: -- X_Project_Number - Pa_Projects_All.Segment1%TYPE
530:
531: /*-------------------------------------------------------------------------*/
532:
533: PROCEDURE Validate_Project_Exists(

Line 534: P_Project_Id IN Pa_Projects_All.Project_Id%TYPE,

530:
531: /*-------------------------------------------------------------------------*/
532:
533: PROCEDURE Validate_Project_Exists(
534: P_Project_Id IN Pa_Projects_All.Project_Id%TYPE,
535: X_Error_Code OUT NOCOPY Varchar2,
536: X_Error_Type OUT NOCOPY Varchar2,
537: X_Project_Number OUT NOCOPY Pa_Projects_All.Segment1%TYPE);
538:

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

533: PROCEDURE Validate_Project_Exists(
534: P_Project_Id IN Pa_Projects_All.Project_Id%TYPE,
535: X_Error_Code OUT NOCOPY Varchar2,
536: X_Error_Type OUT NOCOPY Varchar2,
537: X_Project_Number OUT NOCOPY Pa_Projects_All.Segment1%TYPE);
538:
539:
540: -- =======================================================================
541: -- Start of Comments