DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_NUMBER_TBL_TYPE

Line 3245: p_folder_ids IN system.cz_number_tbl_type,

3241: */
3242:
3243: PROCEDURE copy_repository_folders
3244: (
3245: p_folder_ids IN system.cz_number_tbl_type,
3246: p_encl_folder_id IN NUMBER,
3247: x_folder_id OUT NOCOPY NUMBER,
3248: x_run_id OUT NOCOPY NUMBER,
3249: x_return_status OUT NOCOPY VARCHAR2,

Line 11731: p_self_eff_set_id IN system.cz_number_tbl_type)

11727: FUNCTION get_visibility(p_parent_psnode_id IN NUMBER,
11728: p_parent_expl_id IN NUMBER,
11729: p_self_eff_from IN system.cz_date_tbl_type,
11730: p_self_eff_until IN system.cz_date_tbl_type,
11731: p_self_eff_set_id IN system.cz_number_tbl_type)
11732: RETURN system.cz_number_tbl_type IS
11733:
11734: v_parent_id NUMBER := p_parent_psnode_id;
11735: v_expl_id NUMBER := p_parent_expl_id;

Line 11732: RETURN system.cz_number_tbl_type IS

11728: p_parent_expl_id IN NUMBER,
11729: p_self_eff_from IN system.cz_date_tbl_type,
11730: p_self_eff_until IN system.cz_date_tbl_type,
11731: p_self_eff_set_id IN system.cz_number_tbl_type)
11732: RETURN system.cz_number_tbl_type IS
11733:
11734: v_parent_id NUMBER := p_parent_psnode_id;
11735: v_expl_id NUMBER := p_parent_expl_id;
11736: v_eff_from DATE;

Line 11742: v_return system.cz_number_tbl_type := system.cz_number_tbl_type();

11738: v_eff_set_id NUMBER;
11739:
11740: v_filter VARCHAR2(240);
11741: v_flag PLS_INTEGER;
11742: v_return system.cz_number_tbl_type := system.cz_number_tbl_type();
11743:
11744: TYPE date_hash_table IS TABLE OF DATE INDEX BY BINARY_INTEGER;
11745: h_eff_from date_hash_table;
11746: h_eff_until date_hash_table;

Line 11860: p_self_eff_set_id IN system.cz_number_tbl_type,

11856: PROCEDURE get_visibility(p_parent_psnode_id IN NUMBER,
11857: p_parent_expl_id IN NUMBER,
11858: p_self_eff_from IN system.cz_date_tbl_type,
11859: p_self_eff_until IN system.cz_date_tbl_type,
11860: p_self_eff_set_id IN system.cz_number_tbl_type,
11861: x_is_visible IN OUT NOCOPY system.cz_number_tbl_type) IS
11862: BEGIN
11863: x_is_visible := get_visibility(p_parent_psnode_id,
11864: p_parent_expl_id,

Line 11861: x_is_visible IN OUT NOCOPY system.cz_number_tbl_type) IS

11857: p_parent_expl_id IN NUMBER,
11858: p_self_eff_from IN system.cz_date_tbl_type,
11859: p_self_eff_until IN system.cz_date_tbl_type,
11860: p_self_eff_set_id IN system.cz_number_tbl_type,
11861: x_is_visible IN OUT NOCOPY system.cz_number_tbl_type) IS
11862: BEGIN
11863: x_is_visible := get_visibility(p_parent_psnode_id,
11864: p_parent_expl_id,
11865: p_self_eff_from,