DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on ENG_ORG_HIERARCHY_POLICIES

Line 3950: l_schedule_immediately ENG_ORG_HIERARCHY_POLICIES.SCHEDULE_IMMEDIATELY_FLAG%TYPE;

3946: ) IS
3947: l_status_code NUMBER;
3948: l_msg_count NUMBER;
3949: l_mesg_data VARCHAR2(2000);
3950: l_schedule_immediately ENG_ORG_HIERARCHY_POLICIES.SCHEDULE_IMMEDIATELY_FLAG%TYPE;
3951: l_new_status_type NUMBER;
3952: CURSOR c_get_schedule_enabled IS
3953: SELECT eohp.SCHEDULE_IMMEDIATELY_FLAG
3954: FROM ENG_ORG_HIERARCHY_POLICIES eohp, ENG_TYPE_ORG_HIERARCHIES etoh, eng_engineering_changes eec

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

3950: l_schedule_immediately ENG_ORG_HIERARCHY_POLICIES.SCHEDULE_IMMEDIATELY_FLAG%TYPE;
3951: l_new_status_type NUMBER;
3952: CURSOR c_get_schedule_enabled IS
3953: SELECT eohp.SCHEDULE_IMMEDIATELY_FLAG
3954: FROM ENG_ORG_HIERARCHY_POLICIES eohp, ENG_TYPE_ORG_HIERARCHIES etoh, eng_engineering_changes eec
3955: WHERE eec.change_id = p_local_change_id
3956: AND eohp.organization_id = eec.organization_id
3957: AND eohp.SCHEDULE_IMMEDIATELY_FLAG = 'Y'
3958: AND eohp.change_type_org_hierarchy_id = etoh.change_type_org_hierarchy_id

Line 4344: FROM ENG_ORG_HIERARCHY_POLICIES

4340: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing ECO Fetch status..' );
4341: BEGIN
4342: SELECT 1
4343: INTO l_sched_immediately
4344: FROM ENG_ORG_HIERARCHY_POLICIES
4345: WHERE organization_id = p_local_organization_id
4346: AND SCHEDULE_IMMEDIATELY_FLAG = 'Y'
4347: AND change_type_org_hierarchy_id =
4348: (SELECT change_type_org_hierarchy_id