DBA Data[Home] [Help]

PACKAGE: APPS.FA_RX_SUMMARY_PKG

Source


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;