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_EXPLMODEL_NODES_V

Line 11551: * @param p_parent_psnode_id correspond to cz_explmodel_nodes_v.effective_parent_id

11547: * on a node and given the node's parent identity and node's effectivity parameters it
11548: * returns 1 if the node is visible with the current effectivity filtering settings,
11549: * 0 otherwise.
11550: *
11551: * @param p_parent_psnode_id correspond to cz_explmodel_nodes_v.effective_parent_id
11552: * @param p_parent_expl_id correspond to cz_explmodel_nodes_v.parent_psnode_expl_id
11553: * p_model_id correspond to cz_explmodel_nodes_v.model_id
11554: * p_self_eff_from correspond to cz_explmodel_nodes_v.effective_from
11555: * p_self_eff_until correspond to cz_explmodel_nodes_v.effective_until

Line 11552: * @param p_parent_expl_id correspond to cz_explmodel_nodes_v.parent_psnode_expl_id

11548: * returns 1 if the node is visible with the current effectivity filtering settings,
11549: * 0 otherwise.
11550: *
11551: * @param p_parent_psnode_id correspond to cz_explmodel_nodes_v.effective_parent_id
11552: * @param p_parent_expl_id correspond to cz_explmodel_nodes_v.parent_psnode_expl_id
11553: * p_model_id correspond to cz_explmodel_nodes_v.model_id
11554: * p_self_eff_from correspond to cz_explmodel_nodes_v.effective_from
11555: * p_self_eff_until correspond to cz_explmodel_nodes_v.effective_until
11556: * p_self_eff_set_id correspond to cz_explmodel_nodes_v.effectivity_set_id

Line 11553: * p_model_id correspond to cz_explmodel_nodes_v.model_id

11549: * 0 otherwise.
11550: *
11551: * @param p_parent_psnode_id correspond to cz_explmodel_nodes_v.effective_parent_id
11552: * @param p_parent_expl_id correspond to cz_explmodel_nodes_v.parent_psnode_expl_id
11553: * p_model_id correspond to cz_explmodel_nodes_v.model_id
11554: * p_self_eff_from correspond to cz_explmodel_nodes_v.effective_from
11555: * p_self_eff_until correspond to cz_explmodel_nodes_v.effective_until
11556: * p_self_eff_set_id correspond to cz_explmodel_nodes_v.effectivity_set_id
11557: *

Line 11554: * p_self_eff_from correspond to cz_explmodel_nodes_v.effective_from

11550: *
11551: * @param p_parent_psnode_id correspond to cz_explmodel_nodes_v.effective_parent_id
11552: * @param p_parent_expl_id correspond to cz_explmodel_nodes_v.parent_psnode_expl_id
11553: * p_model_id correspond to cz_explmodel_nodes_v.model_id
11554: * p_self_eff_from correspond to cz_explmodel_nodes_v.effective_from
11555: * p_self_eff_until correspond to cz_explmodel_nodes_v.effective_until
11556: * p_self_eff_set_id correspond to cz_explmodel_nodes_v.effectivity_set_id
11557: *
11558: * @rep:scope public

Line 11555: * p_self_eff_until correspond to cz_explmodel_nodes_v.effective_until

11551: * @param p_parent_psnode_id correspond to cz_explmodel_nodes_v.effective_parent_id
11552: * @param p_parent_expl_id correspond to cz_explmodel_nodes_v.parent_psnode_expl_id
11553: * p_model_id correspond to cz_explmodel_nodes_v.model_id
11554: * p_self_eff_from correspond to cz_explmodel_nodes_v.effective_from
11555: * p_self_eff_until correspond to cz_explmodel_nodes_v.effective_until
11556: * p_self_eff_set_id correspond to cz_explmodel_nodes_v.effectivity_set_id
11557: *
11558: * @rep:scope public
11559: * @rep:product CZ

Line 11556: * p_self_eff_set_id correspond to cz_explmodel_nodes_v.effectivity_set_id

11552: * @param p_parent_expl_id correspond to cz_explmodel_nodes_v.parent_psnode_expl_id
11553: * p_model_id correspond to cz_explmodel_nodes_v.model_id
11554: * p_self_eff_from correspond to cz_explmodel_nodes_v.effective_from
11555: * p_self_eff_until correspond to cz_explmodel_nodes_v.effective_until
11556: * p_self_eff_set_id correspond to cz_explmodel_nodes_v.effectivity_set_id
11557: *
11558: * @rep:scope public
11559: * @rep:product CZ
11560: * @rep:displayname Auxiliary function for using in CZ_EXPLNODES_IMAGE_EFF_V

Line 11586: --v_parent_id (cz_explmodel_nodes_v.effective_parent_id) can only be null for the root model node

11582: h_eff_from date_hash_table;
11583: h_eff_until date_hash_table;
11584: BEGIN
11585:
11586: --v_parent_id (cz_explmodel_nodes_v.effective_parent_id) can only be null for the root model node
11587: --which is always effective by definition, so we don't even have to read the profile value, just
11588: --return 1 immediately.
11589:
11590: WHILE(v_parent_id IS NOT NULL)LOOP

Line 11625: FROM cz_explmodel_nodes_v

11621: )THEN RETURN 0; END IF;
11622:
11623: SELECT effective_parent_id, parent_psnode_expl_id, effective_from, effective_until, effectivity_set_id
11624: INTO v_parent_id, v_expl_id, v_eff_from, v_eff_until, v_eff_set_id
11625: FROM cz_explmodel_nodes_v
11626: WHERE model_id = p_model_id
11627: AND model_ref_expl_id = v_expl_id
11628: AND ps_node_id = v_parent_id;
11629: