APPS.PA_EVENT_TYPE_OUS_PKG dependencies on PA_EVENT_TYPE_OUS_ALL

Line 17: INSERT INTO PA_EVENT_TYPE_OUS_ALL

13: ) IS
14:
15: BEGIN
16:
17: INSERT INTO PA_EVENT_TYPE_OUS_ALL
18: ( EVENT_TYPE,
19: OUTPUT_TAX_CLASSIFICATION_CODE,
20: LAST_UPDATE_DATE,
21: CREATION_DATE,

Line 50: FROM PA_EVENT_TYPE_OUS_ALL EOUS

46: CURSOR C IS
47: SELECT EOUS.EVENT_TYPE,
48: EOUS.OUTPUT_TAX_CLASSIFICATION_CODE OUTPUT_TAX_CODE,
49: EOUS.ORG_ID
50: FROM PA_EVENT_TYPE_OUS_ALL EOUS
51: WHERE EOUS.rowid = RTRIM(X_Rowid)
52: FOR UPDATE of EOUS.OUTPUT_TAX_CLASSIFICATION_CODE NOWAIT;
53:
54: Recinfo C%ROWTYPE;

Line 95: UPDATE PA_EVENT_TYPE_OUS_ALL

91: L_ORG_ID NUMBER;
92:
93: BEGIN
94:
95: UPDATE PA_EVENT_TYPE_OUS_ALL
96: SET OUTPUT_TAX_CLASSIFICATION_CODE = x_output_tax_code,
97: LAST_UPDATE_DATE = X_Last_Update_Date,
98: LAST_UPDATED_BY = X_Last_Updated_By,
99: LAST_UPDATE_LOGIN = X_Last_Update_Login

Line 109: DELETE FROM PA_EVENT_TYPE_OUS_ALL

105: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
106: BEGIN /* Rearranged the DELETE statements for bug 3182079 */
107: BEGIN
108: /* Delete record from PA_EVENT_TYPE_OUS */
109: DELETE FROM PA_EVENT_TYPE_OUS_ALL
110: WHERE ROWID = X_ROWID;
111:
112: EXCEPTION
113: WHEN NO_DATA_FOUND THEN