APPS.PA_BILL_RATES_PKG dependencies on PA_BILL_RATES

Line 1: PACKAGE BODY PA_BILL_RATES_PKG as

1: PACKAGE BODY PA_BILL_RATES_PKG as
2: /* $Header: PASUDBRB.pls 120.3 2005/08/19 17:03:17 mwasowic noship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
5: X_Bill_Rate_Organization_Id NUMBER,

Line 27: CURSOR C IS SELECT rowid FROM PA_BILL_RATES

23: x_Rate_Currency_Code VARCHAR2,
24: X_Resource_Class_Code VARCHAR2,
25: X_Res_Class_Organization_Id NUMBER
26: ) IS
27: CURSOR C IS SELECT rowid FROM PA_BILL_RATES
28: WHERE
29:
30: -- Bug 2078409
31: /* bill_rate_organization_id = X_Bill_Rate_Organization_Id

Line 59: the pa_bill_rates table, The context is already set it in the forms */

55:
56:
57:
58: /* Shared service changes: Get the Current org Id from context and insert org_id into
59: the pa_bill_rates table, The context is already set it in the forms */
60:
61:
62: l_org_id := MO_GLOBAL.get_current_org_id ;
63:

Line 65: INSERT INTO PA_BILL_RATES(

61:
62: l_org_id := MO_GLOBAL.get_current_org_id ;
63:
64:
65: INSERT INTO PA_BILL_RATES(
66: Bill_Rate_Sch_Id,
67: bill_rate_organization_id,
68: std_bill_rate_schedule,
69: last_update_date,

Line 145: FROM PA_BILL_RATES

141: X_Res_Class_Organization_Id NUMBER
142: ) IS
143: CURSOR C IS
144: SELECT *
145: FROM PA_BILL_RATES
146: WHERE rowid = X_Rowid
147: FOR UPDATE of Bill_Rate_Organization_Id NOWAIT;
148: Recinfo C%ROWTYPE;
149:

Line 238: UPDATE PA_BILL_RATES

234: X_Res_Class_Organization_Id NUMBER
235:
236: ) IS
237: BEGIN
238: UPDATE PA_BILL_RATES
239: SET bill_rate_organization_id = X_Bill_Rate_Organization_Id,
240: std_bill_rate_schedule = X_Std_Bill_Rate_Schedule,
241: last_update_date = X_Last_Update_Date,
242: last_updated_by = X_Last_Updated_By,

Line 266: DELETE FROM PA_BILL_RATES

262: END Update_Row;
263:
264: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
265: BEGIN
266: DELETE FROM PA_BILL_RATES
267: WHERE rowid = X_Rowid;
268:
269: if (SQL%NOTFOUND) then
270: Raise NO_DATA_FOUND;

Line 275: END PA_BILL_RATES_PKG;

271: end if;
272: END Delete_Row;
273:
274:
275: END PA_BILL_RATES_PKG;