DBA Data[Home] [Help]

PACKAGE: APPS.GMD_FORMULA_SECURITY_PKG

Source


1 package GMD_FORMULA_SECURITY_PKG AUTHID CURRENT_USER as
2 /* $Header: GMDFMSCS.pls 120.1 2005/07/26 11:49:47 txdaniel noship $ */
3 
4   PROCEDURE insert_row (
5     X_FORMULA_SECURITY_ID OUT NOCOPY  NUMBER,
6     X_FORMULA_ID IN NUMBER,
7     X_ACCESS_TYPE_IND IN VARCHAR2,
8     X_ORGANIZATION_ID IN NUMBER,
9     X_USER_ID IN NUMBER,
10     X_RESPONSIBILITY_ID IN NUMBER,
11     X_OTHER_ORGANIZATION_ID IN NUMBER,
12     X_CREATION_DATE IN DATE,
13     X_CREATED_BY IN NUMBER,
14     X_LAST_UPDATE_DATE IN DATE,
15     X_LAST_UPDATED_BY IN NUMBER,
16     X_LAST_UPDATE_LOGIN IN NUMBER);
17 
18   PROCEDURE update_row (
19     X_FORMULA_SECURITY_ID IN NUMBER,
20     X_FORMULA_ID IN NUMBER,
21     X_ACCESS_TYPE_IND IN VARCHAR2,
22     X_ORGANIZATION_ID IN NUMBER,
23     X_USER_ID IN NUMBER,
24     X_RESPONSIBILITY_ID IN NUMBER,
25     X_OTHER_ORGANIZATION_ID IN NUMBER,
26     X_LAST_UPDATE_DATE IN DATE,
27     X_LAST_UPDATED_BY IN NUMBER,
28     X_LAST_UPDATE_LOGIN IN NUMBER);
29 
30   PROCEDURE delete_row (X_FORMULA_SECURITY_ID IN NUMBER);
31 
32 end GMD_FORMULA_SECURITY_PKG;