APPS.AMW_SETUP_RISK_TYPES_PVT dependencies on AMW_COMPLIANCE_ENV_ASSOCS

Line 38: -- Delete associations records in AMW_COMPLIANCE_ENV_ASSOCS

34: -- Procedure name
35: -- Delete_Risk_Types
36: -- Purpose
37: -- Delete specified risk type and its descendant.
38: -- Delete associations records in AMW_COMPLIANCE_ENV_ASSOCS
39: -- for the specified risk type and its descendant.
40: -- ===============================================================
41: PROCEDURE Delete_Risk_Types(
42: p_setup_risk_type_id IN NUMBER,

Line 320: amw_compliance_env_assocs compEnv

316: cursor is_assoc_risk_c (l_setup_risk_type_id IN NUMBER, l_risk_rev_id IN NUMBER, l_compliance_env_id IN NUMBER) is
317: SELECT assoc.risk_type_id
318: from amw_risk_type assoc,
319: amw_setup_risk_types_b rt,
320: amw_compliance_env_assocs compEnv
321: where assoc.risk_rev_id = l_risk_rev_id
322: and rt.setup_risk_type_id = l_setup_risk_type_id
323: and assoc.risk_type_code = rt.risk_type_code
324: and compEnv.object_type = 'SETUP_RISK_TYPE'

Line 650: from amw_compliance_env_assocs

646:
647: -- find the associated compliance env of specified setup risk type
648: cursor get_assoc_env_c (l_setup_risk_type_id IN NUMBER) is
649: SELECT COMPLIANCE_ENV_ID
650: from amw_compliance_env_assocs
651: where OBJECT_TYPE = 'SETUP_RISK_TYPE'
652: and PK1 = l_setup_risk_type_id;
653:
654: BEGIN

Line 691: IF ('N' = AMW_COMPLIANCE_ENV_ASSOCS_PVT.COMPLIANCE_ENVS_PRESENT(

687:
688: FOR i in 1 .. last_index LOOP
689: -- if the passed-in p_parent_setup_risk_type_id is not yet associated with compliance_env_list(i)
690: -- than p_parent_setup_risk_type_id cannot have child p_target_setup_risk_type_id
691: IF ('N' = AMW_COMPLIANCE_ENV_ASSOCS_PVT.COMPLIANCE_ENVS_PRESENT(
692: p_compliance_env_id => compliance_env_list(i)
693: ,p_object_type => 'SETUP_RISK_TYPE'
694: ,p_pk1 => p_parent_setup_risk_type_id)) THEN
695: canHaveChild := 'N';