eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_RULE_CRITERIA_PKG dependencies on FND_API

Line 34: DECODE( X_RULE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, X_RULE_DETAIL_ID ),

30: CREATED_BY_MODULE
31: )
32: VALUES (
33: DECODE( X_CRITERIA_ID, NULL , FUN_RULE_CRITERIA_S.NEXTVAL , X_CRITERIA_ID),
34: DECODE( X_RULE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, X_RULE_DETAIL_ID ),
35: DECODE( X_CRITERIA_PARAM_ID, FND_API.G_MISS_NUM, NULL, X_CRITERIA_PARAM_ID ),
36: DECODE( X_CONDITION, FND_API.G_MISS_CHAR, NULL, X_CONDITION ),
37: DECODE( X_PARAM_VALUE, FND_API.G_MISS_CHAR, NULL, X_PARAM_VALUE ),
38: DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, X_CASE_SENSITIVE_FLAG ),

Line 35: DECODE( X_CRITERIA_PARAM_ID, FND_API.G_MISS_NUM, NULL, X_CRITERIA_PARAM_ID ),

31: )
32: VALUES (
33: DECODE( X_CRITERIA_ID, NULL , FUN_RULE_CRITERIA_S.NEXTVAL , X_CRITERIA_ID),
34: DECODE( X_RULE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, X_RULE_DETAIL_ID ),
35: DECODE( X_CRITERIA_PARAM_ID, FND_API.G_MISS_NUM, NULL, X_CRITERIA_PARAM_ID ),
36: DECODE( X_CONDITION, FND_API.G_MISS_CHAR, NULL, X_CONDITION ),
37: DECODE( X_PARAM_VALUE, FND_API.G_MISS_CHAR, NULL, X_PARAM_VALUE ),
38: DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, X_CASE_SENSITIVE_FLAG ),
39: FUN_RULE_UTILITY_PKG.CREATED_BY,

Line 36: DECODE( X_CONDITION, FND_API.G_MISS_CHAR, NULL, X_CONDITION ),

32: VALUES (
33: DECODE( X_CRITERIA_ID, NULL , FUN_RULE_CRITERIA_S.NEXTVAL , X_CRITERIA_ID),
34: DECODE( X_RULE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, X_RULE_DETAIL_ID ),
35: DECODE( X_CRITERIA_PARAM_ID, FND_API.G_MISS_NUM, NULL, X_CRITERIA_PARAM_ID ),
36: DECODE( X_CONDITION, FND_API.G_MISS_CHAR, NULL, X_CONDITION ),
37: DECODE( X_PARAM_VALUE, FND_API.G_MISS_CHAR, NULL, X_PARAM_VALUE ),
38: DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, X_CASE_SENSITIVE_FLAG ),
39: FUN_RULE_UTILITY_PKG.CREATED_BY,
40: FUN_RULE_UTILITY_PKG.CREATION_DATE,

Line 37: DECODE( X_PARAM_VALUE, FND_API.G_MISS_CHAR, NULL, X_PARAM_VALUE ),

33: DECODE( X_CRITERIA_ID, NULL , FUN_RULE_CRITERIA_S.NEXTVAL , X_CRITERIA_ID),
34: DECODE( X_RULE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, X_RULE_DETAIL_ID ),
35: DECODE( X_CRITERIA_PARAM_ID, FND_API.G_MISS_NUM, NULL, X_CRITERIA_PARAM_ID ),
36: DECODE( X_CONDITION, FND_API.G_MISS_CHAR, NULL, X_CONDITION ),
37: DECODE( X_PARAM_VALUE, FND_API.G_MISS_CHAR, NULL, X_PARAM_VALUE ),
38: DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, X_CASE_SENSITIVE_FLAG ),
39: FUN_RULE_UTILITY_PKG.CREATED_BY,
40: FUN_RULE_UTILITY_PKG.CREATION_DATE,
41: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,

Line 38: DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, X_CASE_SENSITIVE_FLAG ),

