APPS.PA_EVENT_TYPES_PKG dependencies on PA_EVENT_TYPES

Line 1: PACKAGE BODY PA_EVENT_TYPES_PKG as

1: PACKAGE BODY PA_EVENT_TYPES_PKG as
2: /* $Header: PAXSUETB.pls 120.3 2005/08/19 17:20:53 mwasowic noship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
5: X_Event_type_Id NUMBER, /** 2363945 **/

Line 36: CURSOR C IS SELECT rowid FROM PA_EVENT_TYPES

32: X_Attribute14 VARCHAR2,
33: X_Attribute15 VARCHAR2
34:
35: ) IS
36: CURSOR C IS SELECT rowid FROM PA_EVENT_TYPES
37: WHERE event_type = X_Event_Type;
38:
39: /*
40: CURSOR T IS SELECT VAT_TAX_ID

Line 54: INSERT INTO PA_EVENT_TYPES(

50:
51: BEGIN
52:
53:
54: INSERT INTO PA_EVENT_TYPES(
55:
56: event_type,
57: event_type_id,
58: last_update_date,

Line 187: FROM PA_EVENT_TYPES ET

183: ) IS
184: --hsiu: modified cursor
185: CURSOR C IS
186: SELECT ET.*
187: FROM PA_EVENT_TYPES ET
188: WHERE ET.rowid = RTRIM(X_Rowid)
189: FOR UPDATE of ET.Event_Type NOWAIT;
190:
191: /*Shared Services

Line 193: FROM PA_EVENT_TYPES ET,

189: FOR UPDATE of ET.Event_Type NOWAIT;
190:
191: /*Shared Services
192: SELECT ET.*, EOUS.OUTPUT_TAX_CLASSIFICATION_CODE OUTPUT_TAX_CODE
193: FROM PA_EVENT_TYPES ET,
194: PA_EVENT_TYPE_OUS EOUS
195: WHERE ET.rowid = RTRIM(X_Rowid)
196: and RTRIM(ET.EVENT_TYPE) = RTRIM(EOUS.EVENT_TYPE(+))
197: FOR UPDATE of ET.Event_Type NOWAIT;*/

Line 329: UPDATE PA_EVENT_TYPES

325: L_TAX_ID NUMBER;
326: L_ORG_ID NUMBER;
327:
328: BEGIN
329: UPDATE PA_EVENT_TYPES
330: SET
331: event_type = X_Event_Type,
332: last_update_date = X_Last_Update_Date,
333: last_updated_by = X_Last_Updated_By,

Line 414: FROM PA_EVENT_TYPES

410: BEGIN
411: /* Delete record from PA_EVENT_TYPE_OUS */
412: DELETE FROM PA_EVENT_TYPE_OUS_ALL
413: WHERE EVENT_TYPE = ( SELECT EVENT_TYPE
414: FROM PA_EVENT_TYPES
415: WHERE rowid = X_Rowid);
416: EXCEPTION
417: WHEN NO_DATA_FOUND THEN
418: null;

Line 424: DELETE FROM PA_EVENT_TYPES

420: raise ;
421: END;
422: BEGIN
423:
424: DELETE FROM PA_EVENT_TYPES
425: WHERE rowid = X_Rowid;
426:
427: if (SQL%NOTFOUND) then
428: Raise NO_DATA_FOUND;

Line 436: END PA_EVENT_TYPES_PKG;

432: raise ;
433: END;
434: END Delete_Row;
435:
436: END PA_EVENT_TYPES_PKG;