APPS.FUN_RULE_DETAILS_PKG dependencies on FUN_RULE_DETAILS

Line 1: PACKAGE BODY FUN_RULE_DETAILS_PKG AS

1: PACKAGE BODY FUN_RULE_DETAILS_PKG AS
2: /*$Header: FUNXTMRULRDTTBB.pls 120.1 2005/12/05 12:32:13 ammishra noship $ */
3:
4: PROCEDURE Insert_Row (
5: X_ROWID IN OUT NOCOPY VARCHAR2,

Line 19: INSERT INTO FUN_RULE_DETAILS (

15: ) IS
16:
17: BEGIN
18:
19: INSERT INTO FUN_RULE_DETAILS (
20: RULE_DETAIL_ID,
21: RULE_OBJECT_ID,
22: RULE_NAME,
23: SEQ,

Line 37: NVL(X_RULE_DETAIL_ID,FUN_RULE_DETAILS_S.NEXTVAL),

33: OBJECT_VERSION_NUMBER,
34: CREATED_BY_MODULE
35: )
36: VALUES (
37: NVL(X_RULE_DETAIL_ID,FUN_RULE_DETAILS_S.NEXTVAL),
38: X_RULE_OBJECT_ID,
39: X_RULE_NAME,
40: NVL(FUN_RULE_UTILITY_PKG.GET_MAX_SEQ(X_RULE_OBJECT_ID),1),
41: X_OPERATOR,

Line 71: UPDATE FUN_RULE_DETAILS SET

67:
68: X_ROWID VARCHAR2(200);
69: BEGIN
70:
71: UPDATE FUN_RULE_DETAILS SET
72: RULE_NAME = X_RULE_NAME,
73: SEQ = X_SEQ,
74: OPERATOR = X_OPERATOR,
75: ENABLED_FLAG = X_ENABLED_FLAG,

Line 99: SELECT OBJECT_VERSION_NUMBER FROM FUN_RULE_DETAILS

95: X_OBJECT_VERSION_NUMBER IN NUMBER
96: ) IS
97:
98: CURSOR C IS
99: SELECT OBJECT_VERSION_NUMBER FROM FUN_RULE_DETAILS
100: WHERE RULE_DETAIL_ID = X_RULE_DETAIL_ID
101: FOR UPDATE NOWAIT;
102: Recinfo C%ROWTYPE;
103:

Line 158: FROM FUN_RULE_DETAILS

154: X_ENABLED_FLAG,
155: X_RESULT_APPLICATION_ID,
156: X_RESULT_VALUE,
157: X_CREATED_BY_MODULE
158: FROM FUN_RULE_DETAILS
159: WHERE RULE_DETAIL_ID = X_RULE_DETAIL_ID;
160:
161: EXCEPTION
162: WHEN NO_DATA_FOUND THEN

Line 176: DELETE FUN_RULE_DETAILS

172: ) IS
173:
174: BEGIN
175:
176: DELETE FUN_RULE_DETAILS
177: WHERE RULE_DETAIL_ID = X_RULE_DETAIL_ID;
178:
179: IF ( SQL%NOTFOUND ) THEN
180: RAISE NO_DATA_FOUND;

Line 186: END FUN_RULE_DETAILS_PKG;

182:
183:
184: END Delete_Row;
185:
186: END FUN_RULE_DETAILS_PKG;