34: DECODE( X_RULE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, X_RULE_DETAIL_ID ),
35: DECODE( X_CRITERIA_PARAM_ID, FND_API.G_MISS_NUM, NULL, X_CRITERIA_PARAM_ID ),
36: DECODE( X_CONDITION, FND_API.G_MISS_CHAR, NULL, X_CONDITION ),
37: DECODE( X_PARAM_VALUE, FND_API.G_MISS_CHAR, NULL, X_PARAM_VALUE ),
38: DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, X_CASE_SENSITIVE_FLAG ),
39: FUN_RULE_UTILITY_PKG.CREATED_BY,
40: FUN_RULE_UTILITY_PKG.CREATION_DATE,
41: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
42: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,

Line 45: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE )

41: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
42: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
43: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
44: 1,
45: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE )
46: )RETURNING ROWID INTO X_ROWID;
47:
48: END Insert_Row;
49:

Line 63: CRITERIA_PARAM_ID = DECODE( X_CRITERIA_PARAM_ID, FND_API.G_MISS_CHAR, NULL, NULL,CRITERIA_PARAM_ID, X_CRITERIA_PARAM_ID ),

59:
60: BEGIN
61:
62: UPDATE FUN_RULE_CRITERIA SET
63: CRITERIA_PARAM_ID = DECODE( X_CRITERIA_PARAM_ID, FND_API.G_MISS_CHAR, NULL, NULL,CRITERIA_PARAM_ID, X_CRITERIA_PARAM_ID ),
64: CONDITION = X_CONDITION,
65:
66: --Param Value can be NULL, we should not overwrite the value with old value if its not null.
67: PARAM_VALUE = DECODE( X_PARAM_VALUE, FND_API.G_MISS_CHAR, NULL, X_PARAM_VALUE ),

Line 67: PARAM_VALUE = DECODE( X_PARAM_VALUE, FND_API.G_MISS_CHAR, NULL, X_PARAM_VALUE ),

63: CRITERIA_PARAM_ID = DECODE( X_CRITERIA_PARAM_ID, FND_API.G_MISS_CHAR, NULL, NULL,CRITERIA_PARAM_ID, X_CRITERIA_PARAM_ID ),
64: CONDITION = X_CONDITION,
65:
66: --Param Value can be NULL, we should not overwrite the value with old value if its not null.
67: PARAM_VALUE = DECODE( X_PARAM_VALUE, FND_API.G_MISS_CHAR, NULL, X_PARAM_VALUE ),
68:
69: CASE_SENSITIVE_FLAG = DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL,CASE_SENSITIVE_FLAG, X_CASE_SENSITIVE_FLAG ),
70: CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY,
71: CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE,

Line 69: CASE_SENSITIVE_FLAG = DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL,CASE_SENSITIVE_FLAG, X_CASE_SENSITIVE_FLAG ),

65:
66: --Param Value can be NULL, we should not overwrite the value with old value if its not null.
67: PARAM_VALUE = DECODE( X_PARAM_VALUE, FND_API.G_MISS_CHAR, NULL, X_PARAM_VALUE ),
68:
69: CASE_SENSITIVE_FLAG = DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL,CASE_SENSITIVE_FLAG, X_CASE_SENSITIVE_FLAG ),
70: CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY,
71: CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE,
72: LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
73: LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,

Line 76: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, NULL,CREATED_BY_MODULE, X_CREATED_BY_MODULE )

72: LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
73: LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
74: LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
75: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
76: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, NULL,CREATED_BY_MODULE, X_CREATED_BY_MODULE )
77: WHERE CRITERIA_ID = X_CRITERIA_ID;
78:
79:
80: EXCEPTION

Line 133: NVL( CRITERIA_PARAM_ID, FND_API.G_MISS_NUM ),

129:
130: BEGIN
131:
132: SELECT
133: NVL( CRITERIA_PARAM_ID, FND_API.G_MISS_NUM ),
134: NVL( CRITERIA_ID, FND_API.G_MISS_NUM ),
135: NVL( RULE_DETAIL_ID, FND_API.G_MISS_NUM ),
136: NVL( CONDITION, FND_API.G_MISS_CHAR ),
137: NVL( PARAM_VALUE, FND_API.G_MISS_CHAR ),

