1 package JTF_IH_RESULTS_SEED_PKG as
2 /* $Header: JTFIHRSS.pls 120.2 2005/07/08 08:00:26 nchouras ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_RESULT_ID in NUMBER,
6 X_GENERATE_PRIVATE_CALLBACK in VARCHAR2,
7 X_POSITIVE_RESPONSE_FLAG in VARCHAR2,
8 X_OBJECT_VERSION_NUMBER in NUMBER,
9 X_GENERATE_PUBLIC_CALLBACK in VARCHAR2,
10 X_VERSATILITY_CODE in NUMBER,
11 X_RESULT_REQUIRED in VARCHAR2,
12 X_RESULT_CODE in VARCHAR2,
13 X_MEDIA_TYPE in VARCHAR2,
14 X_SHORT_DESCRIPTION in VARCHAR2,
15 X_LONG_DESCRIPTION in VARCHAR2,
16 X_CREATION_DATE in DATE,
17 X_CREATED_BY in NUMBER,
18 X_LAST_UPDATE_DATE in DATE,
19 X_LAST_UPDATED_BY in NUMBER,
20 X_LAST_UPDATE_LOGIN in NUMBER,
21 X_ACTIVE in VARCHAR2 DEFAULT NULL);
22 procedure LOCK_ROW (
23 X_RESULT_ID in NUMBER,
24 X_GENERATE_PRIVATE_CALLBACK in VARCHAR2,
25 X_POSITIVE_RESPONSE_FLAG in VARCHAR2,
26 X_OBJECT_VERSION_NUMBER in NUMBER,
27 X_GENERATE_PUBLIC_CALLBACK in VARCHAR2,
28 X_VERSATILITY_CODE in NUMBER,
29 X_RESULT_REQUIRED in VARCHAR2,
30 X_RESULT_CODE in VARCHAR2,
31 X_MEDIA_TYPE in VARCHAR2,
32 X_SHORT_DESCRIPTION in VARCHAR2,
33 X_LONG_DESCRIPTION in VARCHAR2
34 );
35 procedure UPDATE_ROW (
36 X_RESULT_ID in NUMBER,
37 X_GENERATE_PRIVATE_CALLBACK in VARCHAR2,
38 X_POSITIVE_RESPONSE_FLAG in VARCHAR2,
39 X_OBJECT_VERSION_NUMBER in NUMBER,
40 X_GENERATE_PUBLIC_CALLBACK in VARCHAR2,
41 X_VERSATILITY_CODE in NUMBER,
42 X_RESULT_REQUIRED in VARCHAR2,
43 X_RESULT_CODE in VARCHAR2,
44 X_MEDIA_TYPE in VARCHAR2,
45 X_SHORT_DESCRIPTION in VARCHAR2,
46 X_LONG_DESCRIPTION in VARCHAR2,
47 X_LAST_UPDATE_DATE in DATE,
48 X_LAST_UPDATED_BY in NUMBER,
49 X_LAST_UPDATE_LOGIN in NUMBER,
50 X_ACTIVE in VARCHAR2 DEFAULT NULL
51 );
52 procedure DELETE_ROW (
53 X_RESULT_ID in NUMBER
54 );
55 procedure ADD_LANGUAGE;
56 procedure LOAD_ROW (
57 X_RESULT_ID in NUMBER,
58 X_GENERATE_PUBLIC_CALLBACK in VARCHAR2,
59 X_GENERATE_PRIVATE_CALLBACK in VARCHAR2,
60 X_POSITIVE_RESPONSE_FLAG in VARCHAR2,
61 X_OBJECT_VERSION_NUMBER in NUMBER,
62 X_RESULT_REQUIRED in VARCHAR2,
63 X_VERSATILITY_CODE in NUMBER,
64 X_RESULT_CODE in VARCHAR2,
65 X_MEDIA_TYPE in VARCHAR2,
66 X_SHORT_DESCRIPTION in VARCHAR2,
67 X_LONG_DESCRIPTION in VARCHAR2,
68 X_OWNER IN VARCHAR2,
69 X_ACTIVE in VARCHAR2 DEFAULT NULL
70
71 );
72 procedure TRANSLATE_ROW (
73 X_RESULT_ID in NUMBER,
74 X_RESULT_CODE in VARCHAR2,
75 X_MEDIA_TYPE in VARCHAR2,
76 X_SHORT_DESCRIPTION in VARCHAR2,
77 X_LONG_DESCRIPTION in VARCHAR2,
78 X_OWNER IN VARCHAR2
79 );
80 procedure LOAD_SEED_ROW (
81 X_RESULT_ID in NUMBER,
82 X_GENERATE_PUBLIC_CALLBACK in VARCHAR2,
83 X_GENERATE_PRIVATE_CALLBACK in VARCHAR2,
84 X_POSITIVE_RESPONSE_FLAG in VARCHAR2,
85 X_OBJECT_VERSION_NUMBER in NUMBER,
86 X_RESULT_REQUIRED in VARCHAR2,
87 X_VERSATILITY_CODE in NUMBER,
88 X_RESULT_CODE in VARCHAR2,
89 X_MEDIA_TYPE in VARCHAR2,
90 X_SHORT_DESCRIPTION in VARCHAR2,
91 X_LONG_DESCRIPTION in VARCHAR2,
92 X_OWNER IN VARCHAR2,
93 X_ACTIVE in VARCHAR2 DEFAULT NULL,
94 X_UPLOAD_MODE in VARCHAR2
95 );
96 end JTF_IH_RESULTS_SEED_PKG;