APPS.FUN_RULE_OBJECTS_PKG dependencies on FUN_RULE_OBJECTS_B

Line 32: l_seq_val FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE;

28: X_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
29: X_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
30: ) IS
31: l_roa_rowid varchar2(64);
32: l_seq_val FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE;
33: begin
34:
35: --
36: --Always derive the RULE_OBJECT_ID here else in INSERT_ROW proc for

Line 111: cursor C(id number) is select ROWID from FUN_RULE_OBJECTS_B

107: X_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
108: X_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
109: ) IS
110:
111: cursor C(id number) is select ROWID from FUN_RULE_OBJECTS_B
112: where APPLICATION_ID = X_APPLICATION_ID
113: and RULE_OBJECT_ID = id
114: ;
115:

Line 116: l_orig_rule_object_name FUN_RULE_OBJECTS_B.RULE_OBJECT_NAME%TYPE;

112: where APPLICATION_ID = X_APPLICATION_ID
113: and RULE_OBJECT_ID = id
114: ;
115:
116: l_orig_rule_object_name FUN_RULE_OBJECTS_B.RULE_OBJECT_NAME%TYPE;
117: l_parent_rule_object_id FUN_RULE_OBJECTS_B.PARENT_RULE_OBJECT_ID%TYPE := NULL;
118:
119: BEGIN
120:

Line 117: l_parent_rule_object_id FUN_RULE_OBJECTS_B.PARENT_RULE_OBJECT_ID%TYPE := NULL;

113: and RULE_OBJECT_ID = id
114: ;
115:
116: l_orig_rule_object_name FUN_RULE_OBJECTS_B.RULE_OBJECT_NAME%TYPE;
117: l_parent_rule_object_id FUN_RULE_OBJECTS_B.PARENT_RULE_OBJECT_ID%TYPE := NULL;
118:
119: BEGIN
120:
121: --Derive the parent_rule_object_id if the X_INSTANCE_LABEL is NOT NULL

Line 127: FROM FUN_RULE_OBJECTS_B

123:
124: BEGIN
125: IF (X_INSTANCE_LABEL IS NOT NULL OR X_ORG_ID IS NOT NULL) THEN
126: SELECT RULE_OBJECT_ID INTO l_parent_rule_object_id
127: FROM FUN_RULE_OBJECTS_B
128: WHERE RULE_OBJECT_NAME = X_RULE_OBJECT_NAME
129: AND UPPER(USE_INSTANCE_FLAG) = 'Y'
130: AND INSTANCE_LABEL IS NULL
131: AND ORG_ID IS NULL

Line 143: insert into FUN_RULE_OBJECTS_B (

139: -- Throwing an exception with hard coded message text
140: app_exception.raise_exception(exception_text=>'Invalid rule object name - '||X_RULE_OBJECT_NAME);
141: END ;
142:
143: insert into FUN_RULE_OBJECTS_B (
144: RULE_OBJECT_ID,
145: APPLICATION_ID,
146: RULE_OBJECT_NAME,
147: RESULT_TYPE,

Line 287: from FUN_RULE_OBJECTS_B

283: X_OBJECT_VERSION_NUMBER IN NUMBER
284: ) IS
285: cursor c is select
286: OBJECT_VERSION_NUMBER
287: from FUN_RULE_OBJECTS_B
288: where RULE_OBJECT_ID = X_RULE_OBJECT_ID
289: for update of RULE_OBJECT_ID nowait;
290: recinfo c%rowtype;
291:

Line 396: update FUN_RULE_OBJECTS_B set

392: X_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
393: ) is
394: begin
395:
396: update FUN_RULE_OBJECTS_B set
397: RULE_OBJECT_NAME = X_RULE_OBJECT_NAME,
398: RESULT_TYPE = X_RESULT_TYPE,
399: REQUIRED_FLAG = X_REQUIRED_FLAG,
400: USE_DEFAULT_VALUE_FLAG = X_USE_DEFAULT_VALUE_FLAG,

Line 467: from FUN_RULE_OBJECTS_B

463: begin
464:
465: delete from FUN_RULE_OBJ_ATTRIBUTES
466: where RULE_OBJECT_ID in (select RULE_OBJECT_ID
467: from FUN_RULE_OBJECTS_B
468: where RULE_OBJECT_NAME = X_RULE_OBJECT_NAME
469: AND APPLICATION_ID = X_APPLICATION_ID
470: );
471:

