[Home] [Help]
PACKAGE: APPS.GL_BC_RULES_PKG
Source
1 PACKAGE GL_BC_RULES_PKG as
2 /* $Header: glibcrls.pls 120.3 2005/05/05 01:00:12 kvora ship $ */
3 --
4 -- Package
5 -- gl_bc_rules_pkg
6 -- Purpose
7 -- To contain validation, insertion, and update routines for gl_bc_rules
8 -- History
9 -- 09-12-94 Sharif Rahman Created
10
11 PROCEDURE check_unique_bc_rules( X_rowid VARCHAR2,
12 X_bc_option_id NUMBER,
13 X_je_source_name VARCHAR2,
14 X_je_category_name VARCHAR2 );
15
16 PROCEDURE insert_row(X_rowid IN OUT NOCOPY VARCHAR2 ,
17 X_bc_option_id NUMBER ,
18 X_last_update_date DATE ,
19 X_last_updated_by NUMBER ,
20 X_last_update_login NUMBER ,
21 X_je_source_name VARCHAR2 ,
22 X_je_category_name VARCHAR2 ,
23 X_funds_check_level_code VARCHAR2 ,
24 X_creation_date DATE ,
25 X_created_by NUMBER ,
26 X_override_amount NUMBER ,
27 X_tolerance_percentage NUMBER ,
28 X_tolerance_amount NUMBER ,
29 X_context VARCHAR2 ,
30 X_attribute1 VARCHAR2 ,
31 X_attribute2 VARCHAR2 ,
32 X_attribute3 VARCHAR2 ,
33 X_attribute4 VARCHAR2 ,
34 X_attribute5 VARCHAR2 ,
35 X_attribute6 VARCHAR2 ,
36 X_attribute7 VARCHAR2 ,
37 X_attribute8 VARCHAR2 ,
38 X_attribute9 VARCHAR2 ,
39 X_attribute10 VARCHAR2 ,
40 X_attribute11 VARCHAR2 ,
41 X_attribute12 VARCHAR2 ,
42 X_attribute13 VARCHAR2 ,
43 X_attribute14 VARCHAR2 ,
44 X_attribute15 VARCHAR2 );
45
46 PROCEDURE update_row(X_rowid IN OUT NOCOPY VARCHAR2 ,
47 X_bc_option_id NUMBER ,
48 X_last_update_date DATE ,
49 X_last_updated_by NUMBER ,
50 X_last_update_login NUMBER ,
51 X_je_source_name VARCHAR2 ,
52 X_je_category_name VARCHAR2 ,
53 X_funds_check_level_code VARCHAR2 ,
54 X_override_amount NUMBER ,
55 X_tolerance_percentage NUMBER ,
56 X_tolerance_amount NUMBER ,
57 X_context VARCHAR2 ,
58 X_attribute1 VARCHAR2 ,
59 X_attribute2 VARCHAR2 ,
60 X_attribute3 VARCHAR2 ,
61 X_attribute4 VARCHAR2 ,
62 X_attribute5 VARCHAR2 ,
63 X_attribute6 VARCHAR2 ,
64 X_attribute7 VARCHAR2 ,
65 X_attribute8 VARCHAR2 ,
66 X_attribute9 VARCHAR2 ,
67 X_attribute10 VARCHAR2 ,
68 X_attribute11 VARCHAR2 ,
69 X_attribute12 VARCHAR2 ,
70 X_attribute13 VARCHAR2 ,
71 X_attribute14 VARCHAR2 ,
72 X_attribute15 VARCHAR2 );
73
74 PROCEDURE lock_row ( X_rowid IN OUT NOCOPY VARCHAR2 ,
75 X_bc_option_id NUMBER ,
76 X_je_source_name VARCHAR2 ,
77 X_je_category_name VARCHAR2 ,
78 X_funds_check_level_code VARCHAR2 ,
79 X_override_amount NUMBER ,
80 X_tolerance_percentage NUMBER ,
81 X_tolerance_amount NUMBER ,
82 X_context VARCHAR2 ,
83 X_attribute1 VARCHAR2 ,
84 X_attribute2 VARCHAR2 ,
85 X_attribute3 VARCHAR2 ,
86 X_attribute4 VARCHAR2 ,
87 X_attribute5 VARCHAR2 ,
88 X_attribute6 VARCHAR2 ,
89 X_attribute7 VARCHAR2 ,
90 X_attribute8 VARCHAR2 ,
91 X_attribute9 VARCHAR2 ,
92 X_attribute10 VARCHAR2 ,
93 X_attribute11 VARCHAR2 ,
94 X_attribute12 VARCHAR2 ,
95 X_attribute13 VARCHAR2 ,
96 X_attribute14 VARCHAR2 ,
97 X_attribute15 VARCHAR2 );
98
99 PROCEDURE delete_row(X_rowid VARCHAR2);
100
101 FUNCTION default_source_name RETURN VARCHAR2;
102
103 FUNCTION default_category_name RETURN VARCHAR2;
104
105 END GL_BC_RULES_PKG;