PACKAGE: APPS.PA_PERF_KPA_SUMMARY_PKG

Source

1 package PA_PERF_KPA_SUMMARY_PKG as
2 /* $Header: PAPEESTS.pls 120.1 2005/08/19 16:38:42 mwasowic noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6   X_KPA_SUMMARY_ID in NUMBER,
7   X_OBJECT_TYPE in VARCHAR2,
8   X_OBJECT_ID in NUMBER,
9   X_DATE_CHECKED in DATE,
10   X_CURRENT_FLAG in VARCHAR2,
11   X_PERF_STATUS_CODE in VARCHAR2,
12   X_KPA1_CODE in VARCHAR2,
13   X_KPA1_INDICATOR in VARCHAR2,
14   X_KPA1_SCORE in NUMBER,
15   X_KPA1_THRES_FROM in VARCHAR2,
16   X_KPA1_THRES_TO in VARCHAR2,
17   X_KPA2_CODE in VARCHAR2,
18   X_KPA2_INDICATOR in VARCHAR2,
19   X_KPA2_SCORE in NUMBER,
20   X_KPA2_THRES_FROM in VARCHAR2,
21   X_KPA2_THRES_TO in VARCHAR2,
22   X_KPA3_CODE in VARCHAR2,
23   X_KPA3_INDICATOR in VARCHAR2,
24   X_KPA3_SCORE in NUMBER,
25   X_KPA3_THRES_FROM in VARCHAR2,
26   X_KPA3_THRES_TO in VARCHAR2,
27   X_KPA4_CODE in VARCHAR2,
28   X_KPA4_INDICATOR in VARCHAR2,
29   X_KPA4_SCORE in NUMBER,
30   X_KPA4_THRES_FROM in VARCHAR2,
31   X_KPA4_THRES_TO in VARCHAR2,
32   X_KPA5_CODE in VARCHAR2,
33   X_KPA5_INDICATOR in VARCHAR2,
34   X_KPA5_SCORE in NUMBER,
35   X_KPA5_THRES_FROM in VARCHAR2,
36   X_KPA5_THRES_TO in VARCHAR2,
37   X_CREATION_DATE in DATE DEFAULT sysdate,
38   X_CREATED_BY in NUMBER DEFAULT fnd_global.user_id,
39   X_LAST_UPDATE_DATE in DATE DEFAULT sysdate,
40   X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
41   X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id
42 );
43 
44 
45 procedure UPDATE_ROW (
46   X_KPA_SUMMARY_ID in NUMBER,
47   X_OBJECT_TYPE in VARCHAR2,
48   X_OBJECT_ID in NUMBER,
49   X_DATE_CHECKED in DATE,
50   X_CURRENT_FLAG in VARCHAR2,
51   X_PERF_STATUS_CODE in VARCHAR2,
52   X_KPA1_CODE in VARCHAR2,
53   X_KPA1_INDICATOR in VARCHAR2,
54   X_KPA1_SCORE in NUMBER,
55   X_KPA1_THRES_FROM in VARCHAR2,
56   X_KPA1_THRES_TO in VARCHAR2,
57   X_KPA2_CODE in VARCHAR2,
58   X_KPA2_INDICATOR in VARCHAR2,
59   X_KPA2_SCORE in NUMBER,
60   X_KPA2_THRES_FROM in VARCHAR2,
61   X_KPA2_THRES_TO in VARCHAR2,
62   X_KPA3_CODE in VARCHAR2,
63   X_KPA3_INDICATOR in VARCHAR2,
64   X_KPA3_SCORE in NUMBER,
65   X_KPA3_THRES_FROM in VARCHAR2,
66   X_KPA3_THRES_TO in VARCHAR2,
67   X_KPA4_CODE in VARCHAR2,
68   X_KPA4_INDICATOR in VARCHAR2,
69   X_KPA4_SCORE in NUMBER,
70   X_KPA4_THRES_FROM in VARCHAR2,
71   X_KPA4_THRES_TO in VARCHAR2,
72   X_KPA5_CODE in VARCHAR2,
73   X_KPA5_INDICATOR in VARCHAR2,
74   X_KPA5_SCORE in NUMBER,
75   X_KPA5_THRES_FROM in VARCHAR2,
76   X_KPA5_THRES_TO in VARCHAR2,
77   X_LAST_UPDATE_DATE in DATE  DEFAULT sysdate,
78   X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
79   X_LAST_UPDATE_LOGIN in NUMBER  DEFAULT fnd_global.login_id
80 );
81 
82 procedure DELETE_ROW (
83   X_KPA_SUMMARY_ID in NUMBER
84 );
85 
86 end PA_PERF_KPA_SUMMARY_PKG;