DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_NUMBER_TBL_TYPE

Line 3217: p_folder_ids IN system.cz_number_tbl_type,

3213: */
3214:
3215: PROCEDURE copy_repository_folders
3216: (
3217: p_folder_ids IN system.cz_number_tbl_type,
3218: p_encl_folder_id IN NUMBER,
3219: x_folder_id OUT NOCOPY NUMBER,
3220: x_run_id OUT NOCOPY NUMBER,
3221: x_return_status OUT NOCOPY VARCHAR2,

Line 11657: p_self_eff_set_id IN system.cz_number_tbl_type)

11653: FUNCTION get_visibility(p_parent_psnode_id IN NUMBER,
11654: p_parent_expl_id IN NUMBER,
11655: p_self_eff_from IN system.cz_date_tbl_type,
11656: p_self_eff_until IN system.cz_date_tbl_type,
11657: p_self_eff_set_id IN system.cz_number_tbl_type)
11658: RETURN system.cz_number_tbl_type IS
11659:
11660: v_parent_id NUMBER := p_parent_psnode_id;
11661: v_expl_id NUMBER := p_parent_expl_id;

Line 11658: RETURN system.cz_number_tbl_type IS

11654: p_parent_expl_id IN NUMBER,
11655: p_self_eff_from IN system.cz_date_tbl_type,
11656: p_self_eff_until IN system.cz_date_tbl_type,
11657: p_self_eff_set_id IN system.cz_number_tbl_type)
11658: RETURN system.cz_number_tbl_type IS
11659:
11660: v_parent_id NUMBER := p_parent_psnode_id;
11661: v_expl_id NUMBER := p_parent_expl_id;
11662: v_eff_from DATE;

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

11664: v_eff_set_id NUMBER;
11665:
11666: v_filter VARCHAR2(240);
11667: v_flag PLS_INTEGER;
11668: v_return system.cz_number_tbl_type := system.cz_number_tbl_type();
11669:
11670: TYPE date_hash_table IS TABLE OF DATE INDEX BY BINARY_INTEGER;
11671: h_eff_from date_hash_table;
11672: h_eff_until date_hash_table;

Line 11786: p_self_eff_set_id IN system.cz_number_tbl_type,

11782: PROCEDURE get_visibility(p_parent_psnode_id IN NUMBER,
11783: p_parent_expl_id IN NUMBER,
11784: p_self_eff_from IN system.cz_date_tbl_type,
11785: p_self_eff_until IN system.cz_date_tbl_type,
11786: p_self_eff_set_id IN system.cz_number_tbl_type,
11787: x_is_visible IN OUT NOCOPY system.cz_number_tbl_type) IS
11788: BEGIN
11789: x_is_visible := get_visibility(p_parent_psnode_id,
11790: p_parent_expl_id,

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

11783: p_parent_expl_id IN NUMBER,
11784: p_self_eff_from IN system.cz_date_tbl_type,
11785: p_self_eff_until IN system.cz_date_tbl_type,
11786: p_self_eff_set_id IN system.cz_number_tbl_type,
11787: x_is_visible IN OUT NOCOPY system.cz_number_tbl_type) IS
11788: BEGIN
11789: x_is_visible := get_visibility(p_parent_psnode_id,
11790: p_parent_expl_id,
11791: p_self_eff_from,