1 package FA_RX_SUMMARY_PKG as
2 /* $Header: faxrxsms.pls 120.5 2006/05/30 12:10:27 rravunny ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out nocopy VARCHAR2,
5 X_REPORT_ID in NUMBER,
6 X_ATTRIBUTE_SET in VARCHAR2,
7 X_COLUMN_NAME in VARCHAR2,
8 X_SUMMARY_FUNCTION in VARCHAR2,
9 X_PRINT_LEVEL in NUMBER,
10 X_RESET_LEVEL in NUMBER,
11 X_COMPUTE_LEVEL in NUMBER,
12 X_DISPLAY_STATUS in VARCHAR2,
13 X_SUMMARY_PROMPT in VARCHAR2,
14 X_CREATION_DATE in DATE,
15 X_CREATED_BY in NUMBER,
16 X_LAST_UPDATE_DATE in DATE,
17 X_LAST_UPDATED_BY in NUMBER,
18 X_LAST_UPDATE_LOGIN in NUMBER);
19 procedure LOCK_ROW (
20 X_REPORT_ID in NUMBER,
21 X_ATTRIBUTE_SET in VARCHAR2,
22 X_COLUMN_NAME in VARCHAR2,
23 X_SUMMARY_FUNCTION in VARCHAR2,
24 X_PRINT_LEVEL in NUMBER,
25 X_RESET_LEVEL in NUMBER,
26 X_COMPUTE_LEVEL in NUMBER,
27 X_DISPLAY_STATUS in VARCHAR2,
28 X_SUMMARY_PROMPT in VARCHAR2
29 );
30 procedure UPDATE_ROW (
31 X_REPORT_ID in NUMBER,
32 X_ATTRIBUTE_SET in VARCHAR2,
33 X_COLUMN_NAME in VARCHAR2,
34 X_SUMMARY_FUNCTION in VARCHAR2,
35 X_PRINT_LEVEL in NUMBER,
36 X_RESET_LEVEL in NUMBER,
37 X_COMPUTE_LEVEL in NUMBER,
38 X_DISPLAY_STATUS in VARCHAR2,
39 X_SUMMARY_PROMPT in VARCHAR2,
40 X_LAST_UPDATE_DATE in DATE,
41 X_LAST_UPDATED_BY in NUMBER,
42 X_LAST_UPDATE_LOGIN in NUMBER
43 );
44 procedure DELETE_ROW (
45 X_REPORT_ID in NUMBER,
46 X_ATTRIBUTE_SET in VARCHAR2,
47 X_COLUMN_NAME in VARCHAR2,
48 X_SUMMARY_FUNCTION in VARCHAR2,
49 X_PRINT_LEVEL in NUMBER,
50 X_RESET_LEVEL in NUMBER,
51 X_COMPUTE_LEVEL in NUMBER
52 );
53 procedure ADD_LANGUAGE;
54
55 procedure LOAD_ROW (
56 X_REPORT_ID in NUMBER,
57 X_ATTRIBUTE_SET in VARCHAR2,
58 X_COLUMN_NAME in VARCHAR2,
59 X_SUMMARY_FUNCTION in VARCHAR2,
60 X_PRINT_LEVEL in NUMBER,
61 X_RESET_LEVEL in NUMBER,
62 X_COMPUTE_LEVEL in NUMBER,
63 X_DISPLAY_STATUS in VARCHAR2,
64 X_SUMMARY_PROMPT in VARCHAR2,
65 X_OWNER in VARCHAR2);
66
67 procedure LOAD_ROW (
68 X_REPORT_ID in NUMBER,
69 X_ATTRIBUTE_SET in VARCHAR2,
70 X_COLUMN_NAME in VARCHAR2,
71 X_SUMMARY_FUNCTION in VARCHAR2,
72 X_PRINT_LEVEL in NUMBER,
73 X_RESET_LEVEL in NUMBER,
74 X_COMPUTE_LEVEL in NUMBER,
75 X_DISPLAY_STATUS in VARCHAR2,
76 X_SUMMARY_PROMPT in VARCHAR2,
77 X_OWNER in VARCHAR2,
78 X_LAST_UPDATE_DATE in VARCHAR2,
79 X_CUSTOM_MODE in VARCHAR2
80 );
81
82 procedure TRANSLATE_ROW (
83 X_REPORT_ID in NUMBER,
84 X_ATTRIBUTE_SET in VARCHAR2,
85 X_COLUMN_NAME in VARCHAR2,
86 X_SUMMARY_FUNCTION in VARCHAR2,
87 X_PRINT_LEVEL in NUMBER,
88 X_RESET_LEVEL in NUMBER,
89 X_COMPUTE_LEVEL in NUMBER,
90 X_SUMMARY_PROMPT in VARCHAR2,
91 X_OWNER in VARCHAR2
92 );
93
94 procedure TRANSLATE_ROW (
95 X_REPORT_ID in NUMBER,
96 X_ATTRIBUTE_SET in VARCHAR2,
97 X_COLUMN_NAME in VARCHAR2,
98 X_SUMMARY_FUNCTION in VARCHAR2,
99 X_PRINT_LEVEL in NUMBER,
100 X_RESET_LEVEL in NUMBER,
101 X_COMPUTE_LEVEL in NUMBER,
102 X_SUMMARY_PROMPT in VARCHAR2,
103 X_OWNER in VARCHAR2,
104 X_LAST_UPDATE_DATE in VARCHAR2,
105 X_CUSTOM_MODE in VARCHAR2
106 );
107
108 end FA_RX_SUMMARY_PKG;