APPS.JL_ZZ_AR_TX_RULES_PKG dependencies on JL_ZZ_AR_TX_RULES

Line 1: PACKAGE BODY JL_ZZ_AR_TX_RULES_PKG AS

1: PACKAGE BODY JL_ZZ_AR_TX_RULES_PKG AS
2: /* $Header: jlzztxrb.pls 120.2 2003/03/03 19:39:38 opedrega ship $ */
3:
4: PROCEDURE Insert_Row
5: (X_rowid IN OUT NOCOPY VARCHAR2,

Line 24: FROM jl_zz_ar_tx_rules

20: X_calling_sequence IN VARCHAR2) IS
21:
22: CURSOR C IS
23: SELECT rowid
24: FROM jl_zz_ar_tx_rules
25: WHERE rule = X_rule
26: AND tax_rule_level = X_tax_rule_level
27: AND tax_category_id = X_tax_category_id
28: AND contributor_type = X_contributor_type

Line 39: current_calling_sequence := 'JL_ZZ_AR_TX_RULES_PKG.INSERT_ROW<-' ||

35:
36: BEGIN
37: -- Update the calling sequence
38: --
39: current_calling_sequence := 'JL_ZZ_AR_TX_RULES_PKG.INSERT_ROW<-' ||
40: X_calling_sequence;
41:
42: debug_info := 'Insert into JL_ZZ_AR_TX_RULES ';
43: INSERT INTO JL_ZZ_AR_TX_RULES(rule_id,

Line 42: debug_info := 'Insert into JL_ZZ_AR_TX_RULES ';

38: --
39: current_calling_sequence := 'JL_ZZ_AR_TX_RULES_PKG.INSERT_ROW<-' ||
40: X_calling_sequence;
41:
42: debug_info := 'Insert into JL_ZZ_AR_TX_RULES ';
43: INSERT INTO JL_ZZ_AR_TX_RULES(rule_id,
44: tax_rule_level,
45: rule,
46: tax_category_id,

Line 43: INSERT INTO JL_ZZ_AR_TX_RULES(rule_id,

39: current_calling_sequence := 'JL_ZZ_AR_TX_RULES_PKG.INSERT_ROW<-' ||
40: X_calling_sequence;
41:
42: debug_info := 'Insert into JL_ZZ_AR_TX_RULES ';
43: INSERT INTO JL_ZZ_AR_TX_RULES(rule_id,
44: tax_rule_level,
45: rule,
46: tax_category_id,
47: contributor_type,

Line 123: FROM jl_zz_ar_tx_rules

119: X_calling_sequence IN VARCHAR2) IS
120:
121: CURSOR C IS
122: SELECT *
123: FROM jl_zz_ar_tx_rules
124: WHERE rule = X_rule
125: AND tax_rule_level = X_tax_rule_level
126: AND tax_category_id = X_tax_category_id
127: AND contributor_type = X_contributor_type

Line 147: current_calling_sequence := 'JL_ZZ_AR_TX_RULES_PKG.LOCK_ROW<-' ||

143:
144: BEGIN
145: -- Update the calling sequence
146: --
147: current_calling_sequence := 'JL_ZZ_AR_TX_RULES_PKG.LOCK_ROW<-' ||
148: X_calling_sequence;
149: debug_info := 'Open cursor C';
150: OPEN C;
151: debug_info := 'Fetch cursor C';

Line 231: UPDATE jl_zz_ar_tx_rules

227: X_created_by NUMBER,
228: X_calling_sequence IN VARCHAR2) IS
229:
230: BEGIN
231: UPDATE jl_zz_ar_tx_rules
232: SET rule_id = X_rule_id,
233: tax_rule_level = X_tax_rule_level,
234: rule = X_rule,
235: tax_category_id = X_tax_category_id,

Line 258: FROM jl_zz_ar_tx_rules

254: (X_rowid VARCHAR2) IS
255:
256: BEGIN
257: DELETE
258: FROM jl_zz_ar_tx_rules
259: WHERE rowid = X_rowid;
260:
261: IF (SQL%NOTFOUND) THEN
262: raise NO_DATA_FOUND;

Line 266: END JL_ZZ_AR_TX_RULES_PKG;

262: raise NO_DATA_FOUND;
263: END IF;
264: END Delete_Row;
265:
266: END JL_ZZ_AR_TX_RULES_PKG;