APPS.GMD_FORMULA_SECURITY_PKG dependencies on GMD_FORMULA_SECURITY

Line 1: package body GMD_FORMULA_SECURITY_PKG as

1: package body GMD_FORMULA_SECURITY_PKG as
2: /* $Header: GMDFMSCB.pls 120.1 2005/07/26 11:51:04 txdaniel noship $ */
3:
4: PROCEDURE insert_row (
5: X_FORMULA_SECURITY_ID OUT NOCOPY NUMBER,

Line 19: SELECT gmd_formula_security_id_s.NextVal

15: X_LAST_UPDATED_BY IN NUMBER,
16: X_LAST_UPDATE_LOGIN IN NUMBER) IS
17:
18: CURSOR Cur_get_security_id IS
19: SELECT gmd_formula_security_id_s.NextVal
20: FROM dual;
21: l_formula_security_id NUMBER;
22: BEGIN
23: OPEN Cur_get_security_id;

Line 26: INSERT INTO gmd_formula_security (

22: BEGIN
23: OPEN Cur_get_security_id;
24: FETCH Cur_get_security_id INTO l_formula_security_id;
25: CLOSE Cur_get_security_id;
26: INSERT INTO gmd_formula_security (
27: FORMULA_SECURITY_ID,
28: FORMULA_ID,
29: ACCESS_TYPE_IND,
30: ORGANIZATION_ID,

Line 71: UPDATE gmd_formula_security SET

67: X_LAST_UPDATE_DATE IN DATE,
68: X_LAST_UPDATED_BY IN NUMBER,
69: X_LAST_UPDATE_LOGIN IN NUMBER) IS
70: BEGIN
71: UPDATE gmd_formula_security SET
72: FORMULA_ID = X_FORMULA_ID,
73: ACCESS_TYPE_IND = X_ACCESS_TYPE_IND,
74: ORGANIZATION_ID = X_ORGANIZATION_ID,
75: USER_ID = X_USER_ID,

Line 92: FROM gmd_formula_security

88:
89: PROCEDURE delete_row (X_FORMULA_SECURITY_ID in NUMBER) IS
90: BEGIN
91: DELETE
92: FROM gmd_formula_security
93: WHERE formula_security_id = X_formula_security_id;
94:
95: IF (SQL%NOTFOUND) then
96: RAISE no_data_found;

Line 102: end GMD_FORMULA_SECURITY_PKG;

98:
99: END delete_row;
100:
101:
102: end GMD_FORMULA_SECURITY_PKG;