APPS.HZ_MATCH_RULE_SECONDARY_PKG dependencies on HZ_MATCH_RULE_SECONDARY

Line 1: PACKAGE BODY HZ_MATCH_RULE_SECONDARY_PKG AS

1: PACKAGE BODY HZ_MATCH_RULE_SECONDARY_PKG AS
2: /*$Header: ARHDQMSB.pls 120.6 2005/10/30 04:19:12 appldev noship $ */
3: PROCEDURE Insert_Row(
4: px_SECONDARY_ATTRIBUTE_ID IN OUT NOCOPY NUMBER,
5: p_MATCH_RULE_ID NUMBER,

Line 17: CURSOR C2 IS SELECT HZ_MATCH_RULE_SECONDARY_s.nextval FROM sys.dual;

13: p_LAST_UPDATED_BY NUMBER,
14: p_OBJECT_VERSION_NUMBER NUMBER,
15: p_DISPLAY_ORDER NUMBER DEFAULT NULL)
16: IS
17: CURSOR C2 IS SELECT HZ_MATCH_RULE_SECONDARY_s.nextval FROM sys.dual;
18: l_success VARCHAR2(1) ;
19:
20: BEGIN
21: l_success := 'N';

Line 30: INSERT INTO HZ_MATCH_RULE_SECONDARY(

26: FETCH C2 INTO px_SECONDARY_ATTRIBUTE_ID;
27: CLOSE C2;
28: END IF;
29:
30: INSERT INTO HZ_MATCH_RULE_SECONDARY(
31: SECONDARY_ATTRIBUTE_ID,
32: MATCH_RULE_ID,
33: ATTRIBUTE_ID,
34: SCORE,

Line 61: IF INSTRB( SQLERRM, 'HZ_MATCH_RULE_SECONDARY_U1' ) <> 0 THEN

57: );
58:
59: l_success := 'Y';
60: EXCEPTION WHEN DUP_VAL_ON_INDEX THEN
61: IF INSTRB( SQLERRM, 'HZ_MATCH_RULE_SECONDARY_U1' ) <> 0 THEN
62: DECLARE
63: l_count NUMBER;
64: l_dummy VARCHAR2(1);
65: BEGIN

Line 68: SELECT HZ_MATCH_RULE_SECONDARY_s.nextval

64: l_dummy VARCHAR2(1);
65: BEGIN
66: l_count := 1;
67: WHILE l_count > 0 LOOP
68: SELECT HZ_MATCH_RULE_SECONDARY_s.nextval
69: into px_SECONDARY_ATTRIBUTE_ID FROM sys.dual;
70: BEGIN
71: SELECT 'Y' INTO l_dummy
72: FROM HZ_MATCH_RULE_SECONDARY

Line 72: FROM HZ_MATCH_RULE_SECONDARY

68: SELECT HZ_MATCH_RULE_SECONDARY_s.nextval
69: into px_SECONDARY_ATTRIBUTE_ID FROM sys.dual;
70: BEGIN
71: SELECT 'Y' INTO l_dummy
72: FROM HZ_MATCH_RULE_SECONDARY
73: WHERE SECONDARY_ATTRIBUTE_ID = px_SECONDARY_ATTRIBUTE_ID;
74: l_count := 1;
75: EXCEPTION WHEN NO_DATA_FOUND THEN
76: l_count := 0;

Line 107: UPDATE hz_match_rule_SECONDARY

103: BEGIN
104:
105: l_object_version_number := NVL(p_object_version_number, 1) + 1;
106:
107: UPDATE hz_match_rule_SECONDARY
108: SET
109: MATCH_RULE_ID = decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),
110: ATTRIBUTE_ID = decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
111: SCORE = decode(p_SCORE, FND_API.G_MISS_CHAR, NULL, p_SCORE),

Line 134: DELETE FROM HZ_MATCH_RULE_SECONDARY

130: END Update_Row;
131:
132: PROCEDURE Delete_Row(p_SECONDARY_attribute_id NUMBER) IS
133: BEGIN
134: DELETE FROM HZ_MATCH_RULE_SECONDARY
135: WHERE SECONDARY_attribute_id = p_SECONDARY_attribute_id;
136:
137: If (SQL%NOTFOUND) then
138: RAISE NO_DATA_FOUND;

Line 149: FROM hz_match_rule_SECONDARY

145: ) IS
146: CURSOR C IS
147:
148: SELECT OBJECT_VERSION_NUMBER
149: FROM hz_match_rule_SECONDARY
150: WHERE SECONDARY_attribute_id = p_SECONDARY_attribute_id
151: FOR UPDATE OF SECONDARY_attribute_id NOWAIT;
152: Recinfo C%ROWTYPE;
153: BEGIN

Line 177: END HZ_MATCH_RULE_SECONDARY_PKG;

173: End If;
174:
175: END Lock_Row;
176:
177: END HZ_MATCH_RULE_SECONDARY_PKG;