APPS.HZ_DSS_SCHEME_FUNCTIONS_PKG dependencies on HZ_DSS_SCHEME_FUNCTIONS

Line 1: PACKAGE BODY HZ_DSS_SCHEME_FUNCTIONS_PKG AS

1: PACKAGE BODY HZ_DSS_SCHEME_FUNCTIONS_PKG AS
2: /* $Header: ARHPDSFB.pls 115.1 2002/09/30 06:26:02 cvijayan noship $ */
3:
4: PROCEDURE Insert_Row (
5: x_rowid IN OUT NOCOPY VARCHAR2,

Line 19: INSERT INTO HZ_DSS_SCHEME_FUNCTIONS (

15: BEGIN
16:
17: WHILE l_success = 'N' LOOP
18: BEGIN
19: INSERT INTO HZ_DSS_SCHEME_FUNCTIONS (
20: security_scheme_code,
21: data_operation_code,
22: function_id,
23: status,

Line 76: UPDATE HZ_DSS_SCHEME_FUNCTIONS

72: x_object_version_number IN NUMBER
73: ) IS
74: BEGIN
75:
76: UPDATE HZ_DSS_SCHEME_FUNCTIONS
77: SET
78: /*
79: security_scheme_code =
80: DECODE(x_security_scheme_code,

Line 133: SELECT * FROM hz_dss_scheme_functions

129: x_object_version_number IN NUMBER
130: ) IS
131:
132: CURSOR c IS
133: SELECT * FROM hz_dss_scheme_functions
134: WHERE rowid = x_rowid
135: FOR UPDATE NOWAIT;
136: Recinfo c%ROWTYPE;
137:

Line 202: FROM HZ_DSS_SCHEME_FUNCTIONS

198: SELECT
199: NVL(status, FND_API.G_MISS_CHAR)
200: INTO
201: x_status
202: FROM HZ_DSS_SCHEME_FUNCTIONS
203: WHERE security_scheme_code = x_security_scheme_code
204: AND data_operation_code = x_data_operation_code
205: AND function_id = x_function_id;
206:

Line 224: DELETE FROM HZ_DSS_SCHEME_FUNCTIONS

220: x_function_id IN NUMBER
221: ) IS
222: BEGIN
223:
224: DELETE FROM HZ_DSS_SCHEME_FUNCTIONS
225: WHERE security_scheme_code = x_security_scheme_code
226: AND data_operation_code = x_data_operation_code
227: AND function_id = x_function_id;
228:

Line 235: END HZ_DSS_SCHEME_FUNCTIONS_PKG;

231: END IF;
232:
233: END Delete_Row;
234:
235: END HZ_DSS_SCHEME_FUNCTIONS_PKG;