Line 134: NVL( CRITERIA_ID, FND_API.G_MISS_NUM ),

130: BEGIN
131:
132: SELECT
133: NVL( CRITERIA_PARAM_ID, FND_API.G_MISS_NUM ),
134: NVL( CRITERIA_ID, FND_API.G_MISS_NUM ),
135: NVL( RULE_DETAIL_ID, FND_API.G_MISS_NUM ),
136: NVL( CONDITION, FND_API.G_MISS_CHAR ),
137: NVL( PARAM_VALUE, FND_API.G_MISS_CHAR ),
138: NVL( CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR ),

Line 135: NVL( RULE_DETAIL_ID, FND_API.G_MISS_NUM ),

131:
132: SELECT
133: NVL( CRITERIA_PARAM_ID, FND_API.G_MISS_NUM ),
134: NVL( CRITERIA_ID, FND_API.G_MISS_NUM ),
135: NVL( RULE_DETAIL_ID, FND_API.G_MISS_NUM ),
136: NVL( CONDITION, FND_API.G_MISS_CHAR ),
137: NVL( PARAM_VALUE, FND_API.G_MISS_CHAR ),
138: NVL( CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR ),
139: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR )

Line 136: NVL( CONDITION, FND_API.G_MISS_CHAR ),

132: SELECT
133: NVL( CRITERIA_PARAM_ID, FND_API.G_MISS_NUM ),
134: NVL( CRITERIA_ID, FND_API.G_MISS_NUM ),
135: NVL( RULE_DETAIL_ID, FND_API.G_MISS_NUM ),
136: NVL( CONDITION, FND_API.G_MISS_CHAR ),
137: NVL( PARAM_VALUE, FND_API.G_MISS_CHAR ),
138: NVL( CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR ),
139: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR )
140: INTO

Line 137: NVL( PARAM_VALUE, FND_API.G_MISS_CHAR ),

133: NVL( CRITERIA_PARAM_ID, FND_API.G_MISS_NUM ),
134: NVL( CRITERIA_ID, FND_API.G_MISS_NUM ),
135: NVL( RULE_DETAIL_ID, FND_API.G_MISS_NUM ),
136: NVL( CONDITION, FND_API.G_MISS_CHAR ),
137: NVL( PARAM_VALUE, FND_API.G_MISS_CHAR ),
138: NVL( CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR ),
139: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR )
140: INTO
141: X_CRITERIA_PARAM_ID,

Line 138: NVL( CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR ),

134: NVL( CRITERIA_ID, FND_API.G_MISS_NUM ),
135: NVL( RULE_DETAIL_ID, FND_API.G_MISS_NUM ),
136: NVL( CONDITION, FND_API.G_MISS_CHAR ),
137: NVL( PARAM_VALUE, FND_API.G_MISS_CHAR ),
138: NVL( CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR ),
139: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR )
140: INTO
141: X_CRITERIA_PARAM_ID,
142: X_CRITERIA_ID,

Line 139: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR )

135: NVL( RULE_DETAIL_ID, FND_API.G_MISS_NUM ),
136: NVL( CONDITION, FND_API.G_MISS_CHAR ),
137: NVL( PARAM_VALUE, FND_API.G_MISS_CHAR ),
138: NVL( CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR ),
139: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR )
140: INTO
141: X_CRITERIA_PARAM_ID,
142: X_CRITERIA_ID,
143: X_RULE_DETAIL_ID,

Line 159: RAISE FND_API.G_EXC_ERROR;

155: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_NO_RECORD' );
156: FND_MESSAGE.SET_TOKEN( 'RECORD', 'p_rule_criteria_rec');
157: FND_MESSAGE.SET_TOKEN( 'VALUE', X_CRITERIA_ID );
158: FND_MSG_PUB.ADD;
159: RAISE FND_API.G_EXC_ERROR;
160:
161: END Select_Row;
162:
163: PROCEDURE Delete_Row (