APPS.ENG_CHANGE_LIFECYCLE_UTIL dependencies on ENG_TYPE_ORG_PROPERTIES

Line 2037: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;

2033: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
2034: l_imp_eco_flag VARCHAR2(1) := 'N';
2035:
2036: --l_co_type_id eng_engineering_changes.CHANGE_ORDER_TYPE_ID%TYPE;
2037: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;
2038: l_change_notice eng_engineering_changes.change_notice%TYPE;
2039: l_hierarchy_name per_organization_structures.name%TYPE;
2040: l_org_name org_organization_definitions.organization_name%TYPE;
2041: l_row_cnt NUMBER := 0;

Line 2051: FROM eng_type_org_properties op,

2047: SELECT op.auto_propagate_flag,
2048: ec.change_notice,
2049: pos.name,
2050: ood.name organization_name
2051: FROM eng_type_org_properties op,
2052: eng_engineering_changes ec,
2053: per_organization_structures pos,
2054: hr_all_organization_units_tl ood
2055: WHERE ec.change_id = p_change_id

Line 6703: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;

6699: l_pls_block VARCHAR2(5000);
6700: l_message_list Error_Handler.Error_Tbl_Type; --Bug 11825003
6701:
6702: -- for auto-propagation if it's defined for first phase
6703: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;
6704: l_change_notice eng_engineering_changes.change_notice%TYPE;
6705: l_hierarchy_name per_organization_structures.name%TYPE;
6706: l_org_name org_organization_definitions.organization_name%TYPE;
6707: l_row_cnt NUMBER := 0;

Line 6713: FROM eng_type_org_properties op,

6709: SELECT op.auto_propagate_flag,
6710: ec.change_notice,
6711: pos.name,
6712: ood.name organization_name
6713: FROM eng_type_org_properties op,
6714: eng_engineering_changes ec,
6715: per_organization_structures pos,
6716: hr_all_organization_units_tl ood
6717: WHERE ec.change_id = p_change_id