PACKAGE: APPS.JTF_IAPP_FAMILIES_PKG

Source

1 package JTF_IAPP_FAMILIES_PKG AUTHID CURRENT_USER as
2 /* $Header: jtfiapps.pls 120.2 2005/10/25 05:21:43 psanyal ship $ */
3 procedure INSERT_ROW (
4   X_APP_FAMILY_ID IN OUT NOCOPY /* file.sql.39 change */  NUMBER,
5   X_APP_FAMILY_ACCESS_NAME IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
6   X_DISPLAY_SEQUENCE in NUMBER,
7   X_ENABLED_FLAG in VARCHAR2,
8   X_APP_FAMILY_DISPLAY_NAME in VARCHAR2,
9   X_APP_FAMILY_DESCRIPTION in VARCHAR2,
10   X_OWNER in VARCHAR2
11 );
12 procedure UPDATE_ROW (
13   X_APP_FAMILY_ID in NUMBER,
14   X_APP_FAMILY_ACCESS_NAME in VARCHAR2,
15   X_DISPLAY_SEQUENCE in NUMBER,
16   X_ENABLED_FLAG in VARCHAR2,
17   X_OBJECT_VERSION_NUMBER in NUMBER,
18   X_APP_FAMILY_DISPLAY_NAME in VARCHAR2,
19   X_APP_FAMILY_DESCRIPTION in VARCHAR2,
20   X_OWNER in VARCHAR2
21 );
22 procedure DELETE_ROW (
23   X_APP_FAMILY_ID in NUMBER
24 );
25 
26 -- ALL APP to FAMILY related procedures
27 procedure ADD_APP_TO_FAMILY (
28   X_APP_FAMILY_ACCESS_NAME in VARCHAR2,
29   X_APP_ID in NUMBER
30 );
31 
32 procedure DELETE_ALL_APPS_IN_FAMILY (
33   X_APP_FAMILY_ACCESS_NAME in VARCHAR2
34 );
35 
36 procedure DELETE_FAMILY_AND_APPS (
37   X_APP_FAMILY_ACCESS_NAME in VARCHAR2
38 );
39 
40 procedure DELETE_APP_IN_FAMILY (
41   X_APP_FAMILY_ACCESS_NAME in VARCHAR2,
42   X_APP_ID in NUMBER
43 );
44 
45 -- ALL USER to FAMILY related procedures
46 procedure ADD_USER_DEF_RESP (
47   X_APP_FAMILY_ACCESS_NAME in VARCHAR2,
48   X_USER_ID in NUMBER,
49   X_DEFAULT_RESP_ID in NUMBER
50 );
51 
52 procedure DELETE_USER_DEF_RESP (
53   X_APP_FAMILY_ACCESS_NAME in VARCHAR2,
54   X_USER_ID in NUMBER
55 );
56 
57 procedure DELETE_USER_DEF_RESP_USING_ID (
58   X_APP_FAMILY_ID in NUMBER,
59   X_USER_ID in NUMBER
60 );
61 
62 procedure LOAD_ROW (
63   X_APP_FAMILY_ID in NUMBER,
64   X_APP_FAMILY_ACCESS_NAME in VARCHAR2,
65   X_DISPLAY_SEQUENCE in NUMBER,
66   X_ENABLED_FLAG in VARCHAR2,
67   X_APP_FAMILY_DISPLAY_NAME in VARCHAR2,
68   X_APP_FAMILY_DESCRIPTION in VARCHAR2,
69   X_APPLICATION_ID in NUMBER,
70   X_OWNER in VARCHAR2
71 );
72 
73 procedure TRANSLATE_ROW (
74    x_APP_FAMILY_ACCESS_NAME in VARCHAR2,
75    x_APP_FAMILY_DISPLAY_NAME in VARCHAR2,
76    x_APP_FAMILY_DESCRIPTION in VARCHAR2,
77    x_OWNER in VARCHAR2
78 );
79 
80 procedure ADD_LANGUAGE;
81 end JTF_IAPP_FAMILIES_PKG;