[Home] [Help]
PACKAGE: APPS.CE_STATEMENT_RECONS_PKG
Source
1 PACKAGE ce_statement_recons_pkg AS
2 /* $Header: cestmres.pls 120.2 2004/09/02 22:55:52 lkwan ship $ */
3 --
4 -- Package
5 -- ce_statement_recons_pkg
6 -- Purpose
7 -- To contain routines for ce_statement_recons
8 -- History
9 -- 04-08-95 Kai Pigg Created
10 G_spec_revision VARCHAR2(1000) := '$Revision: 120.2 $';
11
12 FUNCTION spec_revision RETURN VARCHAR2;
13
14 FUNCTION body_revision RETURN VARCHAR2;
15
16 --
17 -- Procedure
18 -- check_unique
19 -- Purpose
20 -- Checks to make sure that the reconciliation inserted
21 -- is unique.
22 -- History
23 -- 04-08-95 Kai Pigg Created
24 -- Arguments
25 -- X_statement_line_id NUMBER
26 -- X_reference_type VARCHAR2
27 -- X_reference_id NUMBER
28 -- X_currenct_record_flag VARCHAR2
29 -- X_row_id VARCHAR2
30 --
31 -- Example
32 -- ce_statement_recons_pkg.check_unique(...);
33 -- Notes
34 --
35 PROCEDURE check_unique(X_statement_line_id NUMBER,
36 X_reference_type VARCHAR2,
37 X_reference_id VARCHAR2,
38 X_current_record_flag VARCHAR2,
39 X_row_id VARCHAR2);
40 --
41 -- Procedure
42 -- Insert_Row
43 -- Purpose
44 -- Inserts a row into ce_statement_reconciliations
45 -- History
46 -- 04-08-95 Kai Pigg Created
47 -- Arguments
48 -- all the columns of the table CE_STATEMENT_RECONCILIATIONS
49 -- Example
50 -- ce_statement_recons_pkg.Insert_Row(....;
51 -- Notes
52 --
53 PROCEDURE Insert_Row( X_Row_id IN OUT NOCOPY VARCHAR2,
54 X_statement_line_id NUMBER,
55 X_reference_type VARCHAR2,
56 X_reference_id NUMBER,
57 X_org_id NUMBER,
58 X_legal_entity_id NUMBER,
59 X_reference_status VARCHAR2,
60 X_amount NUMBER DEFAULT NULL,
61 X_status_flag VARCHAR2,
62 X_action_flag VARCHAR2,
63 X_current_record_flag VARCHAR2,
64 X_auto_reconciled_flag VARCHAR2,
65 X_created_by NUMBER,
66 X_creation_date DATE,
67 X_last_updated_by NUMBER,
68 X_last_update_date DATE,
69 X_request_id NUMBER DEFAULT NULL,
70 X_program_application_id NUMBER DEFAULT NULL,
71 X_program_id NUMBER DEFAULT NULL,
72 X_program_update_date DATE DEFAULT NULL);
73
74 PROCEDURE Insert_Row( X_Row_id IN OUT NOCOPY VARCHAR2,
75 X_statement_line_id NUMBER,
76 X_reference_type VARCHAR2,
77 X_reference_id NUMBER,
78 X_je_header_id NUMBER,
79 X_org_id NUMBER,
80 X_legal_entity_id NUMBER,
81 X_reference_status VARCHAR2,
82 X_amount NUMBER DEFAULT NULL,
83 X_status_flag VARCHAR2,
84 X_action_flag VARCHAR2,
85 X_current_record_flag VARCHAR2,
86 X_auto_reconciled_flag VARCHAR2,
87 X_created_by NUMBER,
88 X_creation_date DATE,
89 X_last_updated_by NUMBER,
90 X_last_update_date DATE,
91 X_request_id NUMBER DEFAULT NULL,
92 X_program_application_id NUMBER DEFAULT NULL,
93 X_program_id NUMBER DEFAULT NULL,
94 X_program_update_date DATE DEFAULT NULL);
95 --
96 -- Procedure
97 -- Update_Row
98 -- Purpose
99 -- Updates a row into ce_statement_reconciliations
100 -- History
101 -- 04-08-95 Kai Pigg Created
102 -- Arguments
103 -- all the columns of the table CE_STATEMENT_RECONCILIATIONS
104 -- Example
105 -- ce_statement_recons_pkg.Update_Row(....;
106 -- Notes
107 --
108 PROCEDURE Update_Row( X_Row_id IN OUT NOCOPY VARCHAR2,
109 X_statement_line_id NUMBER,
110 X_reference_type VARCHAR2,
111 X_reference_id NUMBER,
112 X_status VARCHAR2,
113 X_cleared_when_matched VARCHAR2,
114 X_current_record_flag VARCHAR2,
115 X_auto_reconciled_flag VARCHAR2,
116 X_created_by NUMBER,
117 X_creation_date DATE,
118 X_last_updated_by NUMBER,
119 X_last_update_date DATE);
120
121
122 --
123 -- Procedure
124 -- Lock_Row
125 -- Purpose
126 -- Locks a row into ce_statement_reconciliations
127 -- History
128 -- 04-08-95 Kai Pigg Created
129 -- Arguments
130 -- all the columns of the table CE_STATEMENT_RECONCILIATIONS
131 -- Example
132 -- ce_statement_recons_pkg.Lock_Row(....;
133 -- Notes
134 --
135 PROCEDURE Lock_Row ( X_Row_id IN OUT NOCOPY VARCHAR2,
136 X_statement_line_id NUMBER,
137 X_reference_type VARCHAR2,
138 X_reference_id NUMBER,
139 X_status VARCHAR2,
140 X_cleared_when_matched VARCHAR2,
141 X_current_record_flag VARCHAR2,
142 X_auto_reconciled_flag VARCHAR2);
143
144 --
145 -- Procedure
146 -- Delete_Row
147 -- Purpose
148 -- Deletes a row from ce_statement_reconciliations
149 -- History
150 -- 04-08-95 Kai Pigg Created
151 -- Arguments
152 -- X_row_id Rowid of a row
153 -- Example
154 -- ce_statement_recons_pkg.delete_row('ajfdshj');
155 -- Notes
156 --
157 PROCEDURE Delete_Row(X_Row_id VARCHAR2);
158
159 END ce_statement_recons_pkg;