[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;