4:
5:
6: FUNCTION create_event
7: (
8: p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
9: p_event_type_code IN VARCHAR2,
10: p_event_date IN DATE,
11: p_event_status_code IN VARCHAR2,
12: p_event_number IN INTEGER, -- DEFAULT NULL
10: p_event_date IN DATE,
11: p_event_status_code IN VARCHAR2,
12: p_event_number IN INTEGER, -- DEFAULT NULL
13: p_transaction_date IN DATE,
14: p_reference_info IN XLA_EVENTS_PUB_PKG.T_EVENT_REFERENCE_INFO, -- DEFAULT NULL
15: p_valuation_method IN VARCHAR2,
16: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
17: p_calling_sequence IN VARCHAR2
18: )
12: p_event_number IN INTEGER, -- DEFAULT NULL
13: p_transaction_date IN DATE,
14: p_reference_info IN XLA_EVENTS_PUB_PKG.T_EVENT_REFERENCE_INFO, -- DEFAULT NULL
15: p_valuation_method IN VARCHAR2,
16: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
17: p_calling_sequence IN VARCHAR2
18: )
19: RETURN INTEGER;
20:
19: RETURN INTEGER;
20:
21: PROCEDURE update_event_status
22: (
23: p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
24: p_event_class_code IN VARCHAR2, -- DEFAULT NULL
25: p_event_type_code IN VARCHAR2, -- DEFAULT NULL
26: p_event_date IN DATE, -- DEFAULT NULL
27: p_event_status_code IN VARCHAR2,
25: p_event_type_code IN VARCHAR2, -- DEFAULT NULL
26: p_event_date IN DATE, -- DEFAULT NULL
27: p_event_status_code IN VARCHAR2,
28: p_valuation_method IN VARCHAR2,
29: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
30: p_calling_sequence IN VARCHAR2
31: );
32:
33:
33:
34:
35: PROCEDURE update_event
36: (
37: p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
38: p_event_id IN INTEGER,
39: p_event_type_code IN VARCHAR2, -- DEFAULT NULL
40: p_event_date IN DATE, -- DEFAULT NULL
41: p_event_status_code IN VARCHAR2, -- DEFAULT NULL
39: p_event_type_code IN VARCHAR2, -- DEFAULT NULL
40: p_event_date IN DATE, -- DEFAULT NULL
41: p_event_status_code IN VARCHAR2, -- DEFAULT NULL
42: p_valuation_method IN VARCHAR2,
43: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
44: p_calling_sequence IN VARCHAR2
45: );
46:
47:
47:
48:
49: PROCEDURE update_event
50: (
51: p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
52: p_event_id IN INTEGER,
53: p_event_type_code IN VARCHAR2, -- DEFAULT NULL
54: p_event_date IN DATE, -- DEFAULT NULL
55: p_event_status_code IN VARCHAR2, -- DEFAULT NULL
54: p_event_date IN DATE, -- DEFAULT NULL
55: p_event_status_code IN VARCHAR2, -- DEFAULT NULL
56: p_event_number IN INTEGER,
57: p_valuation_method IN VARCHAR2,
58: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
59: p_calling_sequence IN VARCHAR2
60: );
61:
62:
62:
63:
64: PROCEDURE update_event
65: (
66: p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
67: p_event_id IN INTEGER,
68: p_event_type_code IN VARCHAR2, -- DEFAULT NULL
69: p_event_date IN DATE, -- DEFAULT NULL
70: p_event_status_code IN VARCHAR2, -- DEFAULT NULL
67: p_event_id IN INTEGER,
68: p_event_type_code IN VARCHAR2, -- DEFAULT NULL
69: p_event_date IN DATE, -- DEFAULT NULL
70: p_event_status_code IN VARCHAR2, -- DEFAULT NULL
71: p_reference_info IN XLA_EVENTS_PUB_PKG.T_EVENT_REFERENCE_INFO,
72: p_valuation_method IN VARCHAR2,
73: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
74: p_calling_sequence IN VARCHAR2
75: );
69: p_event_date IN DATE, -- DEFAULT NULL
70: p_event_status_code IN VARCHAR2, -- DEFAULT NULL
71: p_reference_info IN XLA_EVENTS_PUB_PKG.T_EVENT_REFERENCE_INFO,
72: p_valuation_method IN VARCHAR2,
73: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
74: p_calling_sequence IN VARCHAR2
75: );
76:
77:
77:
78:
79: PROCEDURE update_event
80: (
81: p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
82: p_event_id IN INTEGER,
83: p_event_type_code IN VARCHAR2, -- DEFAULT NULL
84: p_event_date IN DATE, -- DEFAULT NULL
85: p_event_status_code IN VARCHAR2, -- DEFAULT NULL
83: p_event_type_code IN VARCHAR2, -- DEFAULT NULL
84: p_event_date IN DATE, -- DEFAULT NULL
85: p_event_status_code IN VARCHAR2, -- DEFAULT NULL
86: p_event_number IN INTEGER,
87: p_reference_info IN XLA_EVENTS_PUB_PKG.T_EVENT_REFERENCE_INFO,
88: p_valuation_method IN VARCHAR2,
89: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
90: p_calling_sequence IN VARCHAR2
91: );
85: p_event_status_code IN VARCHAR2, -- DEFAULT NULL
86: p_event_number IN INTEGER,
87: p_reference_info IN XLA_EVENTS_PUB_PKG.T_EVENT_REFERENCE_INFO,
88: p_valuation_method IN VARCHAR2,
89: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
90: p_calling_sequence IN VARCHAR2
91: );
92:
93:
93:
94:
95: PROCEDURE delete_event
96: (
97: p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
98: p_event_id IN INTEGER,
99: p_valuation_method IN VARCHAR2,
100: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
101: p_calling_sequence IN VARCHAR2
96: (
97: p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
98: p_event_id IN INTEGER,
99: p_valuation_method IN VARCHAR2,
100: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
101: p_calling_sequence IN VARCHAR2
102: );
103:
104:
104:
105:
106: FUNCTION delete_events
107: (
108: p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
109: p_event_class_code IN VARCHAR2, -- DEFAULT NULL
110: p_event_type_code IN VARCHAR2, -- DEFAULT NULL
111: p_event_date IN DATE, -- DEFAULT NULL
112: p_valuation_method IN VARCHAR2,
109: p_event_class_code IN VARCHAR2, -- DEFAULT NULL
110: p_event_type_code IN VARCHAR2, -- DEFAULT NULL
111: p_event_date IN DATE, -- DEFAULT NULL
112: p_valuation_method IN VARCHAR2,
113: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
114: p_calling_sequence IN VARCHAR2
115: )
116: RETURN INTEGER;
117:
118:
119:
120: FUNCTION get_event_info
121: (
122: p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
123: p_event_id IN INTEGER,
124: p_valuation_method IN VARCHAR2,
125: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
126: p_calling_sequence IN VARCHAR2
121: (
122: p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
123: p_event_id IN INTEGER,
124: p_valuation_method IN VARCHAR2,
125: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
126: p_calling_sequence IN VARCHAR2
127: )
128: RETURN XLA_EVENTS_PUB_PKG.T_EVENT_INFO;
129:
124: p_valuation_method IN VARCHAR2,
125: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
126: p_calling_sequence IN VARCHAR2
127: )
128: RETURN XLA_EVENTS_PUB_PKG.T_EVENT_INFO;
129:
130:
131:
132: FUNCTION get_event_status
130:
131:
132: FUNCTION get_event_status
133: (
134: p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
135: p_event_id IN INTEGER,
136: p_valuation_method IN VARCHAR2,
137: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
138: p_calling_sequence IN VARCHAR2
133: (
134: p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
135: p_event_id IN INTEGER,
136: p_valuation_method IN VARCHAR2,
137: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
138: p_calling_sequence IN VARCHAR2
139: )
140: RETURN VARCHAR2;
141:
142:
143:
144: FUNCTION event_exists
145: (
146: p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
147: p_event_class_code IN VARCHAR2, -- DEFAULT NULL
148: p_event_type_code IN VARCHAR2, -- DEFAULT NULL
149: p_event_date IN DATE, -- DEFAULT NULL
150: p_event_status_code IN VARCHAR2, -- DEFAULT NULL
149: p_event_date IN DATE, -- DEFAULT NULL
150: p_event_status_code IN VARCHAR2, -- DEFAULT NULL
151: p_event_number IN INTEGER, -- DEFAULT NULL
152: p_valuation_method IN VARCHAR2,
153: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
154: p_calling_sequence IN VARCHAR2
155: )
156: RETURN BOOLEAN;
157:
158:
159:
160: FUNCTION get_array_event_info
161: (
162: p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
163: p_event_class_code IN VARCHAR2, -- DEFAULT NULL
164: p_event_type_code IN VARCHAR2, -- DEFAULT NULL
165: p_event_date IN DATE, -- DEFAULT NULL
166: p_event_status_code IN VARCHAR2, -- DEFAULT NULL
164: p_event_type_code IN VARCHAR2, -- DEFAULT NULL
165: p_event_date IN DATE, -- DEFAULT NULL
166: p_event_status_code IN VARCHAR2, -- DEFAULT NULL
167: p_valuation_method IN VARCHAR2,
168: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
169: p_calling_sequence IN VARCHAR2
170: )
171: RETURN XLA_EVENTS_PUB_PKG.T_ARRAY_EVENT_INFO;
172:
167: p_valuation_method IN VARCHAR2,
168: p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
169: p_calling_sequence IN VARCHAR2
170: )
171: RETURN XLA_EVENTS_PUB_PKG.T_ARRAY_EVENT_INFO;
172:
173:
174:
175: END AP_XLA_EVENTS_PKG;