1 package XDP_FES_PKG as
2 /* $Header: XDPFES.pls 120.1 2005/06/15 23:15:07 appldev $ */
3 procedure INSERT_ROW (
4 X_ROWID in OUT NOCOPY VARCHAR2,
5 X_FE_ID in NUMBER,
6 X_FETYPE_ID in NUMBER,
7 X_FULFILLMENT_ELEMENT_NAME in VARCHAR2,
8 X_MAX_CONNECTION in NUMBER,
9 X_MIN_CONNECTION in NUMBER,
10 X_SESSION_CONTROLLER_ID in NUMBER,
11 X_VALID_DATE in DATE,
12 X_INVALID_DATE in DATE,
13 X_GEO_AREA_ID in NUMBER,
14 X_ROLE_NAME in VARCHAR2,
15 X_NETWORK_UNIT_ID in NUMBER,
16 X_DISPLAY_NAME in VARCHAR2,
17 X_DESCRIPTION in VARCHAR2,
18 X_CREATION_DATE in DATE,
19 X_CREATED_BY in NUMBER,
20 X_LAST_UPDATE_DATE in DATE,
21 X_LAST_UPDATED_BY in NUMBER,
22 X_LAST_UPDATE_LOGIN in NUMBER);
23 procedure LOCK_ROW (
24 X_FE_ID in NUMBER,
25 X_FETYPE_ID in NUMBER,
26 X_FULFILLMENT_ELEMENT_NAME in VARCHAR2,
27 X_MAX_CONNECTION in NUMBER,
28 X_MIN_CONNECTION in NUMBER,
29 X_SESSION_CONTROLLER_ID in NUMBER,
30 X_VALID_DATE in DATE,
31 X_INVALID_DATE in DATE,
32 X_GEO_AREA_ID in NUMBER,
33 X_ROLE_NAME in VARCHAR2,
34 X_NETWORK_UNIT_ID in NUMBER,
35 X_DISPLAY_NAME in VARCHAR2,
36 X_DESCRIPTION in VARCHAR2
37 );
38 procedure UPDATE_ROW (
39 X_FE_ID in NUMBER,
40 X_FETYPE_ID in NUMBER,
41 X_FULFILLMENT_ELEMENT_NAME in VARCHAR2,
42 X_MAX_CONNECTION in NUMBER,
43 X_MIN_CONNECTION in NUMBER,
44 X_SESSION_CONTROLLER_ID in NUMBER,
45 X_VALID_DATE in DATE,
46 X_INVALID_DATE in DATE,
47 X_GEO_AREA_ID in NUMBER,
48 X_ROLE_NAME in VARCHAR2,
49 X_NETWORK_UNIT_ID in NUMBER,
50 X_DISPLAY_NAME in VARCHAR2,
51 X_DESCRIPTION in VARCHAR2,
52 X_LAST_UPDATE_DATE in DATE,
53 X_LAST_UPDATED_BY in NUMBER,
54 X_LAST_UPDATE_LOGIN in NUMBER
55 );
56 procedure DELETE_ROW (
57 X_FE_ID in NUMBER
58 );
59 procedure ADD_LANGUAGE;
60 procedure LOAD_ROW (
61 X_FE_ID in NUMBER,
62 X_FETYPE_ID in NUMBER,
63 X_FULFILLMENT_ELEMENT_NAME in VARCHAR2,
64 X_MAX_CONNECTION in NUMBER,
65 X_MIN_CONNECTION in NUMBER,
66 X_SESSION_CONTROLLER_ID in NUMBER,
67 X_VALID_DATE in DATE,
68 X_INVALID_DATE in DATE,
69 X_GEO_AREA_ID in NUMBER,
70 X_ROLE_NAME in VARCHAR2,
71 X_NETWORK_UNIT_ID in NUMBER,
72 X_DISPLAY_NAME in VARCHAR2,
73 X_DESCRIPTION in VARCHAR2,
74 X_OWNER in VARCHAR2
75 );
76 procedure TRANSLATE_ROW (
77 X_FE_ID in NUMBER,
78 X_DISPLAY_NAME in VARCHAR2,
79 X_DESCRIPTION in VARCHAR2,
80 X_OWNER in VARCHAR2
81 );
82 end XDP_FES_PKG;