APPS.PA_EXPENDITURE_TYPES_PKG dependencies on PA_EXPENDITURE_TYPES

Line 1: PACKAGE BODY PA_EXPENDITURE_TYPES_PKG as

1: PACKAGE BODY PA_EXPENDITURE_TYPES_PKG as
2: /* $Header: PAXTETSB.pls 120.3 2005/08/17 23:03:57 vthakkar noship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Expenditure_Type VARCHAR2,

Line 39: CURSOR C IS SELECT rowid FROM pa_expenditure_types

35: -- MOAC changes
36: -- , X_output_tax_code VARCHAR2
37:
38: ) IS
39: CURSOR C IS SELECT rowid FROM pa_expenditure_types
40: WHERE expenditure_type = X_Expenditure_Type;
41:
42: L_output_vat_tax_id NUMBER;
43:

Line 47: INSERT INTO pa_expenditure_types(

43:
44: BEGIN
45:
46:
47: INSERT INTO pa_expenditure_types(
48: expenditure_type_id,
49: expenditure_type,
50: last_update_date,
51: last_updated_by,

Line 196: FROM pa_expenditure_types

192: --, X_output_tax_code VARCHAR2
193: ) IS
194: CURSOR C IS
195: SELECT *
196: FROM pa_expenditure_types
197: WHERE rowid = X_Rowid
198: FOR UPDATE of Expenditure_Type NOWAIT;
199: Recinfo C%ROWTYPE;
200:

Line 322: UPDATE pa_expenditure_types

318:
319: L_output_vat_tax_id NUMBER;
320:
321: BEGIN
322: UPDATE pa_expenditure_types
323: SET
324: expenditure_type = X_Expenditure_Type,
325: last_update_date = X_Last_Update_Date,
326: last_updated_by = X_Last_Updated_By,

Line 413: END PA_EXPENDITURE_TYPES_PKG;

409: END IF;
410: */
411: END Update_Row;
412:
413: END PA_EXPENDITURE_TYPES_PKG;