APPS.HZ_MATCH_RULES_PKG dependencies on HZ_MATCH_RULES_B

Line 39: insert into HZ_MATCH_RULES_B (

35: FETCH C2 INTO X_MATCH_RULE_ID;
36: CLOSE C2;
37: END IF;
38:
39: insert into HZ_MATCH_RULES_B (
40: RULE_PURPOSE,
41: MATCH_ALL_FLAG,
42: ACTIVE_FLAG,
43: NO_OVERRIDE_SCORE,

Line 82: IF INSTRB( SQLERRM, 'HZ_MATCH_RULES_B_U1' ) <> 0 THEN

78:
79:
80: l_success := 'Y';
81: EXCEPTION WHEN DUP_VAL_ON_INDEX THEN
82: IF INSTRB( SQLERRM, 'HZ_MATCH_RULES_B_U1' ) <> 0 THEN
83: DECLARE
84: l_count NUMBER;
85: l_dummy VARCHAR2(1);
86: BEGIN

Line 93: FROM HZ_MATCH_RULES_B

89: SELECT HZ_MATCH_RULES_s.nextval
90: into X_MATCH_RULE_ID FROM sys.dual;
91: BEGIN
92: SELECT 'Y' INTO l_dummy
93: FROM HZ_MATCH_RULES_B
94: WHERE MATCH_RULE_ID = X_MATCH_RULE_ID;
95: l_count := 1;
96: EXCEPTION WHEN NO_DATA_FOUND THEN
97: l_count := 0;

Line 175: from HZ_MATCH_RULES_B

171: X_OBJECT_VERSION_NUMBER IN NUMBER
172: ) is
173: cursor c is select
174: OBJECT_VERSION_NUMBER
175: from HZ_MATCH_RULES_B
176: where MATCH_RULE_ID = X_MATCH_RULE_ID
177: for update of MATCH_RULE_ID nowait;
178: recinfo c%rowtype;
179:

Line 209: UPDATE HZ_MATCH_RULES_B

205: PROCEDURE uncompile_match_rule_sets(p_rule_id NUMBER)
206: IS
207:
208: BEGIN
209: UPDATE HZ_MATCH_RULES_B
210: SET COMPILATION_FLAG = 'U'
211: WHERE MATCH_RULE_ID IN (SELECT DISTINCT MATCH_RULE_SET_ID
212: FROM HZ_MATCH_RULE_CONDITIONS
213: WHERE CONDITION_MATCH_RULE_ID = p_rule_id

Line 244: update HZ_MATCH_RULES_B set

240: begin
241:
242: p_object_version_number := NVL(X_object_version_number, 1) + 1;
243:
244: update HZ_MATCH_RULES_B set
245: RULE_PURPOSE = X_RULE_PURPOSE,
246: MATCH_ALL_FLAG = X_MATCH_ALL_FLAG,
247: ACTIVE_FLAG = X_ACTIVE_FLAG,
248: NO_OVERRIDE_SCORE = X_NO_OVERRIDE_SCORE,

Line 319: delete from HZ_MATCH_RULES_B

315: if (sql%notfound) then
316: raise no_data_found;
317: end if;
318:
319: delete from HZ_MATCH_RULES_B
320: where MATCH_RULE_ID = X_MATCH_RULE_ID;
321:
322: if (sql%notfound) then
323: raise no_data_found;

Line 333: from HZ_MATCH_RULES_B B

329: begin
330: delete from HZ_MATCH_RULES_TL T
331: where not exists
332: (select NULL
333: from HZ_MATCH_RULES_B B
334: where B.MATCH_RULE_ID = T.MATCH_RULE_ID
335: );
336:
337: update HZ_MATCH_RULES_TL T set (