DBA Data[Home] [Help]

PACKAGE: APPS.PA_PROJ_RETN_RULES_PKG

Source


1 PACKAGE PA_PROJ_RETN_RULES_PKG as
2 /* $Header: PAPJRETS.pls 120.1 2005/08/19 16:41:22 mwasowic noship $ */
3 
4   PROCEDURE Insert_Row (
5        X_Rowid                   	IN OUT	NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6        P_Project_ID				NUMBER,
7        P_Task_Number				VARCHAR2,
8        P_Task_Name				VARCHAR2,
9        P_Customer_ID				NUMBER,
10        P_Retention_Level_Code		IN OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
11        P_Expenditure_Category		IN OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
12        P_Expenditure_Type		IN OUT 	NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
13        P_Non_Labor_Resource		IN OUT 	NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
14        P_Revenue_Category     	 	IN OUT 	NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
15        P_Event_Type			IN OUT 	NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
16        P_Retention_Percentage			NUMBER,
17        P_Retention_Amount			NUMBER,
18        P_Threshold_Amount			NUMBER,
19        P_Effective_Start_Date			DATE,
20        P_Effective_End_Date			DATE,
21        P_Task_Flag				VARCHAR2,
22        X_Return_Status_Code		IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
23        X_Error_Message_Code		IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
24   );
25 
26   PROCEDURE Update_Row (
27        P_Rowid                   		VARCHAR2,
28        P_Project_ID				NUMBER,
29        P_Customer_ID				NUMBER,
30        P_Expenditure_Category		IN OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
31        P_Expenditure_Type		IN OUT 	NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
32        P_Non_Labor_Resource		IN OUT 	NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
33        P_Revenue_Category     	 	IN OUT 	NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
34        P_Event_Type			IN OUT 	NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
35        P_Retention_Percentage			NUMBER,
36        P_Retention_Amount			NUMBER,
37        P_Threshold_Amount			NUMBER,
38        P_Effective_Start_Date			DATE,
39        P_Effective_End_Date			DATE,
40        X_Return_Status_Code		IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
41        X_Error_Message_Code		IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
42   );
43 
44   PROCEDURE Delete_Row (
45        P_Rowid                   		VARCHAR2,
46        X_Return_Status_Code		IN OUT 	NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
47        X_Error_Message_Code		IN OUT 	NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
48   );
49 
50 END PA_PROJ_RETN_RULES_PKG;