APPS.PA_ROLE_CONTROLS_PKG dependencies on PA_ROLE_CONTROLS

Line 1: PACKAGE BODY pa_role_controls_pkg AS

1: PACKAGE BODY pa_role_controls_pkg AS
2: /* $Header: PAXPRRCB.pls 120.1 2005/08/19 17:17:51 mwasowic noship $ */
3:
4: -- INSERT ROW -----------------------------------------
5: PROCEDURE INSERT_ROW (

Line 19: FROM pa_role_controls

15:
16: CURSOR c
17: IS
18: SELECT rowid
19: FROM pa_role_controls
20: WHERE role_control_code = x_role_control_code
21: AND project_role_id = x_project_role_id;
22:
23:

Line 27: INSERT INTO pa_role_controls (

23:
24:
25: BEGIN
26:
27: INSERT INTO pa_role_controls (
28: ROLE_CONTROL_CODE,
29: PROJECT_ROLE_ID,
30: LAST_UPDATE_DATE,
31: LAST_UPDATED_BY,

Line 68: FROM pa_role_controls

64:
65: CURSOR c
66: IS
67: SELECT *
68: FROM pa_role_controls
69: WHERE rowid = X_Rowid
70: FOR UPDATE OF role_control_code, project_role_id NOWAIT;
71:
72: Recinfo c%ROWTYPE;

Line 115: UPDATE pa_role_controls

111: ) IS
112:
113: BEGIN
114:
115: UPDATE pa_role_controls
116: SET ROLE_CONTROL_CODE =X_ROLE_CONTROL_CODE,
117: PROJECT_ROLE_ID =X_PROJECT_ROLE_ID,
118: LAST_UPDATE_DATE =X_LAST_UPDATE_DATE,
119: LAST_UPDATED_BY =X_LAST_UPDATED_BY,

Line 139: DELETE FROM pa_role_controls

135: PROCEDURE DELETE_ROW (X_Rowid VARCHAR2)
136: IS
137: BEGIN
138:
139: DELETE FROM pa_role_controls
140: WHERE rowid = X_Rowid;
141:
142: IF (SQL%NOTFOUND)
143: THEN

Line 150: END pa_role_controls_pkg;

146:
147: END Delete_Row;
148:
149:
150: END pa_role_controls_pkg;