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.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_RULE_FOLDERS

Line 1711: l_object_type cz_rule_folders.object_type%type;

1707: l_exprnode_tbl t_num_array_tbl_type;
1708: l_parent_exprnode_tbl t_num_array_tbl_type;
1709: l_key NUMBER;
1710: l_new_parent NUMBER;
1711: l_object_type cz_rule_folders.object_type%type;
1712: l_effective_from DATE;
1713: l_effective_until DATE;
1714: l_effective_set_id NUMBER;
1715: l_devl_project_id NUMBER;

Line 1760: FROM CZ_RULE_FOLDERS

1756: IF (l_rule_type NOT IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION,
1757: RULE_TYPE_CAPTION, RULE_TYPE_JAVA_SYS_PROP)) THEN
1758: BEGIN
1759: SELECT object_type INTO l_object_type
1760: FROM CZ_RULE_FOLDERS
1761: WHERE rule_folder_id=p_rule_folder_id
1762: AND object_type IN ('RFL','RSQ')
1763: AND deleted_flag='0';
1764: EXCEPTION

Line 2045: FROM CZ_RULE_FOLDERS

2041: );
2042:
2043: SELECT NVL(MAX(tree_seq),0)+1
2044: INTO l_new_tree_seq
2045: FROM CZ_RULE_FOLDERS
2046: WHERE parent_rule_folder_id=l_new_rfl_id
2047: AND deleted_flag='0';
2048:
2049: INSERT INTO CZ_RULE_FOLDERS

Line 2049: INSERT INTO CZ_RULE_FOLDERS

