DBA Data[Home] [Help]

PACKAGE: APPS.JTF_IH_OUTCOMES_SEED_PKG

Source


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