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 1739: l_object_type cz_rule_folders.object_type%type;

1735: l_exprnode_tbl t_int_array_tbl_type_idx_vc2;--t_num_array_tbl_type; Not used anywhere.
1736: l_parent_exprnode_tbl t_int_array_tbl_type_idx_vc2;--t_num_array_tbl_type;
1737: l_key NUMBER;
1738: l_new_parent NUMBER;
1739: l_object_type cz_rule_folders.object_type%type;
1740: l_effective_from DATE;
1741: l_effective_until DATE;
1742: l_effective_set_id NUMBER;
1743: l_devl_project_id NUMBER;

Line 1788: FROM CZ_RULE_FOLDERS

1784: IF (l_rule_type NOT IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION,
1785: RULE_TYPE_CAPTION, RULE_TYPE_JAVA_SYS_PROP)) THEN
1786: BEGIN
1787: SELECT object_type INTO l_object_type
1788: FROM CZ_RULE_FOLDERS
1789: WHERE rule_folder_id=p_rule_folder_id
1790: AND object_type IN ('RFL','RSQ')
1791: AND deleted_flag='0';
1792: EXCEPTION

Line 2073: FROM CZ_RULE_FOLDERS

2069: );
2070:
2071: SELECT NVL(MAX(tree_seq),0)+1
2072: INTO l_new_tree_seq
2073: FROM CZ_RULE_FOLDERS
2074: WHERE parent_rule_folder_id=l_new_rfl_id
2075: AND deleted_flag='0';
2076:
2077: INSERT INTO CZ_RULE_FOLDERS

Line 2077: INSERT INTO CZ_RULE_FOLDERS