2045: FROM CZ_RULE_FOLDERS
2046: WHERE parent_rule_folder_id=l_new_rfl_id
2047: AND deleted_flag='0';
2048:
2049: INSERT INTO CZ_RULE_FOLDERS
2050: (RULE_FOLDER_ID,
2051: FOLDER_TYPE,
2052: NAME,
2053: DESC_TEXT,

Line 2087: FROM CZ_RULE_FOLDERS

2083: CHECKOUT_USER,
2084: OBJECT_TYPE,
2085: DISABLED_FLAG,
2086: ORIG_SYS_REF
2087: FROM CZ_RULE_FOLDERS
2088: WHERE rule_folder_id=p_rule_id AND parent_rule_folder_id = l_rule_folder_id AND deleted_flag='0';
2089:
2090: END LOOP;
2091:

Line 2514: SELECT CZ_RULE_FOLDERS_S.NEXTVAL INTO x_out_rule_folder_id FROM dual;

2510:
2511: END IF;
2512:
2513: BEGIN
2514: SELECT CZ_RULE_FOLDERS_S.NEXTVAL INTO x_out_rule_folder_id FROM dual;
2515: INSERT INTO CZ_RULE_FOLDERS
2516: (RULE_FOLDER_ID,
2517: FOLDER_TYPE,
2518: NAME,

Line 2515: INSERT INTO CZ_RULE_FOLDERS

2511: END IF;
2512:
2513: BEGIN
2514: SELECT CZ_RULE_FOLDERS_S.NEXTVAL INTO x_out_rule_folder_id FROM dual;
2515: INSERT INTO CZ_RULE_FOLDERS
2516: (RULE_FOLDER_ID,
2517: FOLDER_TYPE,
2518: NAME,
2519: DESC_TEXT,

Line 2553: FROM CZ_RULE_FOLDERS

2549: CHECKOUT_USER,
2550: OBJECT_TYPE,
2551: DISABLED_FLAG,
2552: ORIG_SYS_REF
2553: FROM CZ_RULE_FOLDERS
2554: WHERE rule_folder_id=p_rule_folder_id AND object_type IN ('RFL', 'RSQ') AND deleted_flag='0';
2555:
2556: FOR i IN (SELECT rule_folder_id, object_type FROM CZ_RULE_FOLDERS
2557: WHERE parent_rule_folder_id=p_rule_folder_id AND deleted_flag='0')

Line 2556: FOR i IN (SELECT rule_folder_id, object_type FROM CZ_RULE_FOLDERS

2552: ORIG_SYS_REF
2553: FROM CZ_RULE_FOLDERS
2554: WHERE rule_folder_id=p_rule_folder_id AND object_type IN ('RFL', 'RSQ') AND deleted_flag='0';
2555:
2556: FOR i IN (SELECT rule_folder_id, object_type FROM CZ_RULE_FOLDERS
2557: WHERE parent_rule_folder_id=p_rule_folder_id AND deleted_flag='0')
2558: LOOP
2559: IF i.object_type IN ('RFL', 'RSQ') THEN
2560: copy_rule_folder(p_rule_folder_id => i.rule_folder_id

Line 3179: INTO l_rule_folder_path,l_enclosing_folder FROM CZ_RULE_FOLDERS

3175:
3176: BEGIN
3177:
3178: SELECT name,NVL(parent_rule_folder_id,0)
3179: INTO l_rule_folder_path,l_enclosing_folder FROM CZ_RULE_FOLDERS
3180: WHERE rule_folder_id=p_rule_folder_id AND object_type=p_object_type AND deleted_flag='0';
3181:
3182: l_rule_folder_path := set_name_entity(l_rule_folder_path);
3183:

Line 3185: FOR i IN(SELECT name FROM CZ_RULE_FOLDERS

3181:
3182: l_rule_folder_path := set_name_entity(l_rule_folder_path);
3183:
3184: IF l_enclosing_folder<>0 THEN
3185: FOR i IN(SELECT name FROM CZ_RULE_FOLDERS
3186: START WITH rule_folder_id=l_enclosing_folder AND object_type='RFL' AND deleted_flag='0'
3187: CONNECT BY PRIOR parent_rule_folder_id=rule_folder_id
3188: AND deleted_flag='0' AND PRIOR deleted_flag='0'
3189: AND object_type='RFL' AND PRIOR object_type='RFL')

Line 4122: l_devl_project_id cz_rule_folders.devl_project_id%TYPE;

4118: l_checkout_user cz_devl_projects.checkout_user%TYPE;
4119: l_model_name_tbl t_varchar_array_tbl_type;
4120: l_rule_folder_id_tbl t_num_array_tbl_type;
4121: l_object_type_tbl t_varchar_array_tbl_type;
4122: l_devl_project_id cz_rule_folders.devl_project_id%TYPE;
4123: l_parent_rule_folder_id cz_rule_folders.parent_rule_folder_id%TYPE;
4124: l_rfl_name cz_rule_folders.name%TYPE;
4125:
4126: p_out_err INTEGER;

Line 4123: l_parent_rule_folder_id cz_rule_folders.parent_rule_folder_id%TYPE;

4119: l_model_name_tbl t_varchar_array_tbl_type;
4120: l_rule_folder_id_tbl t_num_array_tbl_type;
4121: l_object_type_tbl t_varchar_array_tbl_type;
4122: l_devl_project_id cz_rule_folders.devl_project_id%TYPE;
4123: l_parent_rule_folder_id cz_rule_folders.parent_rule_folder_id%TYPE;
4124: l_rfl_name cz_rule_folders.name%TYPE;
4125:
4126: p_out_err INTEGER;
4127: p_del_logically INTEGER:=1;

Line 4124: l_rfl_name cz_rule_folders.name%TYPE;

4120: l_rule_folder_id_tbl t_num_array_tbl_type;
4121: l_object_type_tbl t_varchar_array_tbl_type;
4122: l_devl_project_id cz_rule_folders.devl_project_id%TYPE;
4123: l_parent_rule_folder_id cz_rule_folders.parent_rule_folder_id%TYPE;
4124: l_rfl_name cz_rule_folders.name%TYPE;
4125:
4126: p_out_err INTEGER;
4127: p_del_logically INTEGER:=1;
4128:

Line 4143: FROM cz_rule_folders

4139:
4140: BEGIN
4141: SELECT devl_project_id, nvl(parent_rule_folder_id,0), name
4142: INTO l_devl_project_id, l_parent_rule_folder_id, l_rfl_name
4143: FROM cz_rule_folders
4144: WHERE rule_folder_id = p_rule_folder_id
4145: AND object_type = 'RFL'
4146: AND deleted_flag = '0';
4147: EXCEPTION

Line 4185: -- logically delete all from cz_rule_folders, the trigger takes care of other tables

4181: RAISE RFL_LOCKED_EXCP;
4182: END IF;
4183: */
4184: ------------------------------------------------------------------------------------
4185: -- logically delete all from cz_rule_folders, the trigger takes care of other tables
4186: ------------------------------------------------------------------------------------
4187:
4188: l_rule_folder_id_tbl.delete;
4189: SELECT rule_folder_id, object_type

Line 4193: FROM cz_rule_folders

4189: SELECT rule_folder_id, object_type
4190: BULK
4191: COLLECT
4192: INTO l_rule_folder_id_tbl, l_object_type_tbl
4193: FROM cz_rule_folders
4194: START WITH rule_folder_id = p_rule_folder_id and object_type='RFL'
4195: CONNECT BY PRIOR rule_folder_id = parent_rule_folder_id
4196: AND PRIOR object_type in ('RFL','RSQ')
4197: AND PRIOR deleted_flag = '0'

Line 4203: update cz_rule_folders

4199:
4200: IF (l_rule_folder_id_tbl.COUNT > 0) THEN
4201:
4202: FOR i IN l_rule_folder_id_tbl.FIRST..l_rule_folder_id_tbl.LAST LOOP
4203: update cz_rule_folders
4204: set deleted_flag = '1'
4205: where rule_folder_id = l_rule_folder_id_tbl(i)
4206: and object_type=l_object_type_tbl(i);
4207: END LOOP;

Line 4301: l_rsq_name cz_rule_folders.name%TYPE;

4297: l_ui_def_tbl t_num_array_tbl_type; -- the referencing models
4298: l_model_name_tbl t_varchar_array_tbl_type;
4299: l_devl_project_id cz_ps_nodes.devl_project_id%TYPE;
4300:
4301: l_rsq_name cz_rule_folders.name%TYPE;
4302:
4303: p_out_err INTEGER;
4304: p_del_logically INTEGER:=1;
4305:

Line 4318: FROM cz_rule_folders

4314:
4315: BEGIN
4316: SELECT devl_project_id, name
4317: INTO l_devl_project_id, l_rsq_name
4318: FROM cz_rule_folders
4319: WHERE rule_folder_id = p_rule_sequence_id
4320: AND object_type = 'RSQ';
4321: EXCEPTION
4322: WHEN NO_DATA_FOUND THEN

Line 4362: UPDATE cz_rule_folders

4358: -------------------------
4359: -- delete the rule folder
4360: -------------------------
4361:
4362: UPDATE cz_rule_folders
4363: SET deleted_flag = '1'
4364: WHERE rule_folder_id = p_rule_sequence_id
4365: AND object_type = 'RSQ';
4366:

Line 10534: FOR folder IN (SELECT name FROM cz_rule_folders

10530: IF(v_rule_folder_id IS NULL OR v_rule_folder_id = -1)THEN RETURN v_rule_name; END IF;
10531:
10532: n_rule_name := LENGTHB(v_rule_name);
10533:
10534: FOR folder IN (SELECT name FROM cz_rule_folders
10535: WHERE deleted_flag = '0'
10536: AND parent_rule_folder_id IS NOT NULL
10537: START WITH rule_folder_id = v_rule_folder_id
10538: AND object_type = 'RFL'

Line 11381: PROCEDURE is_rule_movable(p_src_rule_id IN cz_rule_folders.rule_folder_id%TYPE,

11377: END runtime_relative_path;
11378:
11379: ---- this functions does validations required during the time of
11380: ---- moving a rule or rule folder to a different folder
11381: PROCEDURE is_rule_movable(p_src_rule_id IN cz_rule_folders.rule_folder_id%TYPE,
11382: p_src_rule_type IN cz_rule_folders.object_type%TYPE,
11383: p_tgt_rule_fld_id IN cz_rule_folders.rule_folder_id%TYPE,
11384: x_return_status OUT NOCOPY VARCHAR2,
11385: x_msg_count OUT NOCOPY NUMBER,

Line 11382: p_src_rule_type IN cz_rule_folders.object_type%TYPE,

11378:
11379: ---- this functions does validations required during the time of
11380: ---- moving a rule or rule folder to a different folder
11381: PROCEDURE is_rule_movable(p_src_rule_id IN cz_rule_folders.rule_folder_id%TYPE,
11382: p_src_rule_type IN cz_rule_folders.object_type%TYPE,
11383: p_tgt_rule_fld_id IN cz_rule_folders.rule_folder_id%TYPE,
11384: x_return_status OUT NOCOPY VARCHAR2,
11385: x_msg_count OUT NOCOPY NUMBER,
11386: x_msg_data OUT NOCOPY VARCHAR2)

Line 11383: p_tgt_rule_fld_id IN cz_rule_folders.rule_folder_id%TYPE,

11379: ---- this functions does validations required during the time of
11380: ---- moving a rule or rule folder to a different folder
11381: PROCEDURE is_rule_movable(p_src_rule_id IN cz_rule_folders.rule_folder_id%TYPE,
11382: p_src_rule_type IN cz_rule_folders.object_type%TYPE,
11383: p_tgt_rule_fld_id IN cz_rule_folders.rule_folder_id%TYPE,
11384: x_return_status OUT NOCOPY VARCHAR2,
11385: x_msg_count OUT NOCOPY NUMBER,
11386: x_msg_data OUT NOCOPY VARCHAR2)
11387: IS

Line 11390: l_src_object_type cz_rule_folders.object_type%TYPE;

11386: x_msg_data OUT NOCOPY VARCHAR2)
11387: IS
11388: TYPE t_ref is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
11389: l_src_rule_id NUMBER;
11390: l_src_object_type cz_rule_folders.object_type%TYPE;
11391: l_tgt_object_type cz_rule_folders.object_type%TYPE;
11392: l_tgt_rule_fld_id NUMBER;
11393: l_parent_rule_folder_id NUMBER;
11394: l_tgt_parent_fld_id NUMBER;

Line 11391: l_tgt_object_type cz_rule_folders.object_type%TYPE;

11387: IS
11388: TYPE t_ref is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
11389: l_src_rule_id NUMBER;
11390: l_src_object_type cz_rule_folders.object_type%TYPE;
11391: l_tgt_object_type cz_rule_folders.object_type%TYPE;
11392: l_tgt_rule_fld_id NUMBER;
11393: l_parent_rule_folder_id NUMBER;
11394: l_tgt_parent_fld_id NUMBER;
11395: l_deleted_flag VARCHAR2(1);

Line 11415: FROM cz_rule_folders

11411:
11412: BEGIN
11413: SELECT rule_folder_id,object_type,deleted_flag,parent_rule_folder_id,devl_project_id
11414: INTO l_src_rule_id,l_src_object_type,l_deleted_flag,l_parent_rule_folder_id,l_src_devl_project_id
11415: FROM cz_rule_folders
11416: WHERE cz_rule_folders.rule_folder_id = p_src_rule_id
11417: AND cz_rule_folders.object_type = p_src_rule_type;
11418: EXCEPTION
11419: WHEN NO_DATA_FOUND THEN

Line 11416: WHERE cz_rule_folders.rule_folder_id = p_src_rule_id

11412: BEGIN
11413: SELECT rule_folder_id,object_type,deleted_flag,parent_rule_folder_id,devl_project_id
11414: INTO l_src_rule_id,l_src_object_type,l_deleted_flag,l_parent_rule_folder_id,l_src_devl_project_id
11415: FROM cz_rule_folders
11416: WHERE cz_rule_folders.rule_folder_id = p_src_rule_id
11417: AND cz_rule_folders.object_type = p_src_rule_type;
11418: EXCEPTION
11419: WHEN NO_DATA_FOUND THEN
11420: l_src_rule_id := -1;

Line 11417: AND cz_rule_folders.object_type = p_src_rule_type;

11413: SELECT rule_folder_id,object_type,deleted_flag,parent_rule_folder_id,devl_project_id
11414: INTO l_src_rule_id,l_src_object_type,l_deleted_flag,l_parent_rule_folder_id,l_src_devl_project_id
11415: FROM cz_rule_folders
11416: WHERE cz_rule_folders.rule_folder_id = p_src_rule_id
11417: AND cz_rule_folders.object_type = p_src_rule_type;
11418: EXCEPTION
11419: WHEN NO_DATA_FOUND THEN
11420: l_src_rule_id := -1;
11421: END;

Line 11434: FROM cz_rule_folders

11430:
11431: BEGIN
11432: SELECT rule_folder_id,parent_rule_folder_id,devl_project_id,object_type
11433: INTO l_tgt_rule_fld_id,l_tgt_parent_fld_id,l_tgt_devl_project_id,l_tgt_object_type
11434: FROM cz_rule_folders
11435: WHERE cz_rule_folders.rule_folder_id = p_tgt_rule_fld_id
11436: AND cz_rule_folders.object_type IN ('RFL','RSQ')
11437: AND cz_rule_folders.deleted_flag = '0';
11438: EXCEPTION

Line 11435: WHERE cz_rule_folders.rule_folder_id = p_tgt_rule_fld_id

11431: BEGIN
11432: SELECT rule_folder_id,parent_rule_folder_id,devl_project_id,object_type
11433: INTO l_tgt_rule_fld_id,l_tgt_parent_fld_id,l_tgt_devl_project_id,l_tgt_object_type
11434: FROM cz_rule_folders
11435: WHERE cz_rule_folders.rule_folder_id = p_tgt_rule_fld_id
11436: AND cz_rule_folders.object_type IN ('RFL','RSQ')
11437: AND cz_rule_folders.deleted_flag = '0';
11438: EXCEPTION
11439: WHEN NO_DATA_FOUND THEN

Line 11436: AND cz_rule_folders.object_type IN ('RFL','RSQ')

11432: SELECT rule_folder_id,parent_rule_folder_id,devl_project_id,object_type
11433: INTO l_tgt_rule_fld_id,l_tgt_parent_fld_id,l_tgt_devl_project_id,l_tgt_object_type
11434: FROM cz_rule_folders
11435: WHERE cz_rule_folders.rule_folder_id = p_tgt_rule_fld_id
11436: AND cz_rule_folders.object_type IN ('RFL','RSQ')
11437: AND cz_rule_folders.deleted_flag = '0';
11438: EXCEPTION
11439: WHEN NO_DATA_FOUND THEN
11440: l_tgt_rule_fld_id := -1;

Line 11437: AND cz_rule_folders.deleted_flag = '0';

11433: INTO l_tgt_rule_fld_id,l_tgt_parent_fld_id,l_tgt_devl_project_id,l_tgt_object_type
11434: FROM cz_rule_folders
11435: WHERE cz_rule_folders.rule_folder_id = p_tgt_rule_fld_id
11436: AND cz_rule_folders.object_type IN ('RFL','RSQ')
11437: AND cz_rule_folders.deleted_flag = '0';
11438: EXCEPTION
11439: WHEN NO_DATA_FOUND THEN
11440: l_tgt_rule_fld_id := -1;
11441: END;

Line 11463: FROM cz_rule_folders

11459: SELECT rule_folder_id
11460: BULK
11461: COLLECT
11462: INTO l_rule_fld_tbl
11463: FROM cz_rule_folders
11464: WHERE cz_rule_folders.object_type = 'RFL'
11465: AND cz_rule_folders.deleted_flag = '0'
11466: START WITH cz_rule_folders.rule_folder_id = p_src_rule_id
11467: CONNECT BY PRIOR rule_folder_id = parent_rule_folder_id

Line 11464: WHERE cz_rule_folders.object_type = 'RFL'

11460: BULK
11461: COLLECT
11462: INTO l_rule_fld_tbl
11463: FROM cz_rule_folders
11464: WHERE cz_rule_folders.object_type = 'RFL'
11465: AND cz_rule_folders.deleted_flag = '0'
11466: START WITH cz_rule_folders.rule_folder_id = p_src_rule_id
11467: CONNECT BY PRIOR rule_folder_id = parent_rule_folder_id
11468: AND PRIOR object_type = 'RFL'

Line 11465: AND cz_rule_folders.deleted_flag = '0'

11461: COLLECT
11462: INTO l_rule_fld_tbl
11463: FROM cz_rule_folders
11464: WHERE cz_rule_folders.object_type = 'RFL'
11465: AND cz_rule_folders.deleted_flag = '0'
11466: START WITH cz_rule_folders.rule_folder_id = p_src_rule_id
11467: CONNECT BY PRIOR rule_folder_id = parent_rule_folder_id
11468: AND PRIOR object_type = 'RFL'
11469: AND PRIOR deleted_flag = '0';

Line 11466: START WITH cz_rule_folders.rule_folder_id = p_src_rule_id

11462: INTO l_rule_fld_tbl
11463: FROM cz_rule_folders
11464: WHERE cz_rule_folders.object_type = 'RFL'
11465: AND cz_rule_folders.deleted_flag = '0'
11466: START WITH cz_rule_folders.rule_folder_id = p_src_rule_id
11467: CONNECT BY PRIOR rule_folder_id = parent_rule_folder_id
11468: AND PRIOR object_type = 'RFL'
11469: AND PRIOR deleted_flag = '0';
11470: EXCEPTION