APPS.ENG_CHANGE_LIFECYCLE_UTIL dependencies on ENG_TYPE_ORG_PROPERTIES

Line 2011: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;

2007: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
2008: l_imp_eco_flag VARCHAR2(1) := 'N';
2009:
2010: --l_co_type_id eng_engineering_changes.CHANGE_ORDER_TYPE_ID%TYPE;
2011: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;
2012: l_change_notice eng_engineering_changes.change_notice%TYPE;
2013: l_hierarchy_name per_organization_structures.name%TYPE;
2014: l_org_name org_organization_definitions.organization_name%TYPE;
2015: l_row_cnt NUMBER := 0;

Line 2025: FROM eng_type_org_properties op,

2021: SELECT op.auto_propagate_flag,
2022: ec.change_notice,
2023: pos.name,
2024: ood.name organization_name
2025: FROM eng_type_org_properties op,
2026: eng_engineering_changes ec,
2027: per_organization_structures pos,
2028: hr_all_organization_units_tl ood
2029: WHERE ec.change_id = p_change_id

Line 6533: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;

6529:
6530: l_pls_block VARCHAR2(5000);
6531:
6532: -- for auto-propagation if it's defined for first phase
6533: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;
6534: l_change_notice eng_engineering_changes.change_notice%TYPE;
6535: l_hierarchy_name per_organization_structures.name%TYPE;
6536: l_org_name org_organization_definitions.organization_name%TYPE;
6537: l_row_cnt NUMBER := 0;

Line 6543: FROM eng_type_org_properties op,

6539: SELECT op.auto_propagate_flag,
6540: ec.change_notice,
6541: pos.name,
6542: ood.name organization_name
6543: FROM eng_type_org_properties op,
6544: eng_engineering_changes ec,
6545: per_organization_structures pos,
6546: hr_all_organization_units_tl ood
6547: WHERE ec.change_id = p_change_id