[Home] [Help]
PACKAGE: APPS.PA_BUDGET_LINES_V_PKG
Source
1 PACKAGE PA_BUDGET_LINES_V_PKG AUTHID CURRENT_USER as
2 -- $Header: PAXBUBLS.pls 120.2 2005/09/23 12:17:50 rnamburi noship $
3
4 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
5 X_Resource_Assignment_Id IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
6 X_Budget_Version_Id NUMBER,
7 X_Project_Id NUMBER,
8 X_Task_Id NUMBER,
9 X_Resource_List_Member_Id NUMBER,
10 X_Description VARCHAR2,
11 X_Start_Date DATE,
12 X_End_Date DATE,
13 X_Period_Name VARCHAR2,
14 X_Quantity IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
15 X_Unit_Of_Measure VARCHAR2,
16 X_Track_As_Labor_Flag VARCHAR2,
17 X_Raw_Cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
18 X_Burdened_Cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
19 X_Revenue IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
20 X_Change_Reason_Code VARCHAR2,
21 X_Last_Update_Date DATE,
22 X_Last_Updated_By NUMBER,
23 X_Creation_Date DATE,
24 X_Created_By NUMBER,
25 X_Last_Update_Login NUMBER,
26 X_Attribute_Category VARCHAR2,
27 X_Attribute1 VARCHAR2,
28 X_Attribute2 VARCHAR2,
29 X_Attribute3 VARCHAR2,
30 X_Attribute4 VARCHAR2,
31 X_Attribute5 VARCHAR2,
32 X_Attribute6 VARCHAR2,
33 X_Attribute7 VARCHAR2,
34 X_Attribute8 VARCHAR2,
35 X_Attribute9 VARCHAR2,
36 X_Attribute10 VARCHAR2,
37 X_Attribute11 VARCHAR2,
38 X_Attribute12 VARCHAR2,
39 X_Attribute13 VARCHAR2,
40 X_Attribute14 VARCHAR2,
41 X_Attribute15 VARCHAR2,
42 -- Bug Fix: 4569365. Removed MRC code.
43 -- X_mrc_flag VARCHAR2, /* FPB2: MRC */
44 X_Calling_Process VARCHAR2 DEFAULT 'PR',
45 X_Pm_Product_Code VARCHAR2 DEFAULT NULL,
46 X_Pm_Budget_Line_Reference VARCHAR2 DEFAULT NULL,
47 X_raw_cost_source VARCHAR2 DEFAULT 'M',
48 X_burdened_cost_source VARCHAR2 DEFAULT 'M',
49 X_quantity_source VARCHAR2 DEFAULT 'M',
50 X_revenue_source VARCHAR2 DEFAULT 'M',
51 /*Added following 13 columns on 16-mar-2001*/
52 x_standard_bill_rate NUMBER DEFAULT NULL,
53 x_average_bill_rate NUMBER DEFAULT NULL,
54 x_average_cost_rate NUMBER DEFAULT NULL,
55 x_project_assignment_id NUMBER DEFAULT -1,
56 x_plan_error_code VARCHAR2 DEFAULT NULL,
57 x_total_plan_revenue NUMBER DEFAULT NULL,
58 x_total_plan_raw_cost NUMBER DEFAULT NULL,
59 x_total_plan_burdened_cost NUMBER DEFAULT NULL,
60 x_total_plan_quantity NUMBER DEFAULT NULL,
61 x_average_discount_percentage NUMBER DEFAULT NULL,
62 x_cost_rejection_code VARCHAR2 DEFAULT NULL,
63 x_burden_rejection_code VARCHAR2 DEFAULT NULL,
64 x_revenue_rejection_code VARCHAR2 DEFAULT NULL,
65 x_other_rejection_code VARCHAR2 DEFAULT NULL,
66 X_Code_Combination_Id NUMBER DEFAULT NULL,
67 X_CCID_Gen_Status_Code VARCHAR2 DEFAULT NULL,
68 X_CCID_Gen_Rej_Message VARCHAR2 DEFAULT NULL
69 );
70
71
72 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
73 X_Resource_Assignment_Id NUMBER,
74 X_Budget_Version_Id NUMBER,
75 X_Project_Id NUMBER,
76 X_Task_Id NUMBER,
77 X_Resource_List_Member_Id NUMBER,
78 X_Description VARCHAR2,
79 X_Start_Date DATE,
80 X_End_Date DATE,
81 X_Period_Name VARCHAR2,
82 X_Quantity NUMBER,
83 X_Unit_Of_Measure VARCHAR2,
84 X_Track_As_Labor_Flag VARCHAR2,
85 X_Raw_Cost NUMBER,
86 X_Burdened_Cost NUMBER,
87 X_Revenue NUMBER,
88 X_Change_Reason_Code VARCHAR2,
89 X_Attribute_Category VARCHAR2,
90 X_Attribute1 VARCHAR2,
91 X_Attribute2 VARCHAR2,
92 X_Attribute3 VARCHAR2,
93 X_Attribute4 VARCHAR2,
94 X_Attribute5 VARCHAR2,
95 X_Attribute6 VARCHAR2,
96 X_Attribute7 VARCHAR2,
97 X_Attribute8 VARCHAR2,
98 X_Attribute9 VARCHAR2,
99 X_Attribute10 VARCHAR2,
100 X_Attribute11 VARCHAR2,
101 X_Attribute12 VARCHAR2,
102 X_Attribute13 VARCHAR2,
103 X_Attribute14 VARCHAR2,
104 X_Attribute15 VARCHAR2
105 );
106
107
108 PROCEDURE Update_Row(X_Rowid VARCHAR2,
109 X_Resource_Assignment_Id NUMBER,
110 X_Budget_Version_Id NUMBER,
111 X_Project_Id NUMBER,
112 X_Task_Id NUMBER,
113 X_Resource_List_Member_Id NUMBER,
114 X_Resource_Id NUMBER,
115 X_Resource_Id_Old NUMBER,
116 X_Description VARCHAR2,
117 X_Start_Date DATE,
118 X_End_Date DATE,
119 X_Period_Name VARCHAR2,
120 X_Quantity IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
121 X_Quantity_Old IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
122 X_Unit_Of_Measure VARCHAR2,
123 X_Track_As_Labor_Flag VARCHAR2,
124 X_Raw_Cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
125 X_Raw_Cost_Old IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
126 X_Burdened_Cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
127 X_Burdened_Cost_Old IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
128 X_Revenue IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
129 X_Revenue_Old IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
130 X_Change_Reason_Code VARCHAR2,
131 X_Last_Update_Date DATE,
132 X_Last_Updated_By NUMBER,
133 X_Last_Update_Login NUMBER,
134 X_Attribute_Category VARCHAR2,
135 X_Attribute1 VARCHAR2,
136 X_Attribute2 VARCHAR2,
137 X_Attribute3 VARCHAR2,
138 X_Attribute4 VARCHAR2,
139 X_Attribute5 VARCHAR2,
140 X_Attribute6 VARCHAR2,
141 X_Attribute7 VARCHAR2,
142 X_Attribute8 VARCHAR2,
143 X_Attribute9 VARCHAR2,
144 X_Attribute10 VARCHAR2,
145 X_Attribute11 VARCHAR2,
146 X_Attribute12 VARCHAR2,
147 X_Attribute13 VARCHAR2,
148 X_Attribute14 VARCHAR2,
149 X_Attribute15 VARCHAR2,
150 -- Bug Fix: 4569365. Removed MRC code.
151 -- X_mrc_flag VARCHAR2, /* FPB2: MRC */
152 X_Calling_Process VARCHAR2 DEFAULT 'PR',
153 X_raw_cost_source VARCHAR2 DEFAULT 'M',
154 X_burdened_cost_source VARCHAR2 DEFAULT 'M',
155 X_quantity_source VARCHAR2 DEFAULT 'M',
156 X_revenue_source VARCHAR2 DEFAULT 'M',
157 /*Added following 13 columns on 16-mar-2001*/
158 x_standard_bill_rate NUMBER DEFAULT NULL,
159 x_average_bill_rate NUMBER DEFAULT NULL,
160 x_average_cost_rate NUMBER DEFAULT NULL,
161 x_project_assignment_id NUMBER DEFAULT NULL,
162 x_plan_error_code VARCHAR2 DEFAULT NULL,
163 x_total_plan_revenue NUMBER DEFAULT NULL,
164 x_total_plan_raw_cost NUMBER DEFAULT NULL,
165 x_total_plan_burdened_cost NUMBER DEFAULT NULL,
166 x_total_plan_quantity NUMBER DEFAULT NULL,
167 x_average_discount_percentage NUMBER DEFAULT NULL,
168 x_cost_rejection_code VARCHAR2 DEFAULT NULL,
169 x_burden_rejection_code VARCHAR2 DEFAULT NULL,
170 x_revenue_rejection_code VARCHAR2 DEFAULT NULL,
171 x_other_rejection_code VARCHAR2 DEFAULT NULL,
172 X_Code_Combination_Id NUMBER DEFAULT NULL,
173 X_CCID_Gen_Status_Code VARCHAR2 DEFAULT NULL,
174 X_CCID_Gen_Rej_Message VARCHAR2 DEFAULT NULL
175 );
176
177
178 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
179 -- Bug Fix: 4569365. Removed MRC code.
180 -- X_mrc_flag VARCHAR2, /* FPB2: MRC */
181 X_CAlling_Process VARCHAR2 DEFAULT 'PR'
182 );
183
184
185 Procedure check_overlapping_dates ( X_Budget_Version_Id NUMBER,
186 x_resource_name IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
187 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
188
189
190 END PA_BUDGET_LINES_V_PKG;