PACKAGE: APPS.JTF_DAC_CRITERIA_PKG

Source

1 PACKAGE JTF_DAC_CRITERIA_PKG AUTHID CURRENT_USER AS
2 /* $Header: jtfaacs.pls 120.2 2005/10/25 05:10:21 psanyal ship $ */
3 
4   /* for return status */
5   ERROR_STATUS      CONSTANT NUMBER      := -1;
6   OKAY_STATUS       CONSTANT NUMBER      := 0;
7 
8 procedure INSERT_ROW(
9   X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
10   x_criteria_id in number,
11   x_role_perm_id in number,
12   x_property_name in varchar2,
13   x_operator in varchar2,
14   x_property_value in varchar2,
15   x_property_value_type in varchar2,
16   x_object_version_number in number,
17   X_CREATION_DATE in DATE,
18   X_CREATED_BY in NUMBER,
19   X_LAST_UPDATE_DATE in DATE,
20   X_LAST_UPDATED_BY in NUMBER,
21   X_LAST_UPDATE_LOGIN in NUMBER
22 );
23 
24 procedure UPDATE_ROW (
25   x_criteria_id in number,
26   x_role_perm_id in number,
27   x_property_name in varchar2,
28   x_operator in varchar2,
29   x_property_value in varchar2,
30   x_property_value_type in varchar2,
31   x_object_version_number in number,
32   X_LAST_UPDATE_DATE in DATE,
33   X_LAST_UPDATED_BY in NUMBER,
34   X_LAST_UPDATE_LOGIN in NUMBER
35 );
36 
37 PROCEDURE TRANSLATE_ROW(
38   x_criteria_id in number,
39   x_role_perm_id in number,
40   x_property_name in varchar2,
41   x_operator in varchar2,
42   x_property_value in varchar2,
43   x_property_value_type in varchar2,
44   x_object_version_number in number,
45   x_owner in varchar2
46 );
47 
48 PROCEDURE LOAD_ROW(
49   x_criteria_id in number,
50   x_role_perm_id in number,
51   x_property_name in varchar2,
52   x_operator in varchar2,
53   x_property_value in varchar2,
54   x_property_value_type in varchar2,
55   x_object_version_number in number,
56   x_owner in varchar2
57 );
58 
59 end JTF_DAC_CRITERIA_PKG;