2073: FROM CZ_RULE_FOLDERS
2074: WHERE parent_rule_folder_id=l_new_rfl_id
2075: AND deleted_flag='0';
2076:
2077: INSERT INTO CZ_RULE_FOLDERS
2078: (RULE_FOLDER_ID,
2079: FOLDER_TYPE,
2080: NAME,
2081: DESC_TEXT,

Line 2115: FROM CZ_RULE_FOLDERS

2111: CHECKOUT_USER,
2112: OBJECT_TYPE,
2113: DISABLED_FLAG,
2114: ORIG_SYS_REF
2115: FROM CZ_RULE_FOLDERS
2116: WHERE rule_folder_id=p_rule_id AND parent_rule_folder_id = l_rule_folder_id AND deleted_flag='0';
2117:
2118: END LOOP;
2119:

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

2538:
2539: END IF;
2540:
2541: BEGIN
2542: SELECT CZ_RULE_FOLDERS_S.NEXTVAL INTO x_out_rule_folder_id FROM dual;
2543: INSERT INTO CZ_RULE_FOLDERS
2544: (RULE_FOLDER_ID,
2545: FOLDER_TYPE,
2546: NAME,

Line 2543: INSERT INTO CZ_RULE_FOLDERS

2539: END IF;
2540:
2541: BEGIN
2542: SELECT CZ_RULE_FOLDERS_S.NEXTVAL INTO x_out_rule_folder_id FROM dual;
2543: INSERT INTO CZ_RULE_FOLDERS
2544: (RULE_FOLDER_ID,
2545: FOLDER_TYPE,
2546: NAME,
2547: DESC_TEXT,

Line 2581: FROM CZ_RULE_FOLDERS

2577: CHECKOUT_USER,
2578: OBJECT_TYPE,
2579: DISABLED_FLAG,
2580: ORIG_SYS_REF
2581: FROM CZ_RULE_FOLDERS
2582: WHERE rule_folder_id=p_rule_folder_id AND object_type IN ('RFL', 'RSQ') AND deleted_flag='0';
2583:
2584: FOR i IN (SELECT rule_folder_id, object_type FROM CZ_RULE_FOLDERS
2585: WHERE parent_rule_folder_id=p_rule_folder_id AND deleted_flag='0')

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

2580: ORIG_SYS_REF
2581: FROM CZ_RULE_FOLDERS
2582: WHERE rule_folder_id=p_rule_folder_id AND object_type IN ('RFL', 'RSQ') AND deleted_flag='0';
2583:
2584: FOR i IN (SELECT rule_folder_id, object_type FROM CZ_RULE_FOLDERS
2585: WHERE parent_rule_folder_id=p_rule_folder_id AND deleted_flag='0')
2586: LOOP
2587: IF i.object_type IN ('RFL', 'RSQ') THEN
2588: copy_rule_folder(p_rule_folder_id => i.rule_folder_id

Line 3207: INTO l_rule_folder_path,l_enclosing_folder FROM CZ_RULE_FOLDERS

3203:
3204: BEGIN
3205:
3206: SELECT name,NVL(parent_rule_folder_id,0)
3207: INTO l_rule_folder_path,l_enclosing_folder FROM CZ_RULE_FOLDERS
3208: WHERE rule_folder_id=p_rule_folder_id AND object_type=p_object_type AND deleted_flag='0';
3209:
3210: l_rule_folder_path := set_name_entity(l_rule_folder_path);
3211:

Line 3213: FOR i IN(SELECT name FROM CZ_RULE_FOLDERS

3209:
3210: l_rule_folder_path := set_name_entity(l_rule_folder_path);
3211:
3212: IF l_enclosing_folder<>0 THEN
3213: FOR i IN(SELECT name FROM CZ_RULE_FOLDERS
3214: START WITH rule_folder_id=l_enclosing_folder AND object_type='RFL' AND deleted_flag='0'
3215: CONNECT BY PRIOR parent_rule_folder_id=rule_folder_id
3216: AND deleted_flag='0' AND PRIOR deleted_flag='0'
3217: AND object_type='RFL' AND PRIOR object_type='RFL')

Line 4150: l_devl_project_id cz_rule_folders.devl_project_id%TYPE;

4146: l_checkout_user cz_devl_projects.checkout_user%TYPE;
4147: l_model_name_tbl t_varchar_array_tbl_type;
4148: l_rule_folder_id_tbl t_num_array_tbl_type;
4149: l_object_type_tbl t_varchar_array_tbl_type;
4150: l_devl_project_id cz_rule_folders.devl_project_id%TYPE;
4151: l_parent_rule_folder_id cz_rule_folders.parent_rule_folder_id%TYPE;
4152: l_rfl_name cz_rule_folders.name%TYPE;
4153:
4154: p_out_err INTEGER;

Line 4151: l_parent_rule_folder_id cz_rule_folders.parent_rule_folder_id%TYPE;

4147: l_model_name_tbl t_varchar_array_tbl_type;
4148: l_rule_folder_id_tbl t_num_array_tbl_type;
4149: l_object_type_tbl t_varchar_array_tbl_type;
4150: l_devl_project_id cz_rule_folders.devl_project_id%TYPE;
4151: l_parent_rule_folder_id cz_rule_folders.parent_rule_folder_id%TYPE;
4152: l_rfl_name cz_rule_folders.name%TYPE;
4153:
4154: p_out_err INTEGER;
4155: p_del_logically INTEGER:=1;

Line 4152: l_rfl_name cz_rule_folders.name%TYPE;

4148: l_rule_folder_id_tbl t_num_array_tbl_type;
4149: l_object_type_tbl t_varchar_array_tbl_type;
4150: l_devl_project_id cz_rule_folders.devl_project_id%TYPE;
4151: l_parent_rule_folder_id cz_rule_folders.parent_rule_folder_id%TYPE;
4152: l_rfl_name cz_rule_folders.name%TYPE;
4153:
4154: p_out_err INTEGER;
4155: p_del_logically INTEGER:=1;
4156:

Line 4171: FROM cz_rule_folders

4167:
4168: BEGIN
4169: SELECT devl_project_id, nvl(parent_rule_folder_id,0), name
4170: INTO l_devl_project_id, l_parent_rule_folder_id, l_rfl_name
4171: FROM cz_rule_folders
4172: WHERE rule_folder_id = p_rule_folder_id
4173: AND object_type = 'RFL'
4174: AND deleted_flag = '0';
4175: EXCEPTION

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

4209: RAISE RFL_LOCKED_EXCP;
4210: END IF;
4211: */
4212: ------------------------------------------------------------------------------------
4213: -- logically delete all from cz_rule_folders, the trigger takes care of other tables
4214: ------------------------------------------------------------------------------------
4215:
4216: l_rule_folder_id_tbl.delete;
4217: SELECT rule_folder_id, object_type

Line 4221: FROM cz_rule_folders

4217: SELECT rule_folder_id, object_type
4218: BULK
4219: COLLECT
4220: INTO l_rule_folder_id_tbl, l_object_type_tbl
4221: FROM cz_rule_folders
4222: START WITH rule_folder_id = p_rule_folder_id and object_type='RFL'
4223: CONNECT BY PRIOR rule_folder_id = parent_rule_folder_id
4224: AND PRIOR object_type in ('RFL','RSQ')
4225: AND PRIOR deleted_flag = '0'

Line 4231: update cz_rule_folders

4227:
4228: IF (l_rule_folder_id_tbl.COUNT > 0) THEN
4229:
4230: FOR i IN l_rule_folder_id_tbl.FIRST..l_rule_folder_id_tbl.LAST LOOP
4231: update cz_rule_folders
4232: set deleted_flag = '1'
4233: where rule_folder_id = l_rule_folder_id_tbl(i)
4234: and object_type=l_object_type_tbl(i);
4235: END LOOP;

Line 4329: l_rsq_name cz_rule_folders.name%TYPE;

4325: l_ui_def_tbl t_num_array_tbl_type; -- the referencing models
4326: l_model_name_tbl t_varchar_array_tbl_type;
4327: l_devl_project_id cz_ps_nodes.devl_project_id%TYPE;
4328:
4329: l_rsq_name cz_rule_folders.name%TYPE;
4330:
4331: p_out_err INTEGER;
4332: p_del_logically INTEGER:=1;
4333:

Line 4346: FROM cz_rule_folders

4342:
4343: BEGIN
4344: SELECT devl_project_id, name
4345: INTO l_devl_project_id, l_rsq_name
4346: FROM cz_rule_folders
4347: WHERE rule_folder_id = p_rule_sequence_id
4348: AND object_type = 'RSQ';
4349: EXCEPTION
4350: WHEN NO_DATA_FOUND THEN

Line 4390: UPDATE cz_rule_folders

4386: -------------------------
4387: -- delete the rule folder
4388: -------------------------
4389:
4390: UPDATE cz_rule_folders
4391: SET deleted_flag = '1'
4392: WHERE rule_folder_id = p_rule_sequence_id
4393: AND object_type = 'RSQ';
4394:

Line 10586: FOR folder IN (SELECT name FROM cz_rule_folders

10582: IF(v_rule_folder_id IS NULL OR v_rule_folder_id = -1)THEN RETURN v_rule_name; END IF;
10583:
10584: n_rule_name := LENGTHB(v_rule_name);
10585:
10586: FOR folder IN (SELECT name FROM cz_rule_folders
10587: WHERE deleted_flag = '0'
10588: AND parent_rule_folder_id IS NOT NULL
10589: START WITH rule_folder_id = v_rule_folder_id
10590: AND object_type = 'RFL'

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

11451: END runtime_relative_path;
11452:
11453: ---- this functions does validations required during the time of
11454: ---- moving a rule or rule folder to a different folder
11455: PROCEDURE is_rule_movable(p_src_rule_id IN cz_rule_folders.rule_folder_id%TYPE,
11456: p_src_rule_type IN cz_rule_folders.object_type%TYPE,
11457: p_tgt_rule_fld_id IN cz_rule_folders.rule_folder_id%TYPE,
11458: x_return_status OUT NOCOPY VARCHAR2,
11459: x_msg_count OUT NOCOPY NUMBER,

Line 11456: p_src_rule_type IN cz_rule_folders.object_type%TYPE,

11452:
11453: ---- this functions does validations required during the time of
11454: ---- moving a rule or rule folder to a different folder
11455: PROCEDURE is_rule_movable(p_src_rule_id IN cz_rule_folders.rule_folder_id%TYPE,
11456: p_src_rule_type IN cz_rule_folders.object_type%TYPE,
11457: p_tgt_rule_fld_id IN cz_rule_folders.rule_folder_id%TYPE,
11458: x_return_status OUT NOCOPY VARCHAR2,
11459: x_msg_count OUT NOCOPY NUMBER,
11460: x_msg_data OUT NOCOPY VARCHAR2)

Line 11457: p_tgt_rule_fld_id IN cz_rule_folders.rule_folder_id%TYPE,

11453: ---- this functions does validations required during the time of
11454: ---- moving a rule or rule folder to a different folder
11455: PROCEDURE is_rule_movable(p_src_rule_id IN cz_rule_folders.rule_folder_id%TYPE,
11456: p_src_rule_type IN cz_rule_folders.object_type%TYPE,
11457: p_tgt_rule_fld_id IN cz_rule_folders.rule_folder_id%TYPE,
11458: x_return_status OUT NOCOPY VARCHAR2,
11459: x_msg_count OUT NOCOPY NUMBER,
11460: x_msg_data OUT NOCOPY VARCHAR2)
11461: IS

Line 11464: l_src_object_type cz_rule_folders.object_type%TYPE;

11460: x_msg_data OUT NOCOPY VARCHAR2)
11461: IS
11462: TYPE t_ref is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
11463: l_src_rule_id NUMBER;
11464: l_src_object_type cz_rule_folders.object_type%TYPE;
11465: l_tgt_object_type cz_rule_folders.object_type%TYPE;
11466: l_tgt_rule_fld_id NUMBER;
11467: l_parent_rule_folder_id NUMBER;
11468: l_tgt_parent_fld_id NUMBER;

Line 11465: l_tgt_object_type cz_rule_folders.object_type%TYPE;

11461: IS
11462: TYPE t_ref is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
11463: l_src_rule_id NUMBER;
11464: l_src_object_type cz_rule_folders.object_type%TYPE;
11465: l_tgt_object_type cz_rule_folders.object_type%TYPE;
11466: l_tgt_rule_fld_id NUMBER;
11467: l_parent_rule_folder_id NUMBER;
11468: l_tgt_parent_fld_id NUMBER;
11469: l_deleted_flag VARCHAR2(1);

Line 11489: FROM cz_rule_folders

11485:
11486: BEGIN
11487: SELECT rule_folder_id,object_type,deleted_flag,parent_rule_folder_id,devl_project_id
11488: INTO l_src_rule_id,l_src_object_type,l_deleted_flag,l_parent_rule_folder_id,l_src_devl_project_id
11489: FROM cz_rule_folders
11490: WHERE cz_rule_folders.rule_folder_id = p_src_rule_id
11491: AND cz_rule_folders.object_type = p_src_rule_type;
11492: EXCEPTION
11493: WHEN NO_DATA_FOUND THEN

Line 11490: WHERE cz_rule_folders.rule_folder_id = p_src_rule_id

11486: BEGIN
11487: SELECT rule_folder_id,object_type,deleted_flag,parent_rule_folder_id,devl_project_id
11488: INTO l_src_rule_id,l_src_object_type,l_deleted_flag,l_parent_rule_folder_id,l_src_devl_project_id
11489: FROM cz_rule_folders
11490: WHERE cz_rule_folders.rule_folder_id = p_src_rule_id
11491: AND cz_rule_folders.object_type = p_src_rule_type;
11492: EXCEPTION
11493: WHEN NO_DATA_FOUND THEN
11494: l_src_rule_id := -1;

Line 11491: AND cz_rule_folders.object_type = p_src_rule_type;

11487: SELECT rule_folder_id,object_type,deleted_flag,parent_rule_folder_id,devl_project_id
11488: INTO l_src_rule_id,l_src_object_type,l_deleted_flag,l_parent_rule_folder_id,l_src_devl_project_id
11489: FROM cz_rule_folders
11490: WHERE cz_rule_folders.rule_folder_id = p_src_rule_id
11491: AND cz_rule_folders.object_type = p_src_rule_type;
11492: EXCEPTION
11493: WHEN NO_DATA_FOUND THEN
11494: l_src_rule_id := -1;
11495: END;

Line 11508: FROM cz_rule_folders

11504:
11505: BEGIN
11506: SELECT rule_folder_id,parent_rule_folder_id,devl_project_id,object_type
11507: INTO l_tgt_rule_fld_id,l_tgt_parent_fld_id,l_tgt_devl_project_id,l_tgt_object_type
11508: FROM cz_rule_folders
11509: WHERE cz_rule_folders.rule_folder_id = p_tgt_rule_fld_id
11510: AND cz_rule_folders.object_type IN ('RFL','RSQ')
11511: AND cz_rule_folders.deleted_flag = '0';
11512: EXCEPTION

Line 11509: WHERE cz_rule_folders.rule_folder_id = p_tgt_rule_fld_id

11505: BEGIN
11506: SELECT rule_folder_id,parent_rule_folder_id,devl_project_id,object_type
11507: INTO l_tgt_rule_fld_id,l_tgt_parent_fld_id,l_tgt_devl_project_id,l_tgt_object_type
11508: FROM cz_rule_folders
11509: WHERE cz_rule_folders.rule_folder_id = p_tgt_rule_fld_id
11510: AND cz_rule_folders.object_type IN ('RFL','RSQ')
11511: AND cz_rule_folders.deleted_flag = '0';
11512: EXCEPTION
11513: WHEN NO_DATA_FOUND THEN

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

11506: SELECT rule_folder_id,parent_rule_folder_id,devl_project_id,object_type
11507: INTO l_tgt_rule_fld_id,l_tgt_parent_fld_id,l_tgt_devl_project_id,l_tgt_object_type
11508: FROM cz_rule_folders
11509: WHERE cz_rule_folders.rule_folder_id = p_tgt_rule_fld_id
11510: AND cz_rule_folders.object_type IN ('RFL','RSQ')
11511: AND cz_rule_folders.deleted_flag = '0';
11512: EXCEPTION
11513: WHEN NO_DATA_FOUND THEN
11514: l_tgt_rule_fld_id := -1;

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

11507: INTO l_tgt_rule_fld_id,l_tgt_parent_fld_id,l_tgt_devl_project_id,l_tgt_object_type
11508: FROM cz_rule_folders
11509: WHERE cz_rule_folders.rule_folder_id = p_tgt_rule_fld_id
11510: AND cz_rule_folders.object_type IN ('RFL','RSQ')
11511: AND cz_rule_folders.deleted_flag = '0';
11512: EXCEPTION
11513: WHEN NO_DATA_FOUND THEN
11514: l_tgt_rule_fld_id := -1;
11515: END;

Line 11537: FROM cz_rule_folders

11533: SELECT rule_folder_id
11534: BULK
11535: COLLECT
11536: INTO l_rule_fld_tbl
11537: FROM cz_rule_folders
11538: WHERE cz_rule_folders.object_type = 'RFL'
11539: AND cz_rule_folders.deleted_flag = '0'
11540: START WITH cz_rule_folders.rule_folder_id = p_src_rule_id
11541: CONNECT BY PRIOR rule_folder_id = parent_rule_folder_id

Line 11538: WHERE cz_rule_folders.object_type = 'RFL'

11534: BULK
11535: COLLECT
11536: INTO l_rule_fld_tbl
11537: FROM cz_rule_folders
11538: WHERE cz_rule_folders.object_type = 'RFL'
11539: AND cz_rule_folders.deleted_flag = '0'
11540: START WITH cz_rule_folders.rule_folder_id = p_src_rule_id
11541: CONNECT BY PRIOR rule_folder_id = parent_rule_folder_id
11542: AND PRIOR object_type = 'RFL'

Line 11539: AND cz_rule_folders.deleted_flag = '0'

11535: COLLECT
11536: INTO l_rule_fld_tbl
11537: FROM cz_rule_folders
11538: WHERE cz_rule_folders.object_type = 'RFL'
11539: AND cz_rule_folders.deleted_flag = '0'
11540: START WITH cz_rule_folders.rule_folder_id = p_src_rule_id
11541: CONNECT BY PRIOR rule_folder_id = parent_rule_folder_id
11542: AND PRIOR object_type = 'RFL'
11543: AND PRIOR deleted_flag = '0';

Line 11540: START WITH cz_rule_folders.rule_folder_id = p_src_rule_id

11536: INTO l_rule_fld_tbl
11537: FROM cz_rule_folders
11538: WHERE cz_rule_folders.object_type = 'RFL'
11539: AND cz_rule_folders.deleted_flag = '0'
11540: START WITH cz_rule_folders.rule_folder_id = p_src_rule_id
11541: CONNECT BY PRIOR rule_folder_id = parent_rule_folder_id
11542: AND PRIOR object_type = 'RFL'
11543: AND PRIOR deleted_flag = '0';
11544: EXCEPTION