[Home] [Help]
PACKAGE: APPS.HZ_CREDIT_USAGE_RULES_PKG
Source
1 PACKAGE HZ_CREDIT_USAGE_RULES_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARHCRURS.pls 115.4 2003/08/18 17:52:04 rajkrish ship $ */
3
4 --======================================================================
5 --CONSTANTS
6 --======================================================================
7 G_PKG_NAME CONSTANT VARCHAR2(30) :='HZ_CREDIT_USAGE_RULES_PKG';
8
9 ---------------------------
10 -- PROCEDURES AND FUNCTIONS
11 ---------------------------
12
13 --========================================================================
14 -- PROCEDURE : Insert_row PUBLIC
15 -- PARAMETERS: p_row_id ROWID of the current record
16 -- p_credit_usage_rule_set_id rule set id
17 -- p_credit_usage_rule_id primary key
18 -- p_usage_type usage type
19 -- p_user_code user code=currency_code
20 -- p_exclude_flag exclude_flag = Y/N
21 -- p_include_all_flag include all currencies Y/N
22 -- p_creation_date date, when a record was inserted
23 -- p_created_by userid of the person,who inserted
24 -- a record
25 -- COMMENT : Procedure inserts record into the table HZ_CREDIT_USAGE_RULES
26 --========================================================================
27 PROCEDURE Insert_row
28 ( p_row_id IN OUT NOCOPY VARCHAR2
29 , p_credit_usage_rule_set_id NUMBER
30 , p_credit_usage_rule_id NUMBER
31 , p_usage_type VARCHAR2
32 , p_user_code VARCHAR2
33 , p_exclude_flag VARCHAR2
34 , p_include_all_flag VARCHAR2
35 , p_creation_date DATE
36 , p_created_by NUMBER
37 , p_last_update_date DATE
38 , p_last_updated_by NUMBER
39 , p_last_update_login NUMBER
40 , p_attribute_category VARCHAR2
41 , p_attribute1 VARCHAR2
42 , p_attribute2 VARCHAR2
43 , p_attribute3 VARCHAR2
44 , p_attribute4 VARCHAR2
45 , p_attribute5 VARCHAR2
46 , p_attribute6 VARCHAR2
47 , p_attribute7 VARCHAR2
48 , p_attribute8 VARCHAR2
49 , p_attribute9 VARCHAR2
50 , p_attribute10 VARCHAR2
51 , p_attribute11 VARCHAR2
52 , p_attribute12 VARCHAR2
53 , p_attribute13 VARCHAR2
54 , p_attribute14 VARCHAR2
55 , p_attribute15 VARCHAR2
56 );
57
58
59 --========================================================================
60 -- PROCEDURE : Lock_row PUBLIC
61 -- PARAMETERS: p_row_id ROWID of the current record
62 -- p_usage_type usage type
63 -- p_user_code user code=currency_code
64 -- p_exclude_flag exclude_flag = Y/N
65 -- p_include_all_flag include all currencies Y/N
66 -- COMMENT : Procedure locks current record in the table HZ_CREDIT_USAGE_RULES.
67 --========================================================================
68 PROCEDURE Lock_row
69 ( p_row_id VARCHAR2
70 , p_usage_type VARCHAR2
71 , p_user_code VARCHAR2
72 , p_exclude_flag VARCHAR2
73 , p_include_all_flag VARCHAR2
74 );
75
76
77 --========================================================================
78 -- PROCEDURE : Update_row PUBLIC
79 -- PARAMETERS: p_row_id ROWID of the current record
80 -- p_usage_type usage type
81 -- p_user_code user code=currency_code
82 -- p_exclude_flag exclude_flag = Y/N
83 -- p_include_all_flag include all currencies Y/N
84 -- p_last_update_date date,when the record was updated
85 -- p_last_updated_by userid of the person,who updated the record
86 -- COMMENT : Procedure updates columns in the table HZ_CREDIT_USAGE_RULES
87 -- for the record with ROWID,passed as a parameter p_row_id.
88 --========================================================================
89 PROCEDURE Update_row
90 ( p_row_id VARCHAR2
91 , p_usage_type VARCHAR2
92 , p_user_code VARCHAR2
93 , p_exclude_flag VARCHAR2
94 , p_include_all_flag VARCHAR2
95 , p_last_update_date DATE
96 , p_last_updated_by NUMBER
97 , p_attribute_category VARCHAR2
98 , p_attribute1 VARCHAR2
99 , p_attribute2 VARCHAR2
100 , p_attribute3 VARCHAR2
101 , p_attribute4 VARCHAR2
102 , p_attribute5 VARCHAR2
103 , p_attribute6 VARCHAR2
104 , p_attribute7 VARCHAR2
105 , p_attribute8 VARCHAR2
106 , p_attribute9 VARCHAR2
107 , p_attribute10 VARCHAR2
108 , p_attribute11 VARCHAR2
109 , p_attribute12 VARCHAR2
110 , p_attribute13 VARCHAR2
111 , p_attribute14 VARCHAR2
112 , p_attribute15 VARCHAR2
113 );
114
115
116 --========================================================================
117 -- PROCEDURE : Delete_row PUBLIC
118 -- PARAMETERS: p_credit_usage_rule_id credit_usage_rule_id
119 -- COMMENT : Procedure deletes record with credit_usage_rule_id from the
120 -- table HZ_CREDIT_USAGE_RULES.
121 --========================================================================
122 PROCEDURE Delete_row
123 ( p_credit_usage_rule_id NUMBER
124 );
125
126 END HZ_CREDIT_USAGE_RULES_PKG;