[Home] [Help]
PACKAGE: APPS.PA_MU_BATCHES_V_PKG
Source
1 package PA_MU_BATCHES_V_PKG as
2 -- $Header: PAXBAUPS.pls 120.2 2005/08/17 03:18:58 avaithia noship $
3
4 PROCEDURE Insert_Row( X_Rowid IN OUT NOCOPY VARCHAR2, -- 4537865
5 X_Batch_ID IN OUT NOCOPY NUMBER, -- 4537865
6 X_Org_Id IN NUMBER DEFAULT NULL, --R12 MOAC Changes:Bug 4363093
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_Batch_Name VARCHAR2,
13 X_Batch_status_Code VARCHAR2,
14 X_Description VARCHAR2,
15 X_Project_Attribute VARCHAR2,
16 X_Effective_Date DATE,
17 X_Attribute_Category VARCHAR2,
18 X_Attribute1 VARCHAR2,
19 X_Attribute2 VARCHAR2,
20 X_Attribute3 VARCHAR2,
21 X_Attribute4 VARCHAR2,
22 X_Attribute5 VARCHAR2,
23 X_Attribute6 VARCHAR2,
24 X_Attribute7 VARCHAR2,
25 X_Attribute8 VARCHAR2,
26 X_Attribute9 VARCHAR2,
27 X_Attribute10 VARCHAR2,
28 X_Attribute11 VARCHAR2,
29 X_Attribute12 VARCHAR2,
30 X_Attribute13 VARCHAR2,
31 X_Attribute14 VARCHAR2,
32 X_Attribute15 VARCHAR2 );
33
34
35 PROCEDURE Update_Row( X_Rowid VARCHAR2,
36 X_Last_Updated_By NUMBER,
37 X_Last_Update_Date DATE,
38 X_Last_Update_Login NUMBER,
39 X_Batch_Name VARCHAR2,
40 X_Batch_status_Code VARCHAR2,
41 X_Rejection_Code VARCHAR2,
42 X_Description VARCHAR2,
43 X_Project_Attribute VARCHAR2,
44 X_Effective_Date DATE,
45 X_Process_Run_By NUMBER,
46 X_Process_Run_Date DATE,
47 X_Attribute_Category VARCHAR2,
48 X_Attribute1 VARCHAR2,
49 X_Attribute2 VARCHAR2,
50 X_Attribute3 VARCHAR2,
51 X_Attribute4 VARCHAR2,
52 X_Attribute5 VARCHAR2,
53 X_Attribute6 VARCHAR2,
54 X_Attribute7 VARCHAR2,
55 X_Attribute8 VARCHAR2,
56 X_Attribute9 VARCHAR2,
57 X_Attribute10 VARCHAR2,
58 X_Attribute11 VARCHAR2,
59 X_Attribute12 VARCHAR2,
60 X_Attribute13 VARCHAR2,
61 X_Attribute14 VARCHAR2,
62 X_Attribute15 VARCHAR2 );
63
64
65 PROCEDURE Lock_Row( X_Rowid VARCHAR2,
66 X_Batch_Name VARCHAR2,
67 X_Batch_status_Code VARCHAR2,
68 X_Description VARCHAR2,
69 X_Project_Attribute VARCHAR2,
70 X_Process_Run_By NUMBER,
71 X_Process_Run_Date DATE,
72 X_Effective_Date DATE,
73 X_Rejection_Code VARCHAR2,
74 X_Attribute_Category VARCHAR2,
75 X_Attribute1 VARCHAR2,
76 X_Attribute2 VARCHAR2,
77 X_Attribute3 VARCHAR2,
78 X_Attribute4 VARCHAR2,
79 X_Attribute5 VARCHAR2,
80 X_Attribute6 VARCHAR2,
81 X_Attribute7 VARCHAR2,
82 X_Attribute8 VARCHAR2,
83 X_Attribute9 VARCHAR2,
84 X_Attribute10 VARCHAR2,
85 X_Attribute11 VARCHAR2,
86 X_Attribute12 VARCHAR2,
87 X_Attribute13 VARCHAR2,
88 X_Attribute14 VARCHAR2,
89 X_Attribute15 VARCHAR2 );
90
91
92 PROCEDURE Delete_Row( X_Rowid VARCHAR2 );
93
94
95 -- -----------------------------------------------------------------
96 -- Proc_Conc
97 -- Procedure to process mass update batches. This procedure
98 -- should be called from Reports
99 --
100 -- Parameters:
101 -- ERRBUF - Standard concurrent program parameter
102 -- RETCODE - Standard concurrent program parameter
103 -- X_Batch_ID - Specify the batch to process
104 -- X_Request_ID - return the concurrent request ID to the caller
105 --
106 -- Notes:
107 -- If the batch ID is not passed in, all the batches with
108 -- 'Submitted' status whose effective date is before sysdate
109 -- will be processed.
110 -- -----------------------------------------------------------------
111
112 PROCEDURE Proc_Conc( ERRBUF OUT NOCOPY VARCHAR2, -- 4537865
113 RETCODE OUT NOCOPY VARCHAR2, -- 4537865
114 X_Batch_ID IN NUMBER DEFAULT NULL,
115 X_Request_ID OUT NOCOPY NUMBER ); -- 4537865
116
117 -- -----------------------------------------------------------------
118 -- Process
119 -- Procedure to process one single batch specified by the
120 -- X_Batch_ID parameter. This procedure is called by the
121 -- Proc_Conc procedure and from the Mass Update Batches form.
122 -- -----------------------------------------------------------------
123
124 PROCEDURE Process( ERRBUF OUT NOCOPY VARCHAR2, -- 4537865
125 RETCODE OUT NOCOPY VARCHAR2, -- 4537865
126 X_Batch_ID IN NUMBER,
127 X_Concurrent IN VARCHAR2 DEFAULT 'Y',
128 X_All_Batches IN VARCHAR2 DEFAULT 'N' );
129
130 END PA_MU_BATCHES_V_PKG;