Line 478: from FUN_RULE_OBJECTS_B

474: end if;
475:
476: delete from FUN_RULE_OBJECTS_TL
477: where RULE_OBJECT_ID in (select RULE_OBJECT_ID
478: from FUN_RULE_OBJECTS_B
479: where RULE_OBJECT_NAME = X_RULE_OBJECT_NAME
480: AND APPLICATION_ID = X_APPLICATION_ID
481: );
482:

Line 487: delete from FUN_RULE_OBJECTS_B

483: if (sql%notfound) then
484: raise no_data_found;
485: end if;
486:
487: delete from FUN_RULE_OBJECTS_B
488: where RULE_OBJECT_NAME = X_RULE_OBJECT_NAME
489: AND APPLICATION_ID = X_APPLICATION_ID;
490:
491:

Line 507: delete from FUN_RULE_OBJECTS_B

503: X_ORG_ID IN NUMBER
504: ) IS
505: begin
506:
507: delete from FUN_RULE_OBJECTS_B
508: where RULE_OBJECT_NAME = X_RULE_OBJECT_NAME
509: AND APPLICATION_ID = X_APPLICATION_ID
510: AND
511: ( (INSTANCE_LABEL IS NULL AND X_INSTANCE_LABEL IS NULL) OR

Line 536: delete from FUN_RULE_OBJECTS_B

532: if (sql%notfound) then
533: raise no_data_found;
534: end if;
535:
536: delete from FUN_RULE_OBJECTS_B
537: where RULE_OBJECT_ID = X_RULE_OBJECT_ID;
538:
539: if (sql%notfound) then
540: raise no_data_found;

Line 775: from FUN_RULE_OBJECTS_B B

771: begin
772: delete from FUN_RULE_OBJECTS_TL T
773: where not exists
774: (select NULL
775: from FUN_RULE_OBJECTS_B B
776: where B.RULE_OBJECT_ID = T.RULE_OBJECT_ID
777: );
778:
779: update FUN_RULE_OBJECTS_TL T set (

Line 876: from FUN_RULE_OBJECTS_B

872:
873: BEGIN
874: select RULE_OBJECT_ID
875: into roid
876: from FUN_RULE_OBJECTS_B
877: where APPLICATION_ID = appid
878: and RULE_OBJECT_NAME = X_RULE_OBJECT_NAME
879: AND PARENT_RULE_OBJECT_ID IS NULL;
880:

Line 994: l_parent_rule_object_id fun_rule_objects_b.parent_rule_object_id%type;

990: f_ludate date; -- entity update date in file
991: db_luby number; -- entity owner in db
992: db_ludate date; -- entity update date in db
993: l_use_instance_flag VARCHAR2(1);
994: l_parent_rule_object_id fun_rule_objects_b.parent_rule_object_id%type;
995:
996: roid number;
997:
998: --For restoring the original values related to INSTANCE information.

Line 1007: FROM FUN_RULE_OBJECTS_B B

1003: B.USE_INSTANCE_FLAG,
1004: B.INSTANCE_LABEL,
1005: B.PARENT_RULE_OBJECT_ID,
1006: B.ORG_ID
1007: FROM FUN_RULE_OBJECTS_B B
1008: WHERE B.PARENT_RULE_OBJECT_ID = p_rule_object_id;
1009:
1010: begin
1011: --

Line 1053: from FUN_RULE_OBJECTS_B

1049: -- go through the INSERT routine.
1050:
1051: select RULE_OBJECT_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE , USE_INSTANCE_FLAG
1052: into roid, db_luby, db_ludate, l_use_instance_flag
1053: from FUN_RULE_OBJECTS_B
1054: where APPLICATION_ID = appid
1055: and RULE_OBJECT_NAME = X_RULE_OBJECT_NAME
1056: AND PARENT_RULE_OBJECT_ID IS NULL;
1057:

Line 1228: FROM FUN_RULE_OBJECTS_B

1224:
1225: BEGIN
1226: SELECT RULE_OBJECT_ID
1227: into roid
1228: FROM FUN_RULE_OBJECTS_B
1229: WHERE application_id = appid
1230: AND rule_object_name = X_RULE_OBJECT_NAME
1231: AND parent_rule_object_id IS NULL;
1232: EXCEPTION