PACKAGE: APPS.PA_MU_DETAILS_V_PKG

Source

1 package PA_MU_DETAILS_V_PKG as
2 -- $Header: PAXBAULS.pls 120.1 2005/08/19 17:08:40 mwasowic noship $
3 
4   PROCEDURE Insert_Row(	X_Rowid                 IN OUT	NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
5 			X_Line_ID		IN OUT	NOCOPY NUMBER, --File.Sql.39 bug 4440895
6 			X_Batch_ID		 	NUMBER,
7 			X_Creation_Date			DATE,
8 			X_Created_By			NUMBER,
9 			X_Last_Updated_By		NUMBER,
10 			X_Last_Update_Date		DATE,
11 			X_Last_Update_Login		NUMBER,
12 			X_Project_ID			NUMBER,
13 			X_Task_ID			NUMBER,
14 			X_Old_Attribute_Value		VARCHAR2,
15 			X_New_Attribute_Value		VARCHAR2,
16 			X_Update_Flag			VARCHAR2,
17 			X_Recalculate_Flag		VARCHAR2 );
18 
19 
20   PROCEDURE Update_Row(	X_Rowid                         VARCHAR2,
21 			X_Last_Updated_By		NUMBER,
22 			X_Last_Update_Date		DATE,
23 			X_Last_Update_Login		NUMBER,
24 			X_Project_ID			NUMBER,
25 			X_Task_ID			NUMBER,
26 			X_Old_Attribute_Value		VARCHAR2,
27 			X_New_Attribute_Value		VARCHAR2,
28 			X_Update_Flag			VARCHAR2,
29 			X_Recalculate_Flag		VARCHAR2,
30 			X_Rejection_Reason		VARCHAR2 );
31 
32 
33   PROCEDURE Lock_Row(	X_Rowid                         VARCHAR2,
34 			X_Project_ID			NUMBER,
35 			X_Task_ID			NUMBER,
36 			X_Old_Attribute_Value		VARCHAR2,
37 			X_New_Attribute_Value		VARCHAR2,
38 			X_Update_Flag			VARCHAR2,
39 			X_Recalculate_Flag		VARCHAR2,
40 			X_Rejection_Reason		VARCHAR2 );
41 
42 
43   PROCEDURE Delete_Row(	X_Rowid VARCHAR2 );
44 
45   PROCEDURE Generate_Lines(
46 			X_Batch_ID			NUMBER,
47 			X_Project_Selection		VARCHAR2,
48 			X_Search_Project_ID		NUMBER    Default NULL,
49 			X_Search_Organization_ID	NUMBER    Default NULL,
50 			X_Task_Selection		VARCHAR2,
51 			X_New_Organization_ID		NUMBER    Default NULL,
52 			X_Recalculate_Flag		VARCHAR2  Default 'Y',
53 			X_Err_Code		 IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
54 			X_Err_Stage		 IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
55 			X_Err_Stack		 IN OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
56 
57 END PA_MU_DETAILS_V_PKG;