DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on ENG_ORG_HIERARCHY_POLICIES

Line 4075: l_schedule_immediately ENG_ORG_HIERARCHY_POLICIES.SCHEDULE_IMMEDIATELY_FLAG%TYPE;

4071: ) IS
4072: l_status_code NUMBER;
4073: l_msg_count NUMBER;
4074: l_mesg_data VARCHAR2(2000);
4075: l_schedule_immediately ENG_ORG_HIERARCHY_POLICIES.SCHEDULE_IMMEDIATELY_FLAG%TYPE;
4076: l_new_status_type NUMBER;
4077: CURSOR c_get_schedule_enabled IS
4078: SELECT eohp.SCHEDULE_IMMEDIATELY_FLAG
4079: FROM ENG_ORG_HIERARCHY_POLICIES eohp, ENG_TYPE_ORG_HIERARCHIES etoh, eng_engineering_changes eec

Line 4079: FROM ENG_ORG_HIERARCHY_POLICIES eohp, ENG_TYPE_ORG_HIERARCHIES etoh, eng_engineering_changes eec

4075: l_schedule_immediately ENG_ORG_HIERARCHY_POLICIES.SCHEDULE_IMMEDIATELY_FLAG%TYPE;
4076: l_new_status_type NUMBER;
4077: CURSOR c_get_schedule_enabled IS
4078: SELECT eohp.SCHEDULE_IMMEDIATELY_FLAG
4079: FROM ENG_ORG_HIERARCHY_POLICIES eohp, ENG_TYPE_ORG_HIERARCHIES etoh, eng_engineering_changes eec
4080: WHERE eec.change_id = p_local_change_id
4081: AND eohp.organization_id = eec.organization_id
4082: AND eohp.SCHEDULE_IMMEDIATELY_FLAG = 'Y'
4083: AND eohp.change_type_org_hierarchy_id = etoh.change_type_org_hierarchy_id

Line 4469: FROM ENG_ORG_HIERARCHY_POLICIES

4465: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing ECO Fetch status..' );
4466: BEGIN
4467: SELECT 1
4468: INTO l_sched_immediately
4469: FROM ENG_ORG_HIERARCHY_POLICIES
4470: WHERE organization_id = p_local_organization_id
4471: AND SCHEDULE_IMMEDIATELY_FLAG = 'Y'
4472: AND change_type_org_hierarchy_id =
4473: (SELECT change_type_org_hierarchy_id