DBA Data[Home] [Help]

APPS.FUN_RULE_DETAILS_PKG dependencies on FND_API

Line 139: NVL( RULE_NAME, FND_API.G_MISS_CHAR ),

135: ) IS
136:
137: BEGIN
138: SELECT
139: NVL( RULE_NAME, FND_API.G_MISS_CHAR ),
140: NVL( RULE_DETAIL_ID, FND_API.G_MISS_NUM ),
141: NVL( RULE_OBJECT_ID, FND_API.G_MISS_NUM ),
142: NVL( SEQ, FND_API.G_MISS_NUM ),
143: NVL( OPERATOR, FND_API.G_MISS_CHAR ),

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

136:
137: BEGIN
138: SELECT
139: NVL( RULE_NAME, FND_API.G_MISS_CHAR ),
140: NVL( RULE_DETAIL_ID, FND_API.G_MISS_NUM ),
141: NVL( RULE_OBJECT_ID, FND_API.G_MISS_NUM ),
142: NVL( SEQ, FND_API.G_MISS_NUM ),
143: NVL( OPERATOR, FND_API.G_MISS_CHAR ),
144: NVL( ENABLED_FLAG, FND_API.G_MISS_CHAR ),

Line 141: NVL( RULE_OBJECT_ID, FND_API.G_MISS_NUM ),

137: BEGIN
138: SELECT
139: NVL( RULE_NAME, FND_API.G_MISS_CHAR ),
140: NVL( RULE_DETAIL_ID, FND_API.G_MISS_NUM ),
141: NVL( RULE_OBJECT_ID, FND_API.G_MISS_NUM ),
142: NVL( SEQ, FND_API.G_MISS_NUM ),
143: NVL( OPERATOR, FND_API.G_MISS_CHAR ),
144: NVL( ENABLED_FLAG, FND_API.G_MISS_CHAR ),
145: NVL( RESULT_APPLICATION_ID, FND_API.G_MISS_NUM ),

Line 142: NVL( SEQ, FND_API.G_MISS_NUM ),

138: SELECT
139: NVL( RULE_NAME, FND_API.G_MISS_CHAR ),
140: NVL( RULE_DETAIL_ID, FND_API.G_MISS_NUM ),
141: NVL( RULE_OBJECT_ID, FND_API.G_MISS_NUM ),
142: NVL( SEQ, FND_API.G_MISS_NUM ),
143: NVL( OPERATOR, FND_API.G_MISS_CHAR ),
144: NVL( ENABLED_FLAG, FND_API.G_MISS_CHAR ),
145: NVL( RESULT_APPLICATION_ID, FND_API.G_MISS_NUM ),
146: NVL( RESULT_VALUE, FND_API.G_MISS_CHAR ),

Line 143: NVL( OPERATOR, FND_API.G_MISS_CHAR ),

139: NVL( RULE_NAME, FND_API.G_MISS_CHAR ),
140: NVL( RULE_DETAIL_ID, FND_API.G_MISS_NUM ),
141: NVL( RULE_OBJECT_ID, FND_API.G_MISS_NUM ),
142: NVL( SEQ, FND_API.G_MISS_NUM ),
143: NVL( OPERATOR, FND_API.G_MISS_CHAR ),
144: NVL( ENABLED_FLAG, FND_API.G_MISS_CHAR ),
145: NVL( RESULT_APPLICATION_ID, FND_API.G_MISS_NUM ),
146: NVL( RESULT_VALUE, FND_API.G_MISS_CHAR ),
147: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR )

Line 144: NVL( ENABLED_FLAG, FND_API.G_MISS_CHAR ),

140: NVL( RULE_DETAIL_ID, FND_API.G_MISS_NUM ),
141: NVL( RULE_OBJECT_ID, FND_API.G_MISS_NUM ),
142: NVL( SEQ, FND_API.G_MISS_NUM ),
143: NVL( OPERATOR, FND_API.G_MISS_CHAR ),
144: NVL( ENABLED_FLAG, FND_API.G_MISS_CHAR ),
145: NVL( RESULT_APPLICATION_ID, FND_API.G_MISS_NUM ),
146: NVL( RESULT_VALUE, FND_API.G_MISS_CHAR ),
147: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR )
148: INTO

Line 145: NVL( RESULT_APPLICATION_ID, FND_API.G_MISS_NUM ),

141: NVL( RULE_OBJECT_ID, FND_API.G_MISS_NUM ),
142: NVL( SEQ, FND_API.G_MISS_NUM ),
143: NVL( OPERATOR, FND_API.G_MISS_CHAR ),
144: NVL( ENABLED_FLAG, FND_API.G_MISS_CHAR ),
145: NVL( RESULT_APPLICATION_ID, FND_API.G_MISS_NUM ),
146: NVL( RESULT_VALUE, FND_API.G_MISS_CHAR ),
147: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR )
148: INTO
149: X_RULE_NAME,

Line 146: NVL( RESULT_VALUE, FND_API.G_MISS_CHAR ),

142: NVL( SEQ, FND_API.G_MISS_NUM ),
143: NVL( OPERATOR, FND_API.G_MISS_CHAR ),
144: NVL( ENABLED_FLAG, FND_API.G_MISS_CHAR ),
145: NVL( RESULT_APPLICATION_ID, FND_API.G_MISS_NUM ),
146: NVL( RESULT_VALUE, FND_API.G_MISS_CHAR ),
147: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR )
148: INTO
149: X_RULE_NAME,
150: X_RULE_DETAIL_ID,

Line 147: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR )

143: NVL( OPERATOR, FND_API.G_MISS_CHAR ),
144: NVL( ENABLED_FLAG, FND_API.G_MISS_CHAR ),
145: NVL( RESULT_APPLICATION_ID, FND_API.G_MISS_NUM ),
146: NVL( RESULT_VALUE, FND_API.G_MISS_CHAR ),
147: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR )
148: INTO
149: X_RULE_NAME,
150: X_RULE_DETAIL_ID,
151: X_RULE_OBJECT_ID,

Line 167: RAISE FND_API.G_EXC_ERROR;

163: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_NO_RECORD' );
164: FND_MESSAGE.SET_TOKEN( 'RECORD', 'p_rule_details_rec');
165: FND_MESSAGE.SET_TOKEN( 'VALUE', X_RULE_NAME );
166: FND_MSG_PUB.ADD;
167: RAISE FND_API.G_EXC_ERROR;
168: END Select_Row;
169:
170: PROCEDURE Delete_Row (
171: X_RULE_DETAIL_ID IN NUMBER