APPS.OM_SETUP_VALID_PKG dependencies on OE_SYS_PARAMETERS_ALL

Line 745: -- Table OE_SYSTEM_PARAMETERS_ALL is replace by OE_SYS_PARAMETERS_ALL

741: FUNCTION checkForOmOu( oper_unit NUMBER ) RETURN BOOLEAN AS
742: orgcount NUMBER;
743: BEGIN
744: -- Sys Param Change
745: -- Table OE_SYSTEM_PARAMETERS_ALL is replace by OE_SYS_PARAMETERS_ALL
746: SELECT COUNT(ORG_ID)
747: INTO orgcount
748: FROM OE_SYS_PARAMETERS_ALL
749: WHERE ORG_ID = oper_unit;

Line 748: FROM OE_SYS_PARAMETERS_ALL

744: -- Sys Param Change
745: -- Table OE_SYSTEM_PARAMETERS_ALL is replace by OE_SYS_PARAMETERS_ALL
746: SELECT COUNT(ORG_ID)
747: INTO orgcount
748: FROM OE_SYS_PARAMETERS_ALL
749: WHERE ORG_ID = oper_unit;
750: IF orgcount = 0 THEN
751: RETURN FALSE;
752: ELSE

Line 3006: -- Table oe_system_parameters_all is replaced by oe_sys_parameters_all

3002: END IF;
3003: FOR i IN 1..oulist.COUNT
3004: LOOP
3005: -- Sys param Change
3006: -- Table oe_system_parameters_all is replaced by oe_sys_parameters_all
3007: SELECT COUNT(*)
3008: INTO omcnt
3009: FROM OE_SYS_PARAMETERS_ALL
3010: WHERE ORG_ID = oulist(i);

Line 3009: FROM OE_SYS_PARAMETERS_ALL

3005: -- Sys param Change
3006: -- Table oe_system_parameters_all is replaced by oe_sys_parameters_all
3007: SELECT COUNT(*)
3008: INTO omcnt
3009: FROM OE_SYS_PARAMETERS_ALL
3010: WHERE ORG_ID = oulist(i);
3011: IF omcnt > 0 THEN
3012: BEGIN
3013: SELECT SET_OF_BOOKS_ID