APPS.FUN_RULE_CRIT_PARAMS_PKG dependencies on FUN_RULE_CRIT_PARAMS_B

Line 22: l_seq_val FUN_RULE_CRIT_PARAMS_B.CRITERIA_PARAM_ID%TYPE;

18: X_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
19: X_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
20: ) IS
21:
22: l_seq_val FUN_RULE_CRIT_PARAMS_B.CRITERIA_PARAM_ID%TYPE;
23:
24: begin
25:
26:

Line 31: insert into FUN_RULE_CRIT_PARAMS_B (

27: IF X_CRITERIA_PARAM_ID IS NULL THEN
28: select FUN_RULE_CRITERIA_PARAMS_S.NEXTVAL into l_seq_val from dual;
29: END IF;
30:
31: insert into FUN_RULE_CRIT_PARAMS_B (
32: CRITERIA_PARAM_ID,
33: RULE_OBJECT_ID,
34: PARAM_NAME,
35: DATA_TYPE,

Line 108: from FUN_RULE_CRIT_PARAMS_B

104: ) IS
105:
106: cursor c is select
107: OBJECT_VERSION_NUMBER
108: from FUN_RULE_CRIT_PARAMS_B
109: where CRITERIA_PARAM_ID = X_CRITERIA_PARAM_ID
110: for update of CRITERIA_PARAM_ID nowait;
111: recinfo c%rowtype;
112: begin

Line 148: l_rule_criteria_param_id FUN_RULE_CRIT_PARAMS_B.CRITERIA_PARAM_ID%TYPE;

144: X_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
145: X_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
146: ) IS
147:
148: l_rule_criteria_param_id FUN_RULE_CRIT_PARAMS_B.CRITERIA_PARAM_ID%TYPE;
149:
150: begin
151:
152: l_rule_criteria_param_id := X_CRITERIA_PARAM_ID;

Line 157: FROM FUN_RULE_CRIT_PARAMS_B

153:
154: IF X_CRITERIA_PARAM_ID IS NULL THEN
155:
156: SELECT CRITERIA_PARAM_ID INTO l_rule_criteria_param_id
157: FROM FUN_RULE_CRIT_PARAMS_B
158: WHERE PARAM_NAME = X_PARAM_NAME
159: AND RULE_OBJECT_ID = X_RULE_OBJECT_ID;
160:
161: END IF;

Line 163: update FUN_RULE_CRIT_PARAMS_B set

159: AND RULE_OBJECT_ID = X_RULE_OBJECT_ID;
160:
161: END IF;
162:
163: update FUN_RULE_CRIT_PARAMS_B set
164: RULE_OBJECT_ID = X_RULE_OBJECT_ID,
165: PARAM_NAME = X_PARAM_NAME,
166: DATA_TYPE = X_DATA_TYPE,
167: FLEX_VALUE_SET_ID = X_FLEX_VALUE_SET_ID,

Line 247: DELETE FUN_RULE_CRIT_PARAMS_B

243: PROCEDURE Delete_Row (X_CRITERIA_PARAM_ID IN NUMBER)
244: IS
245: BEGIN
246:
247: DELETE FUN_RULE_CRIT_PARAMS_B
248: WHERE CRITERIA_PARAM_ID = X_CRITERIA_PARAM_ID;
249:
250: IF ( SQL%NOTFOUND ) THEN
251: RAISE NO_DATA_FOUND;

Line 271: from FUN_RULE_CRIT_PARAMS_B B

267: BEGIN
268: delete from FUN_RULE_CRIT_PARAMS_TL T
269: where not exists
270: (select NULL
271: from FUN_RULE_CRIT_PARAMS_B B
272: where B.CRITERIA_PARAM_ID = T.CRITERIA_PARAM_ID
273: );
274:
275: update FUN_RULE_CRIT_PARAMS_TL T set (

Line 406: from FUN_RULE_CRIT_PARAMS_B

402: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
403:
404: select CRITERIA_PARAM_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
405: into cpid, db_luby, db_ludate
406: from FUN_RULE_CRIT_PARAMS_B
407: where RULE_OBJECT_ID = roid
408: and PARAM_NAME = X_PARAM_NAME;
409:
410: if (fnd_load_util.UPLOAD_TEST(

Line 511: from fun_rule_crit_params_b

507:
508: BEGIN
509: select criteria_param_id
510: into cpid
511: from fun_rule_crit_params_b
512: where rule_object_id = roid
513: and param_name = X_PARAM_NAME;
514: EXCEPTION
515: WHEN NO_DATA_FOUND THEN