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 11625: * @param p_parent_psnode_id correspond to cz_explmodel_nodes_v.effective_parent_id

11621: * on a node and given the node's parent identity and node's effectivity parameters it
11622: * returns 1 if the node is visible with the current effectivity filtering settings,
11623: * 0 otherwise.
11624: *
11625: * @param p_parent_psnode_id correspond to cz_explmodel_nodes_v.effective_parent_id
11626: * @param p_parent_expl_id correspond to cz_explmodel_nodes_v.parent_psnode_expl_id
11627: * p_model_id correspond to cz_explmodel_nodes_v.model_id
11628: * p_self_eff_from correspond to cz_explmodel_nodes_v.effective_from
11629: * p_self_eff_until correspond to cz_explmodel_nodes_v.effective_until

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

11622: * returns 1 if the node is visible with the current effectivity filtering settings,
11623: * 0 otherwise.
11624: *
11625: * @param p_parent_psnode_id correspond to cz_explmodel_nodes_v.effective_parent_id
11626: * @param p_parent_expl_id correspond to cz_explmodel_nodes_v.parent_psnode_expl_id
11627: * p_model_id correspond to cz_explmodel_nodes_v.model_id
11628: * p_self_eff_from correspond to cz_explmodel_nodes_v.effective_from
11629: * p_self_eff_until correspond to cz_explmodel_nodes_v.effective_until
11630: * p_self_eff_set_id correspond to cz_explmodel_nodes_v.effectivity_set_id

Line 11627: * p_model_id correspond to cz_explmodel_nodes_v.model_id

11623: * 0 otherwise.
11624: *
11625: * @param p_parent_psnode_id correspond to cz_explmodel_nodes_v.effective_parent_id
11626: * @param p_parent_expl_id correspond to cz_explmodel_nodes_v.parent_psnode_expl_id
11627: * p_model_id correspond to cz_explmodel_nodes_v.model_id
11628: * p_self_eff_from correspond to cz_explmodel_nodes_v.effective_from
11629: * p_self_eff_until correspond to cz_explmodel_nodes_v.effective_until
11630: * p_self_eff_set_id correspond to cz_explmodel_nodes_v.effectivity_set_id
11631: *

Line 11628: * p_self_eff_from correspond to cz_explmodel_nodes_v.effective_from

11624: *
11625: * @param p_parent_psnode_id correspond to cz_explmodel_nodes_v.effective_parent_id
11626: * @param p_parent_expl_id correspond to cz_explmodel_nodes_v.parent_psnode_expl_id
11627: * p_model_id correspond to cz_explmodel_nodes_v.model_id
11628: * p_self_eff_from correspond to cz_explmodel_nodes_v.effective_from
11629: * p_self_eff_until correspond to cz_explmodel_nodes_v.effective_until
11630: * p_self_eff_set_id correspond to cz_explmodel_nodes_v.effectivity_set_id
11631: *
11632: * @rep:scope public

Line 11629: * p_self_eff_until correspond to cz_explmodel_nodes_v.effective_until

11625: * @param p_parent_psnode_id correspond to cz_explmodel_nodes_v.effective_parent_id
11626: * @param p_parent_expl_id correspond to cz_explmodel_nodes_v.parent_psnode_expl_id
11627: * p_model_id correspond to cz_explmodel_nodes_v.model_id
11628: * p_self_eff_from correspond to cz_explmodel_nodes_v.effective_from
11629: * p_self_eff_until correspond to cz_explmodel_nodes_v.effective_until
11630: * p_self_eff_set_id correspond to cz_explmodel_nodes_v.effectivity_set_id
11631: *
11632: * @rep:scope public
11633: * @rep:product CZ

Line 11630: * p_self_eff_set_id correspond to cz_explmodel_nodes_v.effectivity_set_id

11626: * @param p_parent_expl_id correspond to cz_explmodel_nodes_v.parent_psnode_expl_id
11627: * p_model_id correspond to cz_explmodel_nodes_v.model_id
11628: * p_self_eff_from correspond to cz_explmodel_nodes_v.effective_from
11629: * p_self_eff_until correspond to cz_explmodel_nodes_v.effective_until
11630: * p_self_eff_set_id correspond to cz_explmodel_nodes_v.effectivity_set_id
11631: *
11632: * @rep:scope public
11633: * @rep:product CZ
11634: * @rep:displayname Auxiliary function for using in CZ_EXPLNODES_IMAGE_EFF_V

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

11656: h_eff_from date_hash_table;
11657: h_eff_until date_hash_table;
11658: BEGIN
11659:
11660: --v_parent_id (cz_explmodel_nodes_v.effective_parent_id) can only be null for the root model node
11661: --which is always effective by definition, so we don't even have to read the profile value, just
11662: --return 1 immediately.
11663:
11664: WHILE(v_parent_id IS NOT NULL)LOOP

Line 11699: FROM cz_explmodel_nodes_v

11695: )THEN RETURN 0; END IF;
11696:
11697: SELECT effective_parent_id, parent_psnode_expl_id, effective_from, effective_until, effectivity_set_id
11698: INTO v_parent_id, v_expl_id, v_eff_from, v_eff_until, v_eff_set_id
11699: FROM cz_explmodel_nodes_v
11700: WHERE model_id = p_model_id
11701: AND model_ref_expl_id = v_expl_id
11702: AND ps_node_id = v_parent_id;
11703: