[Home] [Help]
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,
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,
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,
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,
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
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(
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:
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
551: -- with Task_Number, else X_Task_Number will be null.
552: -- Parameters :
553: -- IN
554: -- P_Task_Id - Pa_Tasks.Task_Id%TYPE
555: -- P_Project_Id - Pa_Projects.Project_Id%TYPE
556: -- OUT
557: -- X_Error_Code - Varchar2
558: -- X_Error_Type - Varchar2
559: -- X_Task_Number - Pa_Tasks.Task_Number%TYPE
561: /*-------------------------------------------------------------------------*/
562:
563: Procedure Validate_Task_Exists(
564: P_Task_Id IN Pa_Tasks.Task_Id%TYPE,
565: P_Project_Id IN Pa_Projects.Project_Id%TYPE,
566: X_Error_Code OUT NOCOPY Varchar2,
567: X_Error_Type OUT NOCOPY Varchar2,
568: X_Task_Number OUT NOCOPY Pa_Tasks.Task_Number%TYPE);
569: