APPS.HZ_CREDIT_USAGE_RULES_PKG dependencies on HZ_CREDIT_USAGE_RULES

Line 1: PACKAGE BODY HZ_CREDIT_USAGE_RULES_PKG AS

1: PACKAGE BODY HZ_CREDIT_USAGE_RULES_PKG AS
2: /* $Header: ARHCRURB.pls 115.5 2003/08/18 17:51:43 rajkrish ship $ */
3:
4:
5: ---------------------------

Line 21: -- COMMENT : Procedure inserts record into the table HZ_CREDIT_USAGE_RULES

17: -- p_include_all_flag include all currencies Y/N
18: -- p_creation_date date, when a record was inserted
19: -- p_created_by userid of the person,who inserted
20: -- a record
21: -- COMMENT : Procedure inserts record into the table HZ_CREDIT_USAGE_RULES
22: --========================================================================
23: PROCEDURE Insert_row
24: ( p_row_id IN OUT NOCOPY VARCHAR2
25: , p_credit_usage_rule_set_id NUMBER

Line 59: HZ_CREDIT_USAGE_RULES

55: CURSOR usage_rule_csr IS
56: SELECT
57: rowid
58: FROM
59: HZ_CREDIT_USAGE_RULES
60: WHERE credit_usage_rule_id=p_credit_usage_rule_id;
61:
62: BEGIN
63:

Line 64: INSERT INTO hz_credit_usage_rules

60: WHERE credit_usage_rule_id=p_credit_usage_rule_id;
61:
62: BEGIN
63:
64: INSERT INTO hz_credit_usage_rules
65: ( credit_usage_rule_id
66: , usage_type
67: , user_code
68: , exclude_flag

Line 157: -- COMMENT : Procedure locks current record in the table HZ_CREDIT_USAGE_RULES.

153: -- p_usage_type usage type
154: -- p_user_code user code=currency_code
155: -- p_exclude_flag exclude_flag = Y/N
156: -- p_include_all_flag include all currencies Y/N
157: -- COMMENT : Procedure locks current record in the table HZ_CREDIT_USAGE_RULES.
158: --========================================================================
159: PROCEDURE Lock_row
160: ( p_row_id VARCHAR2
161: , p_usage_type VARCHAR2

Line 170: FROM HZ_CREDIT_USAGE_RULES

166: IS
167: CURSOR usage_rule_csr
168: IS
169: SELECT *
170: FROM HZ_CREDIT_USAGE_RULES
171: WHERE ROWID=CHARTOROWID(p_row_id)
172: FOR UPDATE OF user_code NOWAIT;
173:
174: recinfo usage_rule_csr%ROWTYPE;

Line 219: -- COMMENT : Procedure updates columns in the table HZ_CREDIT_USAGE_RULES

215: -- p_exclude_flag exclude_flag = Y/N
216: -- p_include_all_flag include all currencies Y/N
217: -- p_last_update_date date,when the record was updated
218: -- p_last_updated_by userid of the person,who updated the record
219: -- COMMENT : Procedure updates columns in the table HZ_CREDIT_USAGE_RULES
220: -- for the record with ROWID,passed as a parameter p_row_id.
221: --========================================================================
222: PROCEDURE Update_row
223: ( p_row_id VARCHAR2

Line 250: UPDATE HZ_CREDIT_USAGE_RULES

246: )
247: IS
248:
249: BEGIN
250: UPDATE HZ_CREDIT_USAGE_RULES
251: SET
252: usage_type=p_usage_type
253: ,user_code=p_user_code
254: ,exclude_flag=p_exclude_flag

Line 295: -- table HZ_CREDIT_USAGE_RULES.

291: --========================================================================
292: -- PROCEDURE : Delete_row PUBLIC
293: -- PARAMETERS: p_credit_usage_rule_id credit_usage_rule_id
294: -- COMMENT : Procedure deletes record with credit_usage_rule_id from the
295: -- table HZ_CREDIT_USAGE_RULES.
296: --========================================================================
297: PROCEDURE Delete_row
298: ( p_credit_usage_rule_id NUMBER
299: )

Line 303: FROM HZ_CREDIT_USAGE_RULES

299: )
300: IS
301: BEGIN
302: DELETE
303: FROM HZ_CREDIT_USAGE_RULES
304: WHERE credit_usage_rule_id=p_credit_usage_rule_id;
305:
306: IF (SQL%NOTFOUND)
307: THEN

Line 320: END HZ_CREDIT_USAGE_RULES_PKG;

316: RAISE;
317:
318: END Delete_row;
319:
320: END HZ_CREDIT_USAGE_RULES_PKG;