APPS.HZ_MATCH_RULE_CONDITIONS_PKG dependencies on HZ_MATCH_RULE_CONDITIONS

Line 1: PACKAGE BODY HZ_MATCH_RULE_CONDITIONS_PKG AS

1: PACKAGE BODY HZ_MATCH_RULE_CONDITIONS_PKG AS
2: /*$Header: ARHMSCTB.pls 120.0 2005/05/25 21:08:58 achung noship $ */
3:
4: PROCEDURE Insert_Row (
5: X_MATCH_RULE_SET_CONDITION_ID IN OUT NOCOPY NUMBER,

Line 19: INSERT INTO HZ_MATCH_RULE_CONDITIONS(

15: X_APPLICATION_ID IN NUMBER
16: ) IS
17:
18: BEGIN
19: INSERT INTO HZ_MATCH_RULE_CONDITIONS(
20: MATCH_RULE_SET_CONDITION_ID,
21: MATCH_RULE_SET_ID,
22: CONDITION_MATCH_RULE_ID,
23: ATTRIBUTE_ID,

Line 41: (DECODE(X_MATCH_RULE_SET_CONDITION_ID, FND_API.G_MISS_NUM, HZ_MATCH_RULE_CONDITIONS_S.NEXTVAL, NULL,

37: OBJECT_VERSION_NUMBER,
38: CREATED_BY_MODULE,
39: APPLICATION_ID )
40: VALUES
41: (DECODE(X_MATCH_RULE_SET_CONDITION_ID, FND_API.G_MISS_NUM, HZ_MATCH_RULE_CONDITIONS_S.NEXTVAL, NULL,
42: HZ_MATCH_RULE_CONDITIONS_S.NEXTVAL, X_MATCH_RULE_SET_CONDITION_ID ),
43: DECODE(X_MATCH_RULE_SET_ID, FND_API.G_MISS_NUM, NULL,X_MATCH_RULE_SET_ID),
44: DECODE(X_CONDITION_MATCH_RULE_ID,FND_API.G_MISS_NUM,NULL,X_CONDITION_MATCH_RULE_ID ),
45: DECODE(X_ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,X_ATTRIBUTE_ID ),

Line 42: HZ_MATCH_RULE_CONDITIONS_S.NEXTVAL, X_MATCH_RULE_SET_CONDITION_ID ),

38: CREATED_BY_MODULE,
39: APPLICATION_ID )
40: VALUES
41: (DECODE(X_MATCH_RULE_SET_CONDITION_ID, FND_API.G_MISS_NUM, HZ_MATCH_RULE_CONDITIONS_S.NEXTVAL, NULL,
42: HZ_MATCH_RULE_CONDITIONS_S.NEXTVAL, X_MATCH_RULE_SET_CONDITION_ID ),
43: DECODE(X_MATCH_RULE_SET_ID, FND_API.G_MISS_NUM, NULL,X_MATCH_RULE_SET_ID),
44: DECODE(X_CONDITION_MATCH_RULE_ID,FND_API.G_MISS_NUM,NULL,X_CONDITION_MATCH_RULE_ID ),
45: DECODE(X_ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,X_ATTRIBUTE_ID ),
46: DECODE(X_OPERATION,FND_API.G_MISS_CHAR,NULL,X_OPERATION),

Line 82: UPDATE HZ_MATCH_RULE_CONDITIONS SET

78: X_CREATED_BY_MODULE IN VARCHAR2,
79: X_APPLICATION_ID IN NUMBER
80: ) IS
81: BEGIN
82: UPDATE HZ_MATCH_RULE_CONDITIONS SET
83: /*MATCH_RULE_SET_ID = DECODE( X_MATCH_RULE_SET_ID, NULL, MATCH_RULE_SET_ID,FND_API.G_MISS_NUM,
84: NULL,MATCH_RULE_SET_ID),
85: */
86: CONDITION_MATCH_RULE_ID = DECODE(X_CONDITION_MATCH_RULE_ID,NULL,CONDITION_MATCH_RULE_ID,

Line 118: FROM HZ_MATCH_RULE_CONDITIONS

114: X_MATCH_RULE_SET_CONDITION_ID IN NUMBER,
115: X_OBJECT_VERSION_NUMBER IN NUMBER
116: ) IS
117: CURSOR C IS SELECT OBJECT_VERSION_NUMBER
118: FROM HZ_MATCH_RULE_CONDITIONS
119: WHERE MATCH_RULE_SET_CONDITION_ID = X_MATCH_RULE_SET_CONDITION_ID
120: FOR UPDATE OF MATCH_RULE_SET_CONDITION_ID NOWAIT;
121: RECINFO C%ROWTYPE;
122:

Line 150: DELETE FROM HZ_MATCH_RULE_CONDITIONS

146: PROCEDURE DELETE_ROW (
147: X_MATCH_RULE_SET_CONDITION_ID in NUMBER
148: ) IS
149: BEGIN
150: DELETE FROM HZ_MATCH_RULE_CONDITIONS
151: WHERE MATCH_RULE_SET_CONDITION_ID = X_MATCH_RULE_SET_CONDITION_ID;
152:
153: IF (SQL%NOTFOUND) THEN
154: RAISE NO_DATA_FOUND;

Line 158: END HZ_MATCH_RULE_CONDITIONS_PKG;

154: RAISE NO_DATA_FOUND;
155: END IF;
156: END DELETE_ROW;
157:
158: END HZ_MATCH_RULE_CONDITIONS_PKG;
159